There are 2 forms using the same select query to create a drop-down. -The first form is small and wide, and works correctly with-out any issues or...

I'm trying to get to one form from another in an Access database but keep getting the message above. Can anyone please help me understand why? I'm using...

"the wizard is unable to open your query in datasheet mode, possibly because another user has a source table open in exclusive mode. your query will be...

I am using Access 2003. I created a form for my database to edit/enter new data. Within the form, I inserted a tab control box with three pages, and within...

Hello, I've got a database with several linked tables (Foreign-Keys with Autonnumber-fields). As recommended I have an ID-Field in every table. For editing...

The following code is adapted from Allen Browne’s “Using a Combo Box to Find Records� Tip. Dim rs As DAO.Recordset If Not IsNull(Me.cboMoveTo)...

Im sorry, I have done some research on how to protect a form with a password, I found some info. but I dont quite understand it (Im a new user in MS Access). ...

When seaching data base with the intent of entering data on my form the above message pops up. between 1 & 3 clicks on OK gets rid of it . This problem...

Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table....

I nearly have all my ducks in a row with a project I have been working on. Now down to the final dash and have completed all the necessary help files. All I...

I have this code on a form to tell me how many records are in the form ="Looking at " & Count() & " Calls Scheduled in this Query" (displayed above my...

Hope I can be helped! Here’s the error message: “You tried to assign a Null value to a variable that is not a Variant data type�. Here’s the...

What do I do when I get a "Your time has expired" message on the computer when I click over onto a object in the database? -- Message posted via...

Hi, I have the following two tables; 1) Houses {HouseID(Primary Key),Address, Postcode, Landlord} 2) Landlords {Landlord(Primary Key), Address, Postcode} I...

I am a novice on Access. I created a form that adds records to a table. I included a button that adds the record to the table. When I click the 'Add...

I'm consolidating 23 different databases down to 5. I'm rebuilding them to use/recycle common code/functions. What I want to to do is 'bind' the print...

Is there something in MS Access that would allow for using a 'browse' button to search for other files on a network? -- Thanks, Steve D

Hi there, I have been working on a database for my golf club that records then prints prize vouchers for our competitions. I have an "Event Table", primary key...

Simple question really, when a user scrolls through a set of records and goes past or before the last and first record, they get the error message "Cannot find...

How can i execute code when the access database application closes. is there a way to hook into a 'database_close' event, or the like? thanks!