DLookup Problem
Hi,I am attempting to use a SetValue Macro to lookup a three digit zipcode in a table that corresponds to the city a user selects in a particular drop down box and then display it in a new field.I have the following code in the Setvalue macroItem: [Forms]![Freight]![DestZip1]Expression: =DLookUp...more info...
dlookup or acFindRec
Hi there,I want to use either one of the above to find a record ina large database from a form.I understand if I use a dlookup I may also be able to copythe previous record into the current form which would behelpful.So far every adjustment of code I have done (after readinghelp files) to incorp...more info...
Dlookup in a macro condition statement
Does anyone know what the syntax and format should be for using DLOOKUP as a condition in a macro?I am trying to basically run macro1 if the value in tableA exists in tableB ....or run macro2 if the value in tableA DOES NOTexist in table B.I know how to write and use a dlookup when comparing a v...more info...
Dlookup Criteria Problem
Hi -I am having a problem with DLookup. I have a table with a field calledCOMMENTS. This field is a text field. A record might have htefollowing information under this field: "Called person on 06/11/2004".Each record in the table has information under the COMMENTS field andeach information conta...more info...
dlookup
I am trying to open up a form based on a table and restricting the records to a field on the main form..Ex. main form has a drop down combo box based on company names in company table, once you choose the company the company form opens up filtered or restricted to just the companies chosen on th...more info...
Division by zero
Your data must be changing every other day. It's a dataerror.>--Original Message-->I get this error when I run a macro that contains queries>and other macros. The error does not happen all the>time. It happens every other day. Please help!>.>...more info...
Division by zero
I get this error when I run a macro that contains queriesand other macros. The error does not happen all thetime. It happens every other day. Please help!...more info...
Displaying the date when a macro was last run
I have a macro set up to update information from a server. How can I show onthe switchboard when the macro was last run?...more info...
Display query name in macro
Does anyone have a quick way to dispay the name of the query that iscurrently running when runnig a macro?...more info...
Display query name in macro
hijust prior to runnng the query, you can display a messagebox stating which query is about to run but this wouldrequire that you close the box before the query runs.oyou could also create a small form with 2 labels(1saying "current query running is" and 1 for thequeryname), call the form just p...more info...
Display PDF
Hi,I have a tabel with a field containing the path to a pdf-file.Can anybody help me to display the file from a form?Cor van Loon...more info...
display only records that meet my criteria
I am trying to create a macro that opens a form and displays a message boxif trueand only shows the records that meet my criteria if the condition is trueif no records match I want it to go to the next criteria in another form....more info...