Autolookup With Autofilling

Jan 5, 2006

Hi there!
It's been almost 10 years since I've done any work with databases, so I'm really REALLY rusty and I barely remember how to do anything. I was wondering if you guys could help me out with a question I have in making a form.
I have 2 tables. The first table has a list of names and ID's. There exist some duplicate names, as some people are associated with more than one ID.
And there are two fields to the ID. One is Called the Client Code, and the other is the Client Division.
So the 1st table, in datasheet view, is basically:

# | Last Name | First Name | Client Code | Client Division

The second table is a list of addresses based on Client Code and Client Division:

# | Client Code | Client Division | Address 1 | Address 2 | Etc

----
What I'm trying to do is the following:
I'm trying to create a form such that as I'm typing in a last name, it does autolookup and auto filling. I may have multiple people with the Last name of Smith, so then it dynamically creates a dropdown box with all possible unique first names associated with the last name Smith. And after I choose/type in the first name, I get to two more dynamically created drop-down boxes that list all possible Client Codes and Client Divisions associated with this name. After choosing that, I figure it's a simple autolookup to populate the address fields.
Does anyone have any insight on how I can get this done? Another piece of functionality that I'm trying to work into this is that if the name doesn't exist or if there's a new Client Code and Client Division or a new address, the data gets automatically added to the respective tables.

Does anything of what I wrote make any sense?
Any help would be greatly appreciated.

thanks

Imants

View Replies


ADVERTISEMENT

Autofilling Value Which Is NOT Autonumber

Jul 21, 2005

I have a table that keeps putting a zero value in the new recordl. It was previously an autonumber field. I changed that and deleted the zero from the default value property.

How do i get rid of this???

View 2 Replies View Related

Help With Autofilling Fields From One Form To The Next

Jan 31, 2005

I am sure this has been asked a thousand times, but I couldn't seem to find a thread.

I have a form, which contains a subform. When in the subform, I have a button to create a new main form and I want it to prefill in the data from some fields on the subform.

It looks like it should work, but #1, when I am in the main form inside the subform, the botton does nothing. If I open only the subform, then it at least works.

And #2, it definitely captures the values that I want, but it doesn't fill them in on the form.

Here is my code:
Private Sub Command44_Click()
On Error GoTo Err_Command44_Click
Dim doc As String
Static tit As String
Static desc As String
doc = "Business Requirement Document"
title = IssueType
desc = Issue

DoCmd.OpenForm doc, acNormal, , , acFormAdd

BRD_Title = title
BRD_Description = desc

Exit_Command44_Click:
Exit Sub

Err_Command44_Click:
MsgBox Err.Description
Resume Exit_Command44_Click

End Sub

Any help would be MUCH appreciated!!

View 6 Replies View Related

Autolookup

Apr 28, 2005

I apologize for asking yet another question about autolookup but I have poured of Pat Hartman's example and all the posts in this forum and still can't seem to make it work. I have attached my db. I want to type in the asset number and autofill the rest of the form. Can someone please look at this and tell me what I am doing wrong. Thank you very much.

View 2 Replies View Related

Autolookup

Nov 5, 2004

I am building a purchase order database that derives its subcontractor information from a separate table.

I want to be able to drop down a list for the subcontractors and once selected, the entire subcon area will be populated.

Another section of this PO is the project name, etc., which is a similar scenario, which has to be populated in the same manner.

Word file shows the structure of the PO.

Any help would be greatly appreciated!

jan.bodlund@shaw.ca

View 5 Replies View Related

Form Box Autofilling With Date And Number?

Sep 20, 2006

Hi all, and apologies for starting a fresh thread about this, but I can't find exactly what I'm trying to achieve via the search function, although I'm hoping it's just something simple I'm missing.

I have a small database that allows the user to click on a button to go an Add New Records form, which they then fill out. At the moment, the record number gets autofilled and they start entering details. However, one of the details they must enter is a unique record number, consisting of the month, the year, and a number between 01 and 99 (so the first new record created today, for example, would be record 090601, the second 090602, etc. The first next month would be 100601, and so on).
At the moment, I have to rely on people to manually enter this number, which requires them to view the current records first to ascertain whether there have been any previous records created that day (to prevent duplications).

What I'd really like is to have the this records box autofill when entering the form with the current month, current year, and then the number of the record for that day. However, it should automatically look at the last record created, and, if there's a match on the month and year, add one to the last 2 digits to ensure a new, unique record. So, for example, I have three records this month, listed as numbers 090601, 090602, and 090603 respectively. I go to create a new record, the box should autofill with the number 090604 and create a new record accordingly.

How do I acheive this?

View 14 Replies View Related

AutoLookup Or Maybe Other Feature HELP>???

Feb 23, 2006

I'm trying to establish a ticket/citation database for a college security office at which i work at. I have two tables, table 1 includes the ticket information (date of ticket, citation number, *tag #, amount etc.), table 2 includes Repeted offenders information such as (name, address, city, zip, phone number, student ID# etc.).
I would like to have a table or query(preferably table) which automatically matches tag#'s to student information as soon as a new ticket is entered, *if the student information is available.
Thanks a lot in advance

View 3 Replies View Related

Autolookup On Tables

Mar 20, 2005

I was just wondering if anyone knows how to sort of mask an ID as text. For example in this assignment I am doing at university I have a field named Flower ID which is a number. However, instead of displayign that number in forms and tables I want it to display its equivalent Species and Variety of flower. Is there anyway to fix this? Thanks for your help.

View 2 Replies View Related

Autolookup Problem

Apr 24, 2006

I'm getting very frustrated with trying to get this working. I've tried following other suggestions in this forum but must be mucking up on one vital peice.
From a choice in a combo box I want other values filled in on a form.
Can someone link me to a small, easy to follow example? I think I've got the query part sussed but fall down on the form side.Cheers:(

View 5 Replies View Related

Autofilling Info From Table To Form Field

Jan 25, 2012

I'm VERY new to MS Access 2010 - in fact, I used some online youtube videos to get me started with the database I'm currently working on.

Here's what I have so far: 2 tables, one for customer information (name, phone, addy, etc) and one for invoices (inv #, customer ID (which should be the same as my primary key from the customer info table), phone, services rendered, etc etc)

I'm currently working on a form for Invoices, where I can simply put in the customer's name, date, cost, etc without having to look up the ID# and phone number for every time I use it.

View 1 Replies View Related

Multiple Table AutoLookup

Jan 3, 2005

I am trying to pull information from 2 seperate tables and store that information in a 3rd table. I need to autofill information from both tables when I select the information from the field that joins them. Then that information needs to be saved in the 3rd table. I have to store this "duplicate" copy of the informaion becuase one table's inforamtion changes quite frequently and I needs to be able to find historical data. Here is a simplified version of my tables for example.

Products: ProductID (KEY), ProductDescription
Quote: ShipID (KEY), ProdcutID(KEY), Price (changes per ShipTo)
ProdutsOrdered: OrderID (KEY), ShipID, ProductID (KEY), ProductDescription, Price

Again, all information has to be stored in ProductsOrdered because things like Quote.Price can change frequently.

Another important feature is I have to beable to add records with what ever method I use. This Is being done in a sub form so that many products can be placed on an order form. I can get the tables to combine in a way that will allow me to view the information, but not add to it.

View 3 Replies View Related

Autofilling Textboxes With Table Data Based On A Combobox.

Nov 17, 2006

I am creating an Access program for logging in Parcels that are delivered and I am having some problems.

I have a Table called 'Contacts' and within this there are 4 Columns: 'Names', 'Departments', 'Extensions' and 'Emails'.

I also have a Form and there is 1 Combobox and 3 Textboxes relating to this Table: 'Addressed To', 'Department', 'Ext Number' & 'Email'. (see http://c0ld.homeip.net/parcel_log.jpg for details).

What I would like to do is select the Name from the Combobox (Addressed To) and the have the other Textboxes (Department, Ext Number & Email) get auto-filled with the corresponding data that’s within the Table for that Name.

If anyone would like the .mdb for this, please PM me.

Thanks for your help in advance.
Ross Hurrell

View 7 Replies View Related

Autolookup Not Working When Maths Involved

Jun 16, 2006

I have an autolookup that changes the numbers 2, 4 and 6 into P, M, and D so they look easier for my purpose. However, when I use a select query to find the max number for each criteria it shows a number not the letter. Do lookups stop working when you apply maths or can i change this.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved