Recent content by ITProg

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