Search Result

Brilstern · Feb 1 '12, 07:10 AM

Q: I am getting "invalid use of null" error. Whats wrong?!?

The goal in this command is to first create a individual report "rptECR" for each SSN in tblBand Members. Next, save each report as a PDF and name each PDF the expression [location] and save into selected folder strMonth.

tblBand Members

Code:

Field                      Type
    Rank                       Text
    FName

...

CapriPHR · Jan 5 '12, 02:13 PM

Hello all.

I am trying to use DLookup to auto-populate fields in an otherwise simple database. I am using Access 2010. I have created three different databases and the code still does not work. I think there may be glitches in this particular copy of the program. Please evaluate the details below and tell me what you think.

Table 1 has fields: Product ID, CustomerName, CustomerAddr, and ComplaintLevel.

Table...

James Grant · May 15 '11, 06:20 AM

Hi Everyone,

I've created a database (MS Access 2003) to help monitor staffing at my work.

I now need to transcribe data from one table (tblPositions) into another (tblTeams) based on a common column (Position ID). Essentially I wish to copy the [Position title] and [Position description] of different positions from tblPositions, into tblTeams according to their already recorded [Position ID] (this is to make the data more...

katia · Feb 24 '11, 10:10 PM

Hello;
I am stuck, and would like to resolve my problem.

Am using Access 2003

I have a form that has the file path in a memo field.
I have a list box for the list of files in the folder for the filepath
When I move to the record, I would like the listbox to populate with the most recent files in the folder from the file path that is on the the form
Sometimes there is no file path, or an invalid one, so need

...

Lisa B · Jan 11 '11, 05:53 PM

I have created a combo box

SELECT Vendeurs.Vendeu rID, Vendeurs.[Last Name], Vendeurs.[First Name] FROM Vendeurs GROUP BY Vendeurs.Vendeu rID, Vendeurs.[Last Name], Vendeurs.[First Name];

This successfuly returns the first name and last name, and i'm able to autofill a text box with the first name pulled from the combo box

I want to add another txt box on the form that gives me their team name. I have a...

John Desselle · Dec 10 '10, 03:35 PM

I have a simple ZipCode - City/State dlookup function in my database:

Code:

Private Sub cboZip_AfterUpdate()
    strCity = DLookup("[City]", "[tblZIPS]", "[ZIP] = " & [ZIP])
    strState = DLookup("[State]", "[tblZIPS]", "[ZIP] = " & [ZIP])
    strZipCode = DLookup("[Zip]", "[tblZIPS]", "[ZIP] = " & [ZIP])

...

Brendan Wolf · Nov 30 '10, 03:10 PM

Good Morning,

I would like to validate a value entered in a textbox to make sure it matches one of the values in a table. The approach I took is a dlookup, but I can only get it to work for one of the values (the first one)

Here is my code

Code:

If Me.AFOs.Value <> DLookup("AFO", "AFO_LOOKUP", "Office = '" & Me.Approver_Office.Value & "'") Then Me.AFOs.enabled

...

Bob Kraft · Nov 1 '10, 09:58 PM

I have an mdb that I am running in Vista/Access 2007 and it was working fine. I moved everything to Windows 7 and the database is working well except (so far) some DLookup commands that are coming up with blanks instead of the data (a first and last name) expected. Anyone know why? Thanks.

Brendan Wolf · Oct 29 '10, 05:34 PM

Happy Halloween all,

I have been struggling at work with a DLookup using multiple criteria. I would like a text box to display the results of a DLookup based on the values selected in three comboboxes and the table that runs them all. Here is my code:

Code:

 

Private Sub Subverbs_GotFocus()
'When the Subverbs gets focus it looks up proper subverbs from Authority_Lookup table
Me.Subverbs = DLookup("[Subverbs]",

...

Chris24 · Sep 9 '10, 06:41 PM

I have a form with a Combo box and a button.
I want the user to be able to choose an option in the combo box, click the button, and a related .pdf is opened.

The Combo box has a control source in a table. Within the same record as the control source, a 2nd column contains a hyperlink with a file path to a related .pdf.

What I am struggling with is the code associated with the clicking of the button.
How...

jasmineeyes · Jul 11 '10, 07:28 PM

i've beat my head on the table for this n spent hours searching the net but i cant find out whats wrong.. (btw, i'm pretty new to access..)

i've got a Customers table with information on customers, and another table, Customer Transactions. ive got a lookup box in the customer tranasactions table that looks up the customer code. i want the customer name and delivery address to automatically pop in their fields..

i tried...

dawn123 · Jul 9 '10, 11:25 AM

I am trying to create a query to run to look up values in another table. I came across Dlookup but I don't know if what I'm trying to do is possible.

I have two tables. One table has a two fields (tree names and the other diameter of the the trees) The second table has three fields the tree name, diameters, and volume. So I need to find the tree name and diameter from the first table in the second table and then take the volume that...

matt753 · Jun 30 '10, 09:42 PM

Some of my Dlookups run very fast, where some take up to 3 or 4 seconds to return a value. The table the slow one is coming from is only 10 records and 3 columns.

What are the causes for Dlookup to run slow?

matt753 · Jun 30 '10, 09:41 PM

I'm using the Dlookup function to return the value from a table. The value is "0.05", in the table the fields format is number and decimal places set to 2.

When I run the dlookup, it returns "0.050000000745 0581". Where does it get this number from and why does it add on extra decimal places?

Even if I put Round(Dlookup(" ","",""),2) it still displays all those decimal...

matt753 · Jun 25 '10, 07:09 PM

I have the following Dlookup statement:

Code:

DLookup("[RateValue]", "[Rates]", "[Rate]=" & CStr(CRegion))

I get the error: "You cancelled the previous operation".

The field is not null, it contains a 'Number' value with 2 decimal places. It is going into a double variable.

I have also tried it without the [], same result.

...

Search Result

Save to Multiple Reports to PDF and AutoName using DLookup

Compile Error: Sub or Function Not Defined

Update query with Dlookup function results in conversion error

populate a list box with the files in a folder - filepath is in memo field on form

How do you autofill a field from another table?

DLookup - removing criteria if fields are not needed

How to validate Textbox Value using Table Values?

Why does DLookup not work in Windows 7?

VBA DLookup with multiple criteria not functioning

How to have a button open a hyperlink?

dlookup not working!!

using look up table with query

Dlookup running very slowly

Dlookup returning unnecessary decimal places

"You cancelled the previous operation" Error on Dlookup