Search results for query: *

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

i'm trying to create a formula that is the following fields do not total more than two enteries that is will caculate zero. AvgValue1: (([Monitoring]![Sup call 1a])+([Monitoring]![Sup call 2a])+([Monitoring]![Sup call 3a])+([Monitoring]![Sup call4a])+([Monitoring]![Sup call...

Query 1 SELECT DISTINCTROW Sum([qryCallbackComplet Query].Closed) AS [Count] FROM [qryCallbackComplet Query]; Query 2 SELECT Count(*) AS [Count] FROM qryDateRange GROUP BY qryDateRange.[Follow Up Date] HAVING (((qryDateRange.[Follow Up Date]) Is Null)) ORDER BY Count(*);

I have 2 separate queries that I need to combine to create one report. What steps to I need to take to create the report? Thanks in advance for you help.

How large or how much data can the database hold. I have a DB with several large tables. I back up the DB daily, but at what point should I look to make a posible purge, create a new DB or is there a way to store the old info and still be able to access it form the main database? Thanks in...

I have a report in Access based off of a query that has a date range. I need to have the selected date range to appear at the header of the report. Thanks in advance for you help.