Search results

I am trying to set a multiple field index on a table. I would like to use 3 fields. One is a text field, the other two are date fields. The text field and one date field will always have a value. The other date field can either have a value or no value. The index will work if I only use the...

When I try to add a command button using the Command Button Wizard I get an Invalid Use of Null error. I am using Access 2003. I have successfully added other controls to the form. I have searched Microsoft and the forum for help, has anyone encountered this problem?

I am trying to setup a query that will generate a report based on options selected on a form. The fields I am using in the table do not have data for every record. If the criteria in the query is left blank, I would like all records listed regardless of whether there is a value in that field...

I have searched and found references to converting text to dates. I need to go the other way. I have client# field and a date field. I would like to make an update query to populate a new field by concatenating the two fields minus the "/". I am making a new key field in an existing table...

I have a form that opens with a filter for active records based on a date field value of null. On my form I have a button to show active records with a date field value of null and a button to show all records regardless of date value. These buttons work fine. I have another button that...

I have a form(frmGetRecord) with a subform(frmSubGetRecord). frmGetRecord has a combobox cmbCNO to choose the patient. The subform displays the admit date and discharge date(if there is one). There can be multiple admit/Discharge dates for a patient. Based on the values from fields on the...

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...

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 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?

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...