I need to find out what key stage pupils are at by reference to their date of birth and it's got me stumped. The key stages are in years running from 1st...

I want to have my form set to sort by a particular field each time it opens. My reference book says to use Order by property in the table and OrderByProperty...

I'm trying to use a parameter query to show records which contain a specific keyword - When I run the parameter query no records are selected. The field which...

Help... I want to use one form to enter data into 2 tables. One table called Car1 One called car 2 All fields within the tables are the same except the...

Given: TblSurveyResponse SurveyResponseID ResponderID SurveyItemID ResponseYesNo Can a single SQL be written to return all ResponderIDs who annswered Yes...

hi there, i am a new user of access, just want to try something out. i do not understand my defaut language settins can not apply to access. i set the defaut...

My multiple column combo-box in a form is based on a 10 column select query. In form view, the combo-box only returns 1 column. How can I make it show all 10?

I have text box with code in the after_update event. The code is very simple = "Testing this event" My problem is that if the form is set to AllowAdditions...

Can someone explain to me what this message means and what causes it? It seems to happen when I try to set focus to a control. This is on a form that navigates...

How would I add a jpeg image into access for a splash screen?

I have a field with numbers like 12122000. I need to format this into the date format mm/dd/yyyy, 12/12/2000. What is the best way to accomplish this?

Am relatively new to access, and am trying to set up an artifacts database and I need to have several drop down menus involved - any advice will be muchly...

I would like to set up on my motor enthusiasts site, a free database for users to add details for their vehicles for sale as in typical (obviously very...

I am running a query based on dates. I am using the between and operant. My problem is that the query does not include the end date. If I put...

Am I able to use access as a database for my website.

Hello, I am testing a table structure, and want to delete all of the records, which are primary keyed with auto number. If I just delete the records, and...

hi, I have a access table that has a counter field which has data type auto number. But in my datasheet view, say the below data: Counter Product 01 ...

hi i have an MSAccess about a state agent, i want to create a query that remindes me about the rents due by the tenant within the next 7 days,however i have...

I have an access 97 database that I am attempting to open in access 2003. It sez: "unrecognized database format'C:documents and settings\My...

I have a report already created with certain information. I want to create another report that only includes a few items from the original report. How do I...