I have two tables one with a bill of materials and one with the
inventory quantities. The bill of materials table contains part
numbers that would be found in the inventory table, and I am trying to
capture the company's part number (in this case the OOL Number)
PKGDBOM -First Table-
-[Product Number]
-[Container]
-[Container Qty]
INVG -Second Table-
- [Product Number]
- [Product Type]
- [QOH]
- [OOL Number]
I am writing a query to capture the OOL number in the Container field,
and using dlookup in the expression to find the data. I receive a
syntax error message every time I try to run it:
Container: DLookUp("[INVG]![OOL Number]","[INVG]","[PKGDBOM]!
[Container] = " & [INVG]![Product Number])
Any ideas why this would not work?
Thanks in advance!
3  1677 
try DLookUp("[OOL Number]","INVG","[Product Number] =" &
forms!FormName!ContolName). I assume you are trying to do this on a form
"OlyOil" <EN*******@gmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
>I have two tables one with a bill of materials and one with the
inventory quantities. The bill of materials table contains part
numbers that would be found in the inventory table, and I am trying to
capture the company's part number (in this case the OOL Number)
PKGDBOM -First Table-
-[Product Number]
-[Container]
-[Container Qty]
INVG -Second Table-
- [Product Number]
- [Product Type]
- [QOH]
- [OOL Number]
I am writing a query to capture the OOL number in the Container field,
and using dlookup in the expression to find the data. I receive a
syntax error message every time I try to run it:
Container: DLookUp("[INVG]![OOL Number]","[INVG]","[PKGDBOM]!
[Container] = " & [INVG]![Product Number])
Any ideas why this would not work?
Thanks in advance!
On Apr 12, 7:00 pm, "Scott" <scott.n.j...@ns.sympatico.cawrote:
try DLookUp("[OOL Number]","INVG","[Product Number] =" &
forms!FormName!ContolName). I assume you are trying to do this on a form
"OlyOil" <ENelso...@gmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
I have two tables one with a bill of materials and one with the
inventory quantities. The bill of materials table contains part
numbers that would be found in the inventory table, and I am trying to
capture the company's part number (in this case the OOL Number)
PKGDBOM -First Table-
-[Product Number]
-[Container]
-[Container Qty]
INVG -Second Table-
- [Product Number]
- [Product Type]
- [QOH]
- [OOL Number]
I am writing a query to capture the OOL number in the Container field,
and using dlookup in the expression to find the data. I receive a
syntax error message every time I try to run it:
Container: DLookUp("[INVG]![OOL Number]","[INVG]","[PKGDBOM]!
[Container] = " & [INVG]![Product Number])
Any ideas why this would not work?
Thanks in advance!- Hide quoted text -
- Show quoted text -
I am not working in a form, I am simply trying to extract the data
from a query. Should I change to a form?
If you are in a query then just join the two tables in the query using the
product number and it should work fine.
"OlyOil" <EN*******@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...
On Apr 12, 7:00 pm, "Scott" <scott.n.j...@ns.sympatico.cawrote:
>try DLookUp("[OOL Number]","INVG","[Product Number] =" &
forms!FormName!ContolName). I assume you are trying to do this on a form
"OlyOil" <ENelso...@gmail.comwrote in message
news:11**********************@b75g2000hsg.googleg roups.com...
>I have two tables one with a bill of materials and one with the
inventory quantities. The bill of materials table contains part
numbers that would be found in the inventory table, and I am trying to
capture the company's part number (in this case the OOL Number)
PKGDBOM -First Table-
-[Product Number]
-[Container]
-[Container Qty]
INVG -Second Table-
- [Product Number]
- [Product Type]
- [QOH]
- [OOL Number]
I am writing a query to capture the OOL number in the Container field,
and using dlookup in the expression to find the data. I receive a
syntax error message every time I try to run it:
Container: DLookUp("[INVG]![OOL Number]","[INVG]","[PKGDBOM]!
[Container] = " & [INVG]![Product Number])
Any ideas why this would not work?
Thanks in advance!- Hide quoted text -
- Show quoted text -
I am not working in a form, I am simply trying to extract the data
from a query. Should I change to a form?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: sherah |
last post by:
I am trying to create a procedure that has values are entered into a
table that based on the value entered will programatically decide
weather or not the Yes/No should be checked. I am trying to...
|
by: John Hargrove |
last post by:
I am building a database to manage test samples in an environmental
laboratory. I am learning Access as I go and don't know much about
the programming aspects. I hope to make the application...
|
by: Ronny Sigo |
last post by:
Hello all,
I already put the same question, only now I have more to tell ...
Although I used this code before in the same routine (only the fieldname of
the table differs) ___ at this point in the...
|
by: ctyrrell |
last post by:
I have read with interest the many discussions of the 3048 Error:
Cannot open any more databases. I understand how the number of open
Table ID's causes the problem. My question has to do with the...
|
by: MLH |
last post by:
DLookup("", "tblPreliminaryVINs",
"=Forms!frmVINODO!SerialNum")
is giving me a Type Mismatch error. That's confusing to me
and I don't know how to circumvent it. The field in...
|
by: Karen Bielska |
last post by:
I have a table "Customer" with two fields "CusID" (autonumber, PK) and
"CusName" (text).
If I know the customer's ID, say 215, how can I find the name using DLookup?
PS:
I'm not really looking...
|
by: Ron |
last post by:
Hi All,
Was just wondering which is faster, a subreport or dlookup.
I've got a report with either 5 subreports or lots of dlookups. The
subreports generally have anywhere from 5 to 12...
|
by: |
last post by:
In my database I have a 'control table' in which basic info is stored about the application, for instance the application's path and the name of the company that is using it. In all of the...
|
by: Breezwell |
last post by:
This is probably a simple question for someone out there.
I understand that the DLookup function takes has the following syntax:
DLookup(expression,domain,)
From what I have read, domain can...
|
by: rleepac |
last post by:
This is a little complicated but I'll do my best to explain. In my db I have a table called L_AgeCorrection which has the following fields: Age, Sex, Frequency, AgeValue
This is a table used to...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
