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:

More topics

 

Auto Populate Field Based on other fields

Preview
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
 

Help with ActiveX Calendar, SQL and List box

Preview
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 Populate form

Preview
I have a database I need to create a form that will auto populate based on an entered field.

I have two tables:
- tblMailing
- tblSurvey

tblMailing has the customer information with a unique id field "FI_Code". This database is imported monthly.

tblSurvey has about 25 survey fields that will link to the tblMailing database by an "FI_Code".

I need to create a form where the user types in the "FI_Code" and it will auto populate some fields from the "tblMailing" table, and also show the BLANK survey fields from "tblSurvey"

Need to be able to fill out the survey based on the "FI_Code" and have it saved back to "tblSurvey"
 

Auto Populate fields

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

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

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

Preview
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
 

Auto populate form fields based on another field

Preview
I have a field on a form where I want to enter a date, I would then like another field to auto populate with that date plus say 90 days.

I tried having a column in the query that the form is based on to have a default value of date field + 90 but it doesn't work
 

Auto populate based on similar entry

Preview
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 text box with information from auto populated field.

Preview
and looking for some help. I have a database that tracks productivity and a form where the team puts the data.

In order to make it easier for them I would like to automate the process. On the form I have an unbound text box that pulls in the computer name automatically using =GetMachineName(). The computer name is also part of a separate table that includes there name and ID.

I want the form to auto populate the Name and ID field when they open it based on this unbound field called "compname"

This may be simple but I am drawing a blank
 

Using access calendar to populate textbox

Preview
I have a calendar (calendar1) from which I want to populate a textbox (appt1) when I select the date on the calendar but I'm having problem with the code; I tried putting it against the on updated event of the calendar as below, but not sure how far off I am:
Private Sub calendar1_Updated()
Dim myDate As NewDate
myDate = calendar1.SelectedDate
appt1.Text = myDate
End Sub