I'm beginning to understand a little about lookups, but just a little.
Here's another question I'm wondering about.
I want to input a part# and then input a department code (G,D,B) and
depending on the department code have Access find the corresponding file to
lookup. In other words I could have a scenario like this
Part# Department# lookup File
123456 G C:\File1
123456 D C:\File2
123456 B C:\File3
So basically I have 3 differeent "lookup" files for each part# but which
file that pops up is determined by the Department code.
How would I make this happen?
Thanks for your help,
Don............ .. 5 1504
You need a table with the 3 fields you suggested: PartNo, DeptNo, and
LookupFile. For the LookupFile, you could us a Hyperlink type field. If
that's new, see:
Introduction to Hyperlink fields
at: http://members.iinet.net.au/~allenbrowne/casu-09.html
In your data entry form, it's easy to choose the file that goes into the
hyperlink field, but right-clicking, using the Insert menu, or you could put
a command button beside the text box, with these 2 lines in its Click event
procedure:
Me.[LookupFile].SetFocus
RunCommand acCmdInsertHype rlink
If you want to programmaticall y fire up the hyperlink file, use
FollowHyperlink .
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Don Sealer" <vz******@veriz on.net> wrote in message
news:233yd.6243 $152.2248@trndn y01... I'm beginning to understand a little about lookups, but just a little. Here's another question I'm wondering about. I want to input a part# and then input a department code (G,D,B) and depending on the department code have Access find the corresponding file to lookup. In other words I could have a scenario like this Part# Department# lookup File 123456 G C:\File1 123456 D C:\File2 123456 B C:\File3 So basically I have 3 differeent "lookup" files for each part# but which file that pops up is determined by the Department code. How would I make this happen? Thanks for your help, Don............ ..
On Wed, 22 Dec 2004 00:18:06 GMT, "Don Sealer" <vz******@veriz on.net>
wrote: I'm beginning to understand a little about lookups, but just a little. Here's another question I'm wondering about. I want to input a part# and then input a department code (G,D,B) and depending on the department code have Access find the corresponding file to lookup. In other words I could have a scenario like this Part# Department# lookup File 123456 G C:\File1 123456 D C:\File2 123456 B C:\File3 So basically I have 3 differeent "lookup" files for each part# but which file that pops up is determined by the Department code. How would I make this happen? Thanks for your help, Don........... ...
l
Hi
part = 1234 'say
dept = "A" 'say
criterion = "[Part#]=" & part & " AND [Department#]='" & dept & "'"
lookupfile = Dlookup("[lookup File]", "yourtablename" , criterion)
Hope no typos! Note in the "where clause" text items are put in single
quotes and numbers not.
David
I've been struggling with this. I'm new at most of this and so I'm not
sure it's not working because I don't understand how to do what you tell me
or because I didn't explain what I want to do very well. In either case
please forgive me for not getting it. Hopefully I will eventually. Let me
try to explain what I'm trying to do a little better.
In my form I'd like to have people enter a part number, choose which
department/operation is appropriate and then have a hyperlink file pop up.
This file would have drawing information and work procedures in it. The
problem I'm stuck on is, each part number is unique, each part number is
associated with three departments/operations, and each department/operation
has it's own unique drawing for that part number. So how could I make a
form work in which I would input the part#, choose the dept/oper and have
the drawing for that part# and dept/oper pop up?
One side note: I already use the DLookup function to populate a field
called Part Desc. It works like this, when I input a Part# it looks up the
description for that Part# and populates the field called Part Desc.
Hope that doesn't confuse things,
Thanks for all your help,
Don............ ...
This is an short example of what the options would be
Part # Dept/Oper Drawing
135 B Dwg A
135 G Dwg B
135 D Dwg C
246 B Dwg D
246 G Dwg E
246 D Dwg F
103050 B Dwg G
103050 G Dwg H
103050 D Dwg I
204060 B Dwg J
204060 G Dwg K
204060 D Dwg L
etc etc etc
"David Schofield" <d.************ ***@blueyonder. co.uk> wrote in message
news:41ca970c.6 15595980@localh ost... On Wed, 22 Dec 2004 00:18:06 GMT, "Don Sealer" <vz******@veriz on.net> wrote:
I'm beginning to understand a little about lookups, but just a little. Here's another question I'm wondering about. I want to input a part# and then input a department code (G,D,B) and depending on the department code have Access find the corresponding file
tolookup. In other words I could have a scenario like this Part# Department# lookup File 123456 G C:\File1 123456 D C:\File2 123456 B C:\File3 So basically I have 3 differeent "lookup" files for each part# but which file that pops up is determined by the Department code. How would I make this happen? Thanks for your help, Don........... ...
l Hi part = 1234 'say dept = "A" 'say
criterion = "[Part#]=" & part & " AND [Department#]='" & dept & "'"
lookupfile = Dlookup("[lookup File]", "yourtablename" , criterion)
Hope no typos! Note in the "where clause" text items are put in single quotes and numbers not.
David
I'm really pretty naive about these things. I posted this message to a newwgroup and when I went searching online I find it posted here. So with that in mind here's my next question on this. Although it will probably post here from the newsgroup anyway.
I've been struggling with this. I'm new at most of this and so I'm not
sure it's not working because I don't understand how to do what you tell me
or because I didn't explain what I want to do very well. In either case
please forgive me for not getting it. Hopefully I will eventually. Let me
try to explain what I'm trying to do a little better.
In my form I'd like to have people enter a part number, choose which
department/operation is appropriate and then have a hyperlink file pop up.
This file would have drawing information and work procedures in it. The
problem I'm stuck on is, each part number is unique, each part number is
associated with three departments/operations, and each department/operation
has it's own unique drawing for that part number. So how could I make a
form work in which I would input the part#, choose the dept/oper and have
the drawing for that part# and dept/oper pop up?
One side note: I already use the DLookup function to populate a field
called Part Desc. It works like this, when I input a Part# it looks up the
description for that Part# and populates the field called Part Desc.
Hope that doesn't confuse things,
Thanks for all your help,
Don............ ...
This is an short example of what the options would be
Part # Dept/Oper Drawing
135 B Dwg A
135 G Dwg B
135 D Dwg C
246 B Dwg D
246 G Dwg E
246 D Dwg F
103050 B Dwg G
103050 G Dwg H
103050 D Dwg I
204060 B Dwg J
204060 G Dwg K
204060 D Dwg L
etc etc etc
--
Message posted via http://www.accessmonster.com
On Fri, 24 Dec 2004 13:11:56 GMT, "Don Sealer" <vz******@veriz on.net>
wrote: I've been struggling with this. I'm new at most of this and so I'm not sure it's not working because I don't understand how to do what you tell me or because I didn't explain what I want to do very well. In either case please forgive me for not getting it. Hopefully I will eventually. Let me try to explain what I'm trying to do a little better. In my form I'd like to have people enter a part number, choose which department/operation is appropriate and then have a hyperlink file pop up. This file would have drawing information and work procedures in it. The problem I'm stuck on is, each part number is unique, each part number is associated with three departments/operations, and each department/operation has it's own unique drawing for that part number. So how could I make a form work in which I would input the part#, choose the dept/oper and have the drawing for that part# and dept/oper pop up? One side note: I already use the DLookup function to populate a field called Part Desc. It works like this, when I input a Part# it looks up the description for that Part# and populates the field called Part Desc. Hope that doesn't confuse things, Thanks for all your help, Don........... .... This is an short example of what the options would be Part # Dept/Oper Drawing 135 B Dwg A 135 G Dwg B 135 D Dwg C 246 B Dwg D 246 G Dwg E 246 D Dwg F 103050 B Dwg G 103050 G Dwg H 103050 D Dwg I 204060 B Dwg J 204060 G Dwg K 204060 D Dwg L etc etc etc
"David Schofield" <d.************ ***@blueyonder. co.uk> wrote in message news:41ca970c. 615595980@local host... On Wed, 22 Dec 2004 00:18:06 GMT, "Don Sealer" <vz******@veriz on.net> wrote:
>I'm beginning to understand a little about lookups, but just a little. >Here's another question I'm wondering about. >I want to input a part# and then input a department code (G,D,B) and >depending on the department code have Access find the corresponding fileto >lookup. In other words I could have a scenario like this >Part# Department# lookup File >123456 G C:\File1 >123456 D C:\File2 >123456 B C:\File3 >So basically I have 3 differeent "lookup" files for each part# but which >file that pops up is determined by the Department code. >How would I make this happen? >Thanks for your help, >Don........... ... > >l Hi part = 1234 'say dept = "A" 'say
criterion = "[Part#]=" & part & " AND [Department#]='" & dept & "'"
lookupfile = Dlookup("[lookup File]", "yourtablename" , criterion)
Hope no typos! Note in the "where clause" text items are put in single quotes and numbers not.
David
Hi
I think you should just have a table with columns
Part Dept Drawing Filename
135 B Dwg A aaaa
135 G Dwg B bbbb
135 D Dwg C cccc
246 B Dwg D dddd
Part and Dept form the key
then you have a form with combo boxes to select Part and Dept, and
show the corresponding other columns (and open the file).
That way you don't need dlookup at all.
It is a good general rule that you don't need Dlookup if the criteria
come from a query, as you could have added the field to be looked up
to the query via an extra join if necessary.
David This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David Logan |
last post by:
Hello,
I am trying to construct a query across 5 tables but primarily 3
tables. Plan, Provider, ProviderLocation are the three primary tables
the other tables are lookup tables for values the other tables.
PlanID is the primary in Plan and
Plan Provider ProviderLocation Lookups
-------- ---------- ---------------- -----------
PlanID ProviderID ProviderID LookupType
|
by: Bradley |
last post by:
Has anyone else noticed this problem? I converted the back-end to A2000
and the performance problem was fixed. We supply a 97 and 2000 version
of our software so we kept the backend in A97 to make upgrading simple
for users. We've done it like that for years but a new client has been
having severe performance issues... solved by converting the backend to
2000.
--
regards,
Bradley
|
by: Russell |
last post by:
Hi,
I've been reading a lot about not using lookups in tables lately.
Thus far, what I've been able to understand from my reading is this:
- Do not use lookup fields in tables because they hide what's really
stored (e.g. 'Joe Bloggs' is displayed, '4' is stored as the ID)
- Instead, use combo boxes on forms, taking their values from tables or
queries.
|
by: Don Sealer |
last post by:
I have a form that is based on a table called CVA Defects Table. Three
of the fields in the table and form are Oil line defects, Gas line
defects, and Sub assembly defects. These fields use lookups into
another table called "defects table". If I input from the CVA Defects
Table everything works fine all the time. However when I input data
from the form I have problems.
The Oil & Gas line lookups work very well all the time in the form....
|
by: AnAnimal |
last post by:
We are moving a rather large application to the VB.NET platform.
This application has a ton of table lookups.
ie. code & description or code, category & description or code, class,
category & description
Most of the users know the more common codes and will just enter them
but occasionally will need to look these codes up (especially when a
temp is using the system!!).
How would the VB.NET veterans handle this?
| |
by: bcr07548 |
last post by:
I am writing a web site that uses JavaScript to validate certain forms
and I seem to be having some trouble. The site uses PHP and for one of
the forms, depending on the situation, one of of the text inputs does
not exist - the PHP doesn't generate the HTML for it. I wanted to have
the validation script check the length of the input if it exists but I
knew that I might have trouble if I tried to check the value of the
input without first...
|
by: mac |
last post by:
Summary:
1. I want to define a column in anMS Access table to be lookups on other
tables.
2. The table that is the data source (e.g the "parent" table) has a
composite
primary key.
3. When the "child" table does the lookup, it should pass all the columns
necessary
to properly restrict the data returned to the litbso for he lookup.
4. How do I accomplish this in a lookup?
|
by: bukzor |
last post by:
I've found some bizzare behavior when using mutable values (lists,
dicts, etc) as the default argument of a function. I want to get the
community's feedback on this. It's easiest to explain with code.
This example is trivial and has design issues, but it demonstrates a
problem I've seen in production systems:
def main(argv = ):
'print out arguments with BEGIN and END'
argv.insert(1, "BEGIN")
|
by: Ken Fine |
last post by:
This is a question that someone familiar with ASP.NET and ADO.NET DataSets
and DataTables should be able to answer fairly easily. The basic question is
how I can efficiently match data from one dataset to data in a second
dataset, using a common key. I will first describe the problem in words and
then I will show my code, which has most of the solution done already.
I have built an ASP.NET that queries an Index Server and returns a...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |