Topics Search

Auto-populate and Attachment Problem

Auto-populate and Attachment Problem
Views: 6
Firstly I would like to auto populate certain fields base on a ride name but do not know how to go about doing that. Next, whenever I start filling in a form, and when I wan to attached a file it always show "Cannot update. Database or object is read-only". I can only attached a file when I go next and then go back which I think is not really practical.
Sponsored Links:

More topics


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.

Auto Populate

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?

Auto populate

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

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-Fill names

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

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...