Search results

I have a form with a form header section that contains a combo box and a text box. The form also has a detail section that has a tab control that contains the rest of the data entry boxes. I put a Find Record button in the detail section of my form. When I try to Find Record using the...

I found the instructions at the following site very helpful and easy to follow in creating a popup calendar: http://www.fontstuff.com/access/acctut09pfv.htm

Thank you. I found what I needed.

A pre-existing table was created with lastname, firstname contained in one field. I would like to create a new table with a separate field for lname & fname. Is there a way to take the existing names and put them in separate fields? (Some contain a middle initial as well)

I have multiple reports I would like to use this code in. If I save this code as a module, can the On No Data event call a module? If so, how?

I have the On No Data event of my report show a message box that no data exists for the time period entered. The message box works, but the report still opens showing errors because there is no data. Is there a way for me to stop the report from opening after I display the message box?

Thank you. That and a couple minor changes to the code fixed my problem.

After searching through some postings on duplicate records, I found some references to using code in the Before Update event to detect duplicates. I tried the code below, but receive a compile error when it hits the line: Dim rsc as DAO.Recordset. I am new to using VBA, could someone help me...

I would like to add a record to my table, tblReviews. I select a value from the combobox to fill in the name, location, and date for a person. Before I fill in those text boxes, I would like to make sure a duplicate entry does not exist for this person. On the BeforeUpdate property of the...

What I have is a medical record review form. When the form opens, you can go through records that are already entered for patients. At the top of the form is a combobox that shows the patient id - when you click the arrow to select a patient, I show the id#, last & first name. When I add a...

When I run the query I have dates in the field - no null values.

I am using a bound textbox. The control source is a field from the query that populates the form. The format property is short date, which corresponds to the property of the field in the table.

llkhoutx, Your reply to Biggy helped me with a similar problem I was having. I am using the code to fill fields on a form, not a table. I am having one problem. In one of the text boxes on my form I would like to fill in the date from the table. I keep getting an error message that there is...