On a continuous form I have a text box with a DlookUp function as its control source: =DLookUp("","tblStdAmds"," =" & !!.!) However, the last (new) record...

I would like to have a command button that reopens the form my users are using. How can I do something like this? Thanks, john

Hi, This form is used by many users (about 30 users/day), many times a day (about 40 times/day). One of the field is called "Employee nbr". For...

Hi, I've created a command button on a subform (continuous forms) which runs the code below in it's On_Click event. It adds 8 new records if the RecordSet is...

I am trying to create a button in Access 2000 that will either Save/Update the record that was modified, or if the record does not exist in the table, add it...

I cannot tab to the first entry in a subform datasheet from the last entry in the form to enter information. Can someone help? Thanks! -- Linda

I found this code from an access website. It's supposed to give a warning only if there is a change to a previously entered record. It does work, except it...

My text box only allows me to enter 48 characters, and then beeps if I try to enter more. I've changed the width of the column in the table, played with the...

Glenn, In the OnCurrent Event of the form type this: Me!ID.SetFocus HTH, Josh "Glenn" wrote in...

I have squeezed my headers and footers for both page and detail sections of my form, but I still have about a 2" footer, any ideas why?

I have a form with multiple check boxes in two different categories. Usually only one or two check boxes need to be checked per record (so I have default set...

Does anyone know a way to extract the month and year from a 'date' field and place the month and year in separate fields called 'month' and 'year'? I have...

I have a form based off of a query with a combobox that looks up information from TableA and the selection updates an existing record in TableB. I used the...

Hello, I have a form with a footer that currently displays for each record. How can I hide the footer after the the user leaves the first record. I...

I have a form with text boxes and combo boxes on. When the "Status" combo box value is "Closed" i want the form to open with every txt box and combo...

This problem is driving me crackers and I would appreciate any suggestions and help that anybody supplies. My proble is that my query is based on two tables...

Is there a conversion issue when converting an Access 2 or 97 database to Access 2003, specifically when using the in-built find function? I have a database...

Hi, I have a form with a listbox that works fine with only one user logged in on the database. When a second user logs in and opens the same form the...

I have a simple form with a listbox(SelectScreen) that shows all names and social security numbers in the database. I use this list to select the correct name...

I have a form with a combobox (off course). When the user changes the value of the combobox I want to display certain records. I know will need (or I suppose)...