i am working with access 2000. i have a form that when you feel it out, it stores the information in the table for the form. am trying to write a auto fill query for it to automatically fill the rest of the information when the name matches the one already there......help
2 2471
Please clarify what you are looking for. Much more detail than this is required (i.e tables with PKs, fields, etc).
comteck
Please clarify what you are looking for. Much more detail than this is required (i.e tables with PKs, fields, etc).
comteck
am looking for auto fill query to fill in the rest of the form when adding client to a database in form mode. if the client already the table record, it automatically fill in the rest of the form with the record already stored in the table when you enter their name
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Sims |
last post by:
Hi,
I have a table that give a unique ID to certain Articles.
To give the ID i simply use the Auto count of the DB.
But what happens when i delete a record? i am now missing an ID.
How can i insert a row and give it the first available number?
For example ID 1, 2, 4, 5, 6
|
by: mikeybe |
last post by:
Making a very simple library circulation database for a school
project.
I have a Patron Information table(patronID, first name, last name,
phone) , an item information table (bookID, book title, authorfirst,
author last) and a circulation file (ID, bookID, patronID,
checoutdate, checkindate).
Circulation file is linked to others in a one to many fashion so that
I can have the same book checked out time after time.
|
by: Sherwood Botsford |
last post by:
Table Markers
ID (Primary Key)
This&That
PointClass (Combo box)
Points
Table PointClasses
PointClass (primary key)
Points (number)
Description (Text)
|
by: qwas2123 |
last post by:
Hi, Im trying to build a form that within the form it has a feature that if you input data into a certain text box, from there, it will automatically fill the rest of the text boxes on the form based on the information of specific tables.
Example : ID___________
Name "auto" ____________
Loc "auto" ____________
Rank "auto" ____________
etc . . .
I...
|
by: Elainie |
last post by:
I have been trying to auto fill fields with DLookup - but it doesn't
seem to work..... can you help...
I have a name field and I want the address to automatically fill in
when the name field is filled in. I have load of othre fields that
would benefit from this so I need to get it working....
=DLookUp("",""," =")
I have an unbound gp_practice field and want to fill in the gpcode
| |
by: KelHemp |
last post by:
Greetings,
I've been using this site for lots of access help in the past, and it's very helpful! I have a new complexity for you all.
Reworking a form to record 70-80 years of oil production on multiple leases, which have multiple wells within them. Most wells can fit on one printed page (one record), but in the case of overspill, we want to do the following:
-Move to a new record and auto fill the LeaseName, LeaseNumber, Operator,...
|
by: Jim |
last post by:
I have a new database in which I have a form where in one field I type
a letter A, B, C or D and the field next to it autofills (auto lookups)
with a description associated with the specific letter. If I edit the
description for one record, it edits the same for all records in which
I've applied the same autofill (auto lookup). I'm set up where the
letters come from a lookup combo box (limit to list "Yes") and the
record source for the...
|
by: Boki |
last post by:
Hi All,
I am creating a program that performs "auto fill in" and "auto submit"
functions.
I will feed the webbrowser the target URL, however, I don't know how
to auto fill in text and submit.
About the submit, I ever tried to use Navigating to catch the new
|
by: Steve67 |
last post by:
I didn't see a search feature in these forums, so I couldn't look up this question and I am sure it is a common questions.
I am trying to auto fill some information on an form. Here is what I have going on. I created a form that will fill in information on one table, but I also want information from another table on this form, but I want this infomation to automatically fill in was soon as I type lets say a part number. I tried to do this by...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |