Recent content by MAVIS

Good Evening, I wonder if anyone could help me out ?? I have a form on which there are multiple text boxes. All of them are unbound however what I would like to be able to do is that on each occasion that I open this form each respective text box would automatically update itself and display a...

Very many thanks for the prompt response - it works an absolute treat. Hopefully one day i'll be able to grasp the concepts in full and be more of a contributor toward the various forum's. Ta very much Regards Mavis

I am trying to construct a query so that when I click a Command Button it searches between 2 combo box dates which have Calendar controls on them, and returns records of all my Staff who joined our organisation between a selected time-frame. I only want it to search from one table called STAFF...

Good Afternoon to you all --- Help……. Can someone please point me in the right direction regarding an 'on the fly query' that I have. The one that I currently use, and have great success with, involves extracting records by means of four combo boxes which point to the data held within a...

Very many thanks Jon K for your timely and helpful response - it worked a treat.

Hello once again - This question is based on one that I previously asked yesterday,however it now concerns displaying a result of the amount of 'Yes' or 'No' selections returned from A field containing a Yes/No checkbox. I have a field called InOffice and would like to view the amount of 'Yes'...

Taff, Many thanks for your advice on the above subject -it works a treat! Mavis :)

Can anyone help ? I am a new beginner on the Database/Access scene and my question is this... How do I display the total number of records from one of my tables (tbl STAFF) so that it is displayed as a 3-digit number in a separate text box. What I would like to have is a series of text boxes...

I am trying to create a Database to record all the personnel in my Department. I have one table called ‘Staff ‘and in that table I have created one field with their individual names along with the 10 fields, each of which represent specific qualifications that that each post needs in order to do...