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

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

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.

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

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.

I have a form created with a Combo box. What I need is when you select a certain object in the Combo box that a new field appears that allows you to enter comments. Thanks in advance for your help.