Recent content by ksimmsa

I have a form that you enter various zip codes and it gives you the distance between the to zip codes. I need to be able to enter numerous zip codes into the form and return the nearest city. The code I am using is: Private Sub ZipCode1_Exit(Cancel As Integer) If ZipCode1 <> "" Then...

Thanks, i got it If Me!ChooseResultCode = True Then If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and " stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " & ((Str(Trim(Me![SpecificResultCode])))) End If

thanks. i figured it out If Me!ChooseResultCode = True Then If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and " stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " & ((Str(Trim(Me![SpecificResultCode])))) End If

I need to Convert the code from a text field to code for a number field: If Me.SpecificResultCode = True Then If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and " stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " & "" & (Trim(Me.SpecificResultCode))...

PHV, thanks. How do i close the tread?

dbo_customers.QuitCode is a string field.

I changed it to: If Me!ChooseQuitCode = True Then If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and " stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] =" & ((Me!ChooseQuitCode)) End If and it is not recognizing it. thanks.....I do i close out...

Thanks, HarleyQuinn, but now i;m getting a the following error: data type mismatch in criteria expression. Also how do i close out this thread? thanks again.

I’m trying to update the coding for a report. I am having problems with the coding on the form. I have it broken down by certain criteria and they are all working, but one and I can seem to figure this one out. It looking up a number field and I am using the following syntax: If...

i have several users that are using Office 2003, but the db was created using Office 2000 and the are having problem opening forms and reports. what do i need to do so they are able to use the db. thanks in advance for your help.

I need to run quarterly reports and have separate columns for each month in the quarter. Thanks in advance for your help.

No, I don't want the users to have access to the entire 64k. I want to limit them to 500 characters.

I have a table that I need to store large free form comments. I have it set to memo, but is it possible to limit the amount of characters from 64,000. thanks in advance for your help

I have a form created, but I need to change the table the data is stored in. Thanks in advance for your help.

I have a form with a check box for each item being entered on the form. When I select the check box for a different item it changes every item on the form. THANKS in advance for you help!!!!!