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:

Similar posts...


Auto Populate fields

Auto Populate fields Icon
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.

Understanding relationships and auto populate...

Understanding relationships and auto populate... Icon
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-Fill names

Auto-Fill names Icon
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?

Is there a way to auto-populate one field with the same data for each record? Icon
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

Auto Populate Field Based on other fields Icon
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 Fields like user ID address etc.

Auto Populate Fields like user ID address etc. Icon
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...

Auto Populate from combobox but save in new table

Auto Populate from combobox but save in new table Icon
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

Auto populate based on similar entry Icon
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

Auto Populate Invoice

Auto Populate Invoice Icon
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 #.

Attached Files

Attached Files Icon
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