Auto-populate and Attachment Problem
Auto Populate fields
I have a form (see attached) which has a field called PropertyID. Originally I had Indexed set to yes(duplicates OK). When I would enter an ID the manufacturer, model, and serial # fields would auto populate.
I then realized that with that setting users can enter duplicate data. When I changed Indexed to Yes(No Duplicates) I lost the auto populate function.
I would like to have the best of both worlds. I need the field to stay Unique as well as populate those 3 fields.
Could someone please explain in very basic terms of how to auto populate a field in a table. I would like to enter a user ID and the address, name ect comes up...
Understanding relationships and auto populate...
It may help to understand what kind of tables I currently have in Access 2010.
I have an employee table that shows employees and some basic information about each of them. This table has an employee ID field that is not an autonumber but it is unique to each employee (10004928).
I have other tables that also use that same field and I want the first and last names to auto populate based on the main employee table. These other tables are tracking OT and Vacation time used.
How do I make the later tables auto populate the name fields when you key the employee ID?
I am building a database to track our returns and what I would like to do is once you select the Item # from a drop down, I want it to auto populate the Item Description and Cost fields as well. Can someone please help? My mind has gone to mush and I can't think
I am trying to create a form with several auto-fill options. I know it can be done, I just do not understand how. My goal is to be able to input a name and their managers automatically populate. Also, I would to be able to put in (for example) and number and its coorisponding meaning would populate. Is this possible all in one form? And if so, how can it be done
Is there a way to auto-populate one field with the same data for each record?
I have an Access 2010 database I am building and I would like to have the same value auto-populate into the one particular field for each new each record, so the users do not have to always type it in or use a drop-down menu via a combo box to bring it up. Is there a way to do that?
Auto Populate Field Based on other fields
I am a total access newbie when it comes to designing a database. I have managed to create a simple web database for project management but have run into a snag.
I want to have a field (field 3) auto-populate based on what is entered into two other fields (field 1 & field 2).
Field 1 is a date field (when a presentation is due). Field 2 is a yes/no checkbox (if checked, it means no presentation is necessary). Field 3 would be a calculated text field (?) because text cannot be entered into Field 1.
If field 1 is null and field 2 is checked, then I want "NA" to auto populate into field 3. However, if field 1 is null and field 2 is not checked, I want "TBD" to auto populate into field 3. If field 1 is not null, then I want field 3 to be null
auto populate combo field?
would like just to seek for an assistance.
my problem is how can I automatically populate the
data into the combo txtbox2 after I updated or input the data
in combo txtbox1.
wish I could have the answer soon. this will help me more in my project.
Problem with fields on a form (relationships?)
I've got a database (inherited) and theres an strange problem with two of the fields.
There are three tabs on the form, each is populated by the user with data for the record, and each of these tabs is putting data into a specific table (one for each tab). Not sure if it is relevant but the value going into the fields inquestion are the primary key fields for two of the three tables.
When one of these fields is populated on the form, the other two automatically populate with this value.
However, this is the only way they can be populated, the number has to go into the textbox for field 3, and field 1 and 2 populates. I can't enter into field 1 or2.
This is how we would like it to work, but I want to populate one of the other fields first (field 1), and the remaining two auto populate.
The problem is, no one here as an access expert and no one nor I can understand how these fields are linked? Everyone is scratching their heads at it.
Auto Populate from combobox but save in new table
What I am trying to do is select a book from the comb box and have the other information auto-populate. That being said I also want it to save in the feedback table. I know this is duplicating data but it is what I need for stat purposes and exporting to excel later. I have attached photos to show the books table...
Auto populate based on similar entry
Is it possible to auto populate an Access text field in a form when one begins typing the letters, based upon similar entries made from previous file entries in this same field in the database?
This would be similar to how Office or Word does an auto type based upon the initial letters typed.
I've searched the forums and found a number of inquiries regarding auto population, but they're usually tied to another field or table, not the same field in the same database
Updating records with attachment fields
I maintain a 9 year old database which I recently converted to Access 2007. While doing so, an attachment field was added to one of the tables.
My problem: I recently gathered some data in the attachment fields in the development copy of the database and wanted to transfer the additions to the production table. The update query came back with a message to the effect that you can't use an attachment field in an update query.
Has anyone else encountered this problem? If so, what is the workaround? VB or manual re-entry of the data
Auto Populate Invoice
I have a spreadsheet with 2 sheets: 1) Invoice and 2) Inventory. What I would like to do is, when I type in the part # in the invoice, I would like the Description and List Price to auto-populate with the appropriate data for that part #.
Populating attachment field based on text box
to pbaldy, I solved the first part of the problem here:
Lets say you have four text boxes and one attachment field on your form
One number data type (in table), we'll call it LookupNumber
Second is a number, ReturnNumber
Third is a date, ReturnDate
Fourth is text, ReturnText
Fifth is an attachment field
I am able to have the user specify the lookup number and look up the values with the following code:
Dim db As DAO.Database Dim rs As DAO.Recordset
Set db = CurrentDb Set rs = db.OpenRecordset("Select * FROM TrackingTable WHERE [LookupNumber] = " & Me.[txtLookupNumber])
And then using code like:
Me.txtReturnNumber = Nz(rs!ReturnNumber, "")
My question is, how would I populate an attachment field like that
Auto populating and multiple selection drop down lists
Please excuse my ignorance; I am very new to access. I have a few questions;
1) I am having problems getting a text box (within a form) to auto populate in another text box in a sub form.
2) I am also not able to create a drop down list that allows you to make multiple selections and have those selections auto populate in another form
Email: auto populate "TO"
Auto populate “To” email field with email that’s associated with that reports recorded vendor
I created a database with an attachment field that is working fine. But for future use, we will be using a SQL database so the attachment field, which is not supported in Microsoft SQL 2005 will become useless for our ASP.Net application. I would like to keep using the attachment filed in access, but I would like to add the actual file name to the table as well without having the user add it.
I can see the attachment FileData, FileName and Filetype when I go into query view, but when I attempt to create an update query that will take the FileName and populate the new field, I get an error that states
Enter Parameter Value with the ReportAttach.FileName below.
Does anyone know how I can get the Filename into a new field
I have a form that has 2 date fields. One I enter the date the other I want to auto populate with a date 90 days from then.
Auto-populating table field
I know auto-populating has been asked before for forms, but I am looking to auto-populate a couple of fields in a table based on an ID Number that corresponds to another table. I realize it is not the best practice to duplicate data in a DB, however, I am using an ID card program that requires tables to populate the ID card information. My hope is to have two separatetables for 2 versions of ID cards.
The first table is called Firefighter info with fields of ID Number, First Name, Last Name, and Firefight Certs, EMS Certs, and emergency contact information. The second table is called EMS Personnel with fields of ID Number, First Name, Last Name, EMS Certs, and other fields that will be entered manually.
I would like the First Name, Last Name, and EMS Certs fields to auto-populate in the EMS Personnel table when the ID Number is entered.
Auto add attachment
I have orders I send out from my DB. Some have attachments, some do not. Is it possible to take the orders with no attachment and add a generic one before sending