Topics Search

How to create an auto-populate blank txt field from a calendar on a form?

How to create an auto-populate blank txt field from a calendar on a form?
Views: 8
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?
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.
 

Help with ActiveX Calendar, SQL and List box

Help with ActiveX Calendar, SQL and List box Icon
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.
 

Auto Populated Field not Saving to Table

Auto Populated Field not Saving to Table Icon
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
 

How do I populate blank fields based on a named field in a combo box on a using vba?

How do I populate blank fields based on a named field in a combo box on a using vba? Icon
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'
 

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 populating a field based on another fields choice

Auto populating a field based on another fields choice Icon
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.
 

Forms and fields

Forms and fields Icon
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.
 

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?
 

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?
 

Hide the Pop-up Calendar by pressing the Escape key

Hide the Pop-up Calendar by pressing the Escape key Icon
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?