473,327 Members | 2,065 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

DlookUp

Can I have this function look up more than one other field? For instance, I
have a lookup now that does this:
Me!Casting = DLookup("[Casting]", "Part# Table", "[PartID] = '" &
Me!PartID & "'")
What this does is, when I enter the PartID the Casting field is accessed and
inputted into the form. Is it possible to do the same thing but then also
have a file accessed and inputted into the form.
Just in case I'm not clear on what I'm trying to do let me explain it
another way.
Right now I input a number (PartID) that inserts a casting description
(Casting) into my form. I'd also like the PartID to bring up a hyperlink
file as well as the Casting description.
Is it possible? If so how would I make it happen.
Thanks,
Don..................
Nov 13 '05 #1
5 2087
I've actually figured out the answer to the question. I can just add
another line to the code and it will make the second field populate.
My next question is this, how can I make a hyperlink pop up.
In other words when I enter the PartId and the Casting description pops up
how can I make a hyperlink to a file pop up? I don't want to open the file
but I do want to have the option by clicking on the file location that pops
up. I can make it work in the table but I can't get it to pop up in my
form.
Hope I'm explaining myself on this.
Thanks again for all your help,
Don........

"Don Sealer" <vz******@verizon.net> wrote in message
news:rwmxd.3922$113.2598@trndny03...
Can I have this function look up more than one other field? For instance, I have a lookup now that does this:
Me!Casting = DLookup("[Casting]", "Part# Table", "[PartID] = '" &
Me!PartID & "'")
What this does is, when I enter the PartID the Casting field is accessed and inputted into the form. Is it possible to do the same thing but then also
have a file accessed and inputted into the form.
Just in case I'm not clear on what I'm trying to do let me explain it
another way.
Right now I input a number (PartID) that inserts a casting description
(Casting) into my form. I'd also like the PartID to bring up a hyperlink
file as well as the Casting description.
Is it possible? If so how would I make it happen.
Thanks,
Don..................

Nov 13 '05 #2
"Don Sealer" <vz******@verizon.net> wrote in
news:paoxd.742$PY6.80@trndny02:
I've actually figured out the answer to the question. I can
just add another line to the code and it will make the second
field populate. My next question is this, how can I make a
hyperlink pop up. In other words when I enter the PartId and
the Casting description pops up how can I make a hyperlink to
a file pop up? I don't want to open the file but I do want to
have the option by clicking on the file location that pops up.
I can make it work in the table but I can't get it to pop up
in my form.
Hope I'm explaining myself on this.
Thanks again for all your help,
Don........

Add another textbox. Set its IsHyperlink property to yes. Populate
the textbox with the full path and name of the file as above.
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #3
Thanks Bob, I did finally figure it out.
I've got another question and I'd be interested in seeing what you have to
say about it.
Thanks again,
Don..........

"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1103505189.897ae7fd721faed774cd99eb547f5eca@t eranews...
"Don Sealer" <vz******@verizon.net> wrote in
news:paoxd.742$PY6.80@trndny02:
I've actually figured out the answer to the question. I can
just add another line to the code and it will make the second
field populate. My next question is this, how can I make a
hyperlink pop up. In other words when I enter the PartId and
the Casting description pops up how can I make a hyperlink to
a file pop up? I don't want to open the file but I do want to
have the option by clicking on the file location that pops up.
I can make it work in the table but I can't get it to pop up
in my form.
Hope I'm explaining myself on this.
Thanks again for all your help,
Don........

Add another textbox. Set its IsHyperlink property to yes. Populate
the textbox with the full path and name of the file as above.
--
Bob Quintal

PA is y I've altered my email address.

Nov 13 '05 #4
On Sun, 19 Dec 2004 23:53:06 GMT, Chuck Grimsby
<c.*******@worldnet.att.net.invalid> wrote:

DLookup will return only one field. If you want/need more, use query.

Well ...
resp = Dlookup( "SideEffects([<field1>], [<field2>] ...)", ...)

where, somewhere in scope you have

dim Variable1, Variable2 ...

Function SideEffects(a, b, ...)
Variable1 = a
Variable2 = b
...
SideEffects = <something>
end function

This was an old thread
David

Nov 13 '05 #5
Hi
Yes, not being serious except as a warning about how dangerous code
can be
David

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: KLAU | last post by:
I have a field that retrieves information from an expression in a query. I have used a DLookup function to get the calculated field from the query. However, the relationship is 1-to-many so one...
6
by: JLM | last post by:
What am I missing here? I have a form where I enter a "Class Code". This value corresponds to what sits in table "class code descriptions" along with the "title" of each "class code." Key...
5
by: Kalvin Schroder | last post by:
I am fairly new to Access, and am trying to put together an invoice form. The main form in called InvoiceDetailFm. Source is the table InvoiceDetail and has invoice number, saleman, and CustID as...
4
by: MLH | last post by:
I have tried using DLookUp in this manner... If DLookUp("","tblClients","='2021234567'") Then MsgBox "Found it!" End If I am wondering if that is a misuse of the DLookUp command? Type...
2
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...
8
by: Christine Henderson | last post by:
I have a problem using the above function in the following simplified circumstance: In the lookup table called "Klms Travelled" I have 3 fields, eg: Receiver Name Receiver Suburb ...
11
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...
2
by: Don | last post by:
Can someone help me fix my DLookup problem. I'm far from proficiency with Access. I've been creating databases for several years for work with the help of many of you and trial and error. I have...
9
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...
15
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.