How to create an auto-populate blank txt field from a calendar on a form?
I have a calender on my form. What I would like to create is a diary system were the user clicks on a date on the calendar and it autopopulates in a blank date text field to schedule an appointment. Can this be done, if so how?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
These are the problems:
1. ActiveX Calendar. Calendar Form opens when you click in control on another form. Need date selected on calendar form to populate [CourseDate] field in other form - doesn't work anymore.
2. List Box - this is more complicated.I need one field to populate based on another - used to work, but now it doesn't.
3. SQL - Using a QBF search. Set up search using SQL statements found on another forum/help site, all but two work like they should.
I have a MAJOR presentation tomorrow so I need serious help. I can send the db to anyone who thinks they can help me.
I have a form that we are going to use to track outages to our terminals. On the form, the user selects the terminal # and the rest of the information for the terminal auto populates from a query of the terminals table (Terminal name, address, etc). What I am using to auto populate fields is =[Term #].Column(1) for the first field and so on. They then enter the rest of the info (date of outage,etc). The issue I have is that when I look at the table for the outages, the auto populated fields are blank. Is there a way to save this data to the table
I'm trying to auto-populate blank fields on a form based on a combo box with customer names. In other words when the user clicks on a name from the combo box the customer's details will populate the blank boxes with all there details.
The customer details are stored on a table and I'm using access 2007. It'sbeen a while since I'
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
I have a form used to input Help desk tickets. On the form there is a choice to select a customer- what I would like to do it auto populate another field on the form based on the customer.The "Customer Field is pulled from a separate table and I would like it to populate an account Number field on the form which also comes from the Customer table.
I'm fairly new to Access | and I've built a form with a single table. It's a very simple form.
I’m trying to auto-populate a field in the form based on another field. For instance, I have a field named “Date seen” (which is manually filled in) and another field named “Due Date”. I’m trying to auto-populate the “Due Date” field so that it auto-populates with a date exactly 6 years after the “Date Seen” field.
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 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?
In the tutorial A Pop-up Calendar for your Access Forms I showed how you could use the ActiveX calendar control to add a pop-up calendar to a form. The calendar is placed on the form just like any other control but remains hidden until the user clicks a specific field, when the calendar becomes visible. Choosing a date from the calendar hides it again. But what if you didn't mean to open the calendar... how can you hide it without choosing a date?