Search results for query: *

Thank you. That did the trick.

Hi, I was wondering if there is a way to turn off the ability of Adobe to open a pdf right after it is created.

I ran MS Office updates and it seems to work now.

I just tried a new form and get the same error.

As soon as I click on my form to place the command button, I get the error. If I click ok on the error, it will bring up the wizard, but all the choices are missing and I get the error again. So I can't even get to the part where I try to assign an action.

I am trying to add a command button to my form. When I use the wizard I get an Invalid Use of Null error. Has anyone encountered this? I am using Access 2003. I have searched this forum and microsoft, but found no answers. Thank you.

I made a typo in the 3rd paragraph: the filter by location when run again, "does not" filter by my new location selection.

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

Thanks, Duane. That worked great!!

I tried your suggestion with the code below: stLinkCriteria = "[CNo]=""" & Me![cmbCNO] & """ AND [AdmitDate]= #" & _ Forms![frmGetRecord]![frmSubGetRecord].Form![AdmitDate] & "# AND [DischDate]= #" & _ Forms![frmGetRecord]![frmSubGetRecord].Form![DischDate] & "#" This is what I got in...

When I put the AND inside quotes, I get a compile error, Expected: end of statement

If I break the string stLinkCriteria into separate pieces to test each value, the immediate window displays the correct value. When I put the whole string together, nothing shows in the immediate window and I get the type mismatch error.

[CNO] is a text field.

I have changed the string to below and now receive a type mismatch error when I try to run this. stLinkCriteria = "[CNo]=" & "'" & Me![cmbCNO] & "'" _ And "[AdmitDate]=" & "#" & Forms![frmGetRecord]![frmSubGetRecord].Form![AdmitDate] & "#" _ And "[DischDate]=" & "#" &...

I am using the DoCmd.Openform to open another form based on the values in a subform. I have the string variable below to place in the where criteria of the of DoCmd. Two of the fields I need to reference are on the subform. I get an error message that Access can't find the field...

I have 2 forms. The first form frmGetRecord has a combobox to get a patient number. This form also has a subform. The subform displays admission/discharge dates. There can be multiple admission/discharge records for a patient. I would like to select a record from the subform. When I click...

I not only had to move the fields to the detail section, I also had to move the find button off the tab control to another section of the form. Now it works.

All fields on the form are bound to the same datasource. I have 2 fields (id#, name) at the top of the form in the form header section. The tab control is in the detail section. The find record button is in the detail section on the first page of the tab control. I get errors when I try to...

The tab control fields are connected to the datasource of the form. I do not have any subforms. I can search data in the tab control fields, but not the data in fields above the tab control.

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