I've searched through some of the answers on the forum regarding autofill but I can't work out how to do it for my database.
I have two tables
1. Members info, containing the following fields:
a. Member ID (primary)
b. Division that the member belongs in
c. Address
d. Names
2. Division Night info containing the following fields:
a. Which Division is holding training night (
b. Members who attended (Member ID) as a combo box
c. Visitor or Member of the specific Division
One-To-Many relationship is set up between 1a and 2b
My question is how do i set up the database on the form so that when i select 2a and 2b, then 2c automatically comes up?
2c is worked out by looking at the member ID in 1a and if the division that the member belongs to (1b) is the same as the division holding the training night (2a), then 2c's answer is a 'Member'?
Thanks
3  1394 
I know it has something to do with Dlookup but i dont know how to use the function.
I have two tables with the following field names
1. Members info, containing the following fields (tbl01MembersDe tail):
a. Member ID (primary) - lngMemberNum
b. Division that the member belongs in - strDivisionName
c. Address
d. Names
2. Division Night info containing the following fields:
a. Which Division is holding training night
b. Members who attended (Member ID) as a combo box - LngMemberID
c. Visitor or Member of the specific Division
In 2b's combo box after-update feature, i've added this code:
test = DLookup ([strDivisionName], "tbl01MembersDe tail",[lngMemberNum] = LngMemberID)
I just used "test" to see if the result gives me the division that the member belongs to, which i can then compare and determine whether the member is a visitor to the division holding the training night.
Sorry if it's all very confusing, it is like that for me.
I have two tables with the following field names
1. Members info, containing the following fields (tbl01MembersDe tail):
a. Member ID (primary) - lngMemberNum
b. Division that the member belongs in - strDivisionName
c. Address
d. Names
2. Division Night info containing the following fields:
a. Which Division is holding training night
b. Members who attended (Member ID) as a combo box - LngMemberID
c. Visitor or Member of the specific Division
In 2b's combo box after-update feature, i've added this code:
test = DLookup ([strDivisionName], "tbl01MembersDe tail",[lngMemberNum] = LngMemberID)
I just used "test" to see if the result gives me the division that the member belongs to, which i can then compare and determine whether the member is a visitor to the division holding the training night.
Sorry if it's all very confusing, it is like that for me.
FOUND THE ANSWER, I HAD THE QUOTATION MARKS IN THE WRONG PLACE!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Chris Sharman |
last post by:
I'd like to design my pages to work cooperatively with browser autofill
features.
I've loked around, but can't find any good documentation on
supported/unsupported field names
(http://toolbar.google.com/autofill_help.html gives some details, but
doesn't make it clear to me how to name my form fields; rfc3106 only
seems to cover ecommerce specific data).
I'd like a delivery name & address (primary);
a contact name & address (if...
|
by: shortbackandsides.no |
last post by:
I'm having a lot of difficulty trying to persuade the Google toolbar
autofill to act consistently, for example
=======================
<html><head>
<title>autofill test</title>
</head><body>
<form method="POST" action="">
1 email <input type="text" name="email"><br>
2 name <input type="text" name="name"> <br>
|
by: David Portabella |
last post by:
Hello,
I am a doing a survey about Autofill Web Forms softwares.
Usually, they all collect information of the user once during the
set-up phase (user knowledge base).
Then, when the user navigates to a web form, the autofill software can
automatically partially fill the form. The solution can be mostly
differenciated by its intelligence algorithm for matching between the
|
by: Anks |
last post by:
Hi All,
A user can control the AutoFill option by enabling / disabling the
Remember Passwords option in Options - Privacy - Saved Passwords
section.
But is it possible to disable this option programatically using
JavaScript or in any other way ? I basically dont want the user's
browser to ever remmeber the username and password and hence autofill
these two fields !! So can we do anything as the page author to disable
|
by: Nick J |
last post by:
Hi,
I remember at one point access would autofill a text box when filtering by
form, Like for example as I would type it would come up with matching
records, similar to AutoComplete in Internet Explorer, I now have nearly
4,000 records, is this the reason why it does not perform this function
anymore?
Thanks...
| | |
by: Andre Ranieri |
last post by:
I'm retouching our corporate web site that, among other things, allows
customers to log in and pay their invoices online. I noticed that on the
checkout page, the credit card number textbox autofills with past entries for
that textbox. My development workstation has the Google Toolbar installed;
I'm not sure whether the autofill functionality is native to the browser or
coming from the Google Toolbar.
In either case, is there any way...
|
by: HTS |
last post by:
I have written a membership database application (PHP + mySQL) and need to prevent autofill from filling in fields in a member record edit form.
I know I can turn off autoFill in my browsers, I want a away to prevent it within the form itself. Is there any standard way to "tell" a browser not to autofill the fields on a particular form?
|
by: bloukopkoggelmander |
last post by:
All
I am new to this site and hopefully would have a good time here.
I am new to Microsoft Access and VBA and am currently involved in a project to create a new database for one of our company departments. The problem I am having is as follows( ...I have spent about 2 weeks on this now and is about 5 seconds away from going insane....) :
I have created a new form with a combo box that looks up Last Name and First Name from a employee...
|
by: Rissoman |
last post by:
Hello,
I have an issue were I have a zipcode textbox in an atlas ajax
updatepanel. When you tab out of the zip textbox and the shipping is
calculated. I know this works perfect! Then a user informed me it
didn't and he is using google autofill, bad! Thus, I came to the
conclusion that autofill doesn't fire the text_change event when the
zipcode is filled into the text box. Is there a way to force autofill
to fire this text_change...
|
by: Randy |
last post by:
Hi,
I have some comboboxes that are created dynamically at run time based
on user actions. I found a procedure on a message board to autofill
the combobox text from the dataview that the comboboxes are bound to.
It works perfectly on the comboboxes that I have created at design
time, but the ones that I create runtime behave differently.
The problem is that when the user tabs onto the combobox, the box
stays blank, which is fine. ...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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: 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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |
