Access Database - How To Autopopulate By Selecting Physician Name Or Customer ID#

Apr 15, 2008

Hi...I'm having issues.

I have a project trying to manage some patients.

I have a table with all patient information ~1000 patients. However, not all patients will be case managed. I have another table where I will add all the patients that need to be case managed ~ 100-300 patients. I'd like to be able to autopopulate the 2nd form (the case managed patients) by selecting the Patient ID.

I'd like the patient ID to pull the patient info from the 1st table and populate it into the 2nd table.

Same for physicians. I have a physician file with around 2000 physicians. I'd like to type in the physician ID in my form and have it pull all the demographic information for the physician and populate those fields...

Any thoughts? I am sick of cut/paste and retyping all this info that could easily be pulled for seperate existing tables.

View Replies


ADVERTISEMENT

General :: Create Check On A Field (customer ID) Of Customer Table In MS Access?

Sep 7, 2012

create a check on a feild(customer id) of customer table in MS Access , as "Customer ID is of 8 characters, the first 4 are alphabets and the last 4 are digits"

View 6 Replies View Related

Forms :: Timesheet Database - Combo Boxes In Header Autopopulate

Dec 16, 2013

I'm trying to create a timesheet database to keep track of employee hours worked. I have my tables set up as follows...

Employee_T
PK -EmployeeID
PositionTitle
Last Name
First Name
Employer

Projects_T
PK-ProjectID
ProjectNumber
ProjectName
WBS

Timesheet_T
PK-TimesheetID
FK - EmployeeID
FK - ProjectID
Sat
Sun
Mon
Tues
Wedn
Thurs
Fri
WeekEnding

My question is on my input form I want to have the user/employee pick his name once in a header combo box as-well as the week ending date and have it populate to every new record that user input (each employee can charge to multiple projects in a week so I want to eliminate the need for them to pick their name and week ending date everytime they select a different job charge.)

John Doe Week Ending 12-20-2013

M T W TH F
Landscaping 8 4 3 2 6
Roofing 3 5 2 1
Plumbing 1 4 1

View 6 Replies View Related

Help On Patient/physician Case Management File

Apr 15, 2008

Hello,

I need some help.

I have the following tables:

Patient demographic info (Patient ID, First Name, Last Name, Address, date of birth, etc...)
Physician demographic info (Physician ID, Name, Last Name, Specialty, Phone, Fax


I also have another table with patients that are being case managed. I have those ID#'s. However, I want to be able to auto-populate a form with the patient's demographic info by only typing the patient ID. Also, there are cases when the patient ID will not be in the patient demographic info table. Therefore, I will need to enter all their demographic info manually.

Same with the physician. I want to be able to select the physician and auto-populate the demographic info. However, there are occassions where the physician will not be in the main file...therefore, I'd like to add that info manually.

Please help.

View 14 Replies View Related

Customer Database

Jan 21, 2008

hi all,

first time posting so please excuse the newbness.

i need to create a customer database, which i would like to be able to generate invoices from, nothing fancy or complicated, just name, address phone number etc. with a button to put this detail into a template word .doc file.

i would also like to be able to import all names and addresses at the end of the year to send a christmas card maybe or promotional e-mail.

how difficult is this to do? i kinda remember doing something similar at school years ago but can't remember how i did it.

any help/information would be greatly appreciated.

thanks in advance

View 2 Replies View Related

Customer Database Tutorial

Jul 5, 2006

Hi

I am new to Access and would like to learn by taking on small projects.

Does any body know any good tutorials for beginners that could show how to start a database for a list of customers or something similar?

I have looked at the ones that can be created with the Wizards but obviously this doesn't help you understand the mechanics.

I would like to learn the 'nuts and bolts' so that I can expand the database and create new ones the more advanced I become.

Any good suggestions would be appreciated.

Thanks

View 2 Replies View Related

HELP! Customer Database, Quotes, Etc.

Jan 31, 2007

A friend pointed me in the direction of this site, and I sure hope someone can help. I need to build databases that will primarily be used for creating sales quotes. I know my way around, a little bit, but I am having trouble building this database. Would anyone be interested in helping me?

View 3 Replies View Related

Add Customer Name Into Table Each Time Unique Customer Added To SaleTable

Dec 11, 2013

I have a Table Sales - that lists customer and order information

Most of the customers are new - is there a way to populate Customer Name Table with a new entry each time a new customer is input into the Sales Tale

(Without having to add the custome to Customer Name Table - then going to Sales Order)
OR
Failing that - is there a way to use a list box that points to Customer Name Table (and if it doesn't find the one you want, will allow you toadd a new record) In the SAME form as you use to add to Sales Table.

So:
Date (textbox linking to form.Sales) Customer Name (List Box linking to form.CustomerName + adding the info to form.Sale)

View 6 Replies View Related

Help With Customer Care Type Database

Oct 5, 2004

I am having problems with a customer care type database. I used VBAUNBOUND to update information from one table onto a form.

If you select the combo box on the form, it reads the info from the one table, and updates 3 other text boxes in the form, but it doesn't update the main table in the database.

Tables:
Contacts - Customer problem details
tblcustomer - Branch details


Query:
qurycustlisting - Reads info from tblcustomer (used in form Contacts)


Form:
Contacts - Manually input details. Select branch name in combo box (reads from query - qurycustlisting) and then updates the rest of the branch details on the form. But the info insn't updated into Table Contacts

Pleas help

View 1 Replies View Related

Creating New Database On Customer Quotes?

Jul 13, 2012

I am assigned to create a customer quote database for our company. Now it is in excel and already have 40,000 records and increasing average 25 records everyday. The way they want to send quotes are:

- The number of items in the quote are varied from 1 o 15.

- Each item has six different prices, depends on the order qty and want to mention in different adjusent lines.

- Each item has different delivery time depend on order qty.

- Company's sales Terms and conditions need to be printed at the end of each quote in separate page. (two full pages)

How do I create the table to accommodate all these fields? Is it possible to accommodate all items/sub items in one table under one qutoe id. I have customer table, product table etc ready and little confused to create the Quote table.

View 2 Replies View Related

Best Option For Grouping Areas In A Customer Database?

Feb 16, 2006

Hi all, just wondered if anyone would have an idea of the best way to implement this? I have a customer database, the relationships are below, and currently have done searching by town/city, street, purchase date, and also searching by area. But now the person i created it for wants to be able to search by 'groups of areas'. He has written how he would like to be able to search and they often include 3, 4, or 5 areas grouped together as one, and in only one or two instances he has included a small town aswell as a few areas.

Basically, it's been a while since i actually made the database (a year or so) and have not been using access much at all, so i'm having a bit of trouble working out how i'm gonna go about it and would like some idea's :D . I'm sure once i get back into the swing of it i'll be ok, but i feel like a newbie again at the moment :o :rolleyes:

Many thanks for any help you can give.

http://img349.imageshack.us/img349/7052/relationships8na.jpg

View 14 Replies View Related

Combining Customer And Customer Contact Tables

Dec 24, 2011

I have a DB set up with a debtors table (Customers) and a Customer Contacts table, I was thinking of combining these two tables into one.Most of the Debtors are companies, but a few are actual people. With the current setup, i need to have both a debtor and a customer in two different tables, but with exactly the same data.

View 1 Replies View Related

Selecting A Row In Database?

Jan 22, 2013

I was wondering if there is a way where I can select a row on my database table and pull that information to show up in my form?

View 1 Replies View Related

Developing A Customer Satisfaction Survey In Access

Oct 8, 2004

Hi -- my first time here...
Has anyone ever had to develop a survey (e.g., customer satisfaction survey) in Access? Does anyone have any advice?

View 1 Replies View Related

Newbie Needs To Find Out How To Remove Autonumber From Access Customer Order Template

May 19, 2006

I am trying to use the template provided in the Access database wizards, pages and projects. Its called Order Entry. What i would like to do is edit the template to fit my needs but i need to change the Product ID feild from Autonumber to a product id of my own. I would however like to keep it as the Key.

Any Suggestions?

Mulith

View 1 Replies View Related

Newbie Needs To Find Out How To Remove Autonumber From Access Customer Order Template

May 19, 2006

I am trying to use the template provided in the Access database wizards, pages and projects. Its called Order Entry. What i would like to do is edit the template to fit my needs but i need to change the Product ID feild from Autonumber to a product id of my own. I would however like to keep it as the Key.

Any Suggestions?

Mulith

View 1 Replies View Related

Autopopulate???

Nov 4, 2005

Got a problem I can't figure out. I will try and explain in my newbie language.

I have a list of companies and a very long list of employees who work in those companies. On my form, would want the user to be able to select a company from a combo box. Afterwards, I would want another combo box be populated with only the employees from the selected company so that they could select the employee without scrolling down for an hour....
How can I make this happen?

View 2 Replies View Related

Autopopulate Form

Mar 31, 2005

1. how do i auto populate a form from another table. like a repair form pulling up information from the vendor table.

2. I have been trying to pull information into my form 'check stock' from a table called 'inventory'.
i want to be able to just enter the serial number and then autopopulate the rest of the data from the inventory table.

the quantity that is displayed in the check stock table must be the difference of the quantity in the inventory table and the requisition table.

3. Also, every time i enter something in the inventory table, i want it to be able to iteratively check for any avaliable stock and update the quantity instead of making a new entry every time.


please help

View 1 Replies View Related

Autopopulate Related Field

Apr 4, 2008

I have a table that I'm storing Horsepower and Watt in. Is there anyway to set it up so that when I provide Horsepower it automatically populates Watts? (just a simple multiplication)

View 1 Replies View Related

Need To Autopopulate A Field In A Form

Jun 21, 2007

Have form as follows.

Can # (Lookup/dropdown)
Movement Date (date/time)
Current Location (lookup/Dropdown)
Current Address (lookup/Dropdown)
Prior Location
Prior Address

When I drop the can # down in the form, I want the Prior Location and Address to auto Populate with the last known current Location and address of that can.

Any ideas on the best way to do that?? I assume there is code and a query, but I am an absolute database illiterate so exact directions would be nice.

To explain again, whenever I put a new record in, as soon as I select the Can# from the drop down tab, I want the prior location and address to be populated with the last known current address for that Can#. And if I change the can # I want the prior location and address to change with it.

HELP PLEASE.

View 4 Replies View Related

Forms :: Autopopulate For One Of 8 Fields Only?

Mar 18, 2013

I have a Subform/Subreport that shows in a datasheet view. I hosts two (2) fields on it: "Job Performed" & "Details". The "Job Performed" field is a drop-down list. The "Details" field is a memo field.

What I am trying to do is, well, one of the selections in the drop-down list will ALWAYS have the same details - "Changed Oil & Filter". But all of the rest will vary constantly.

So my question is, can I make it so if "Monthly" is selected from the first (drop-down) field, it will ALWAYS populate the Details field with the words "Changed Oil & Filter" without affecting the other selections?

View 1 Replies View Related

Autopopulate Data Based On Relationship

Feb 21, 2013

I am trying to create a 2-table database where we can enter our survey data. I want them to be linked by "head"# so that the "Temp" "Date" "island" and "site" are autofilled into the "time dep"table from the data I entered in the first "perm"table.

I would also like if the lookups were filtered so that, for example, when I choose "Cat Island" my only two options are "fishbowl" and "Cuda" then from there depending on which of those I choose, The "head"# can be chosen from a dropdown as well. There are about 22 coral-heads per site, and two sites per island. I don't want to have a giant dropdown of 80+"head"#s, but at the same time, if we are typing them in, it increases chance of error. limiting the options of head number to be site specific would be ideal.

I feel like I may be going about this all wrong, and need a form? But I cannot figure out how to make the form data fill the datasheets that I have created.

Metapop.accdbMetapop.accdb

View 3 Replies View Related

Autopopulate City & State From Zipcode Table

Mar 1, 2005

I'm stuck on something that should be simple, but maybe it isn't:

Problem 1:

To speed data entry in a contact table, I want an entry in the Zipcode (postal code) field to automatically populate the City and State fields from the data in a Zipcode table (Zipcode-PK, City, ST (2 letter code)). The Zipcode table has only one city /st for each zipcode, so it can be the primary key (always a five digit number, sometimes with leading zero(s)).

Sometimes there are several names for a City associated with a particular Zipcode, so I want the City field to be able to be overwritten with a different city name if the data entry person needs to do that. Alternatively, I could establish a separate primary key for the zipcode table, and allow several choices for the rare zipcode that has more than one city name in use.

If I did that I wouldn't have to store the city and st in the contact table (which is better database design, I realize), but I really do want to be able to store the city and state in the contact table because there will be times when the right zipcode isn't known, and the city and state are known, and forcing the input of a possibly incorrect zipcode would be undesirable.

Problem 2: I've got a table with 4,000 records where I have the zipcode, but the city and state information were lost, and I want to be able to re-populate those fields by writing, I guess, an update query that taps the info in the zipcode table.

Problem 3: When entering addresses, sometimes there won't be info about a certain zipcode, and I need some automatically generated dialog that allows adding city and state info for a new zipcode that won't slow down the entry of contact records.

Any help would be greatly appreciated. Thanks in advance. Send an email if you prefer.

HenryTD

View 3 Replies View Related

Forms :: Enter Data To Subform With Autopopulate

Jun 24, 2015

I know the way to SELECTDISTECT on a combobox referring to a table so the value will autopopulate in the combobox. But is that doable in a subform?

I have a table with 3 columns. First Name, Last Name, Relationship.

I want to let the user adding data directly to the subform, but when typing RICHARD in the first record of First Name, then on the second record, when they type R, it will suggest RICHARD, a kinda auto fill if desire.

View 11 Replies View Related

Tables :: Autopopulate Field Based On Contents Of Another

Sep 12, 2013

I am in the process of revamping an old database. I have a main table that currently has two fields "Name" and "Job" but will have more. I have another table with the same fields. I want to use as a lookup to populate the main table with a user form from the second table. I can populate the "Name" field using a combo box, but my problem is how to autopopulate the "Job" field. E.g. If the user selects Mr Smith from the "Name" drop down list, the corresponding "Job" populates the second field.

View 4 Replies View Related

Autopopulate Field When Checkbox Is Selected True

Jan 27, 2012

I would like to have a field autopopulate (date field) when a checkbox is selected 'true'

Fields are:

FolderBCCheck-In (checkbox field)
Check-InDate (date field)

I need the check-inDate field to populate Date() when the FolderBCCheck-In field is checked.

I assume it is VBA code to the AfterUpdate (Event procedure). Just having trouble getting the right code.

View 10 Replies View Related







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