I have a tbl that gets populated from an append query and a form that is crated from this table. there is one field that gets populated from the append query called departments, the department names are long and we have abbreviated versions of the department names that I would like to use.
In the table I have two columns “department” (for long name) and “updated department” (for abbreviated department name) When I use the append query to update the department (long name) I want the abbreviated department column to populate.
For example if department column reads "Drilling and Workover" from the append query, I want updated department column to slefpopulate to read "D&WO"
I want the updated department field to automatically fill with the abbreviated name. How do I do this?
Within my table if Field 1 has an answer of Self (from drop down), then, I would like Fields 6-12 to auto populate; however, if Field 1 does not have an answer of Self, then leave Fields 6-12 blank.
I am not quite sure how to lay this out. I am using Access 2010.
I'm creating a database that keeps a track of questions and scores.
The questions in the database need to be dynamic and are changed frequently.
I have a scorecard table which keeps a record of scores and the applicable question at the time the record was saved. I need to do this because in 6 months time we may want to provide feedback. As the question may have changed we need to be able to refer back to what the question was.
I want the question field in my scorecard table to populate with the value in my question table.
I have tried a number of things including setting the question field in the scorecard table to a lookup based on the following query:
SELECT tblQ1.Q1 FROM tblQ1;
This works however only as a list or combo box. I don't want the user to have to select the question. I want it to auto populate, is this possible?
Haven't touched Access in quite some time and now I can do a simple task.
Here's what I have:
2 Tables
Table 1 includes 2 fields COURSE CODE and COURSE NAME
Table 2 will be a list of students and the courses they have taken
What I'm trying to do is as I'm entering a new student in the database I want the course name to automatically fill in when I type in the course name.
I did lookup fields for both the course code and the course name to ensure the correct codes are entered. However since the data in table 2 does not autofill there is the posibilty of having a row with a course name that does not match the course code.
How can I force table to 2 match the course name and code relationship from table 1?:confused:
I have a form with fields "Assigned To" and "Assigned Date". When "Assigned To" receives a value, i.e. Not=Null, I want to auto-populate the "Assigned Date" field with the current date and time. How can I do this? Any help is appreciated.
Hi, just a quick question that i hopes not too hard.
Basically i want one of the fields on my form to get automiatically filled in. I'd like it to take the first letter from one field and the first letter from another field. What im trying to do is make a primary key field up from other fields they have entered.
So for adding new customer i want it to take the firstletter of the firstname and first let of the surname.
SO for myself Luke Tarrant it would be LT. Then i suppose i'll need to add some unique so there no duplicates as it a primary key field im trying to populate.
Just wondering if this can be done: You enter data in the first text box of a field on a continuous form, and all the remaining records are filled up with the same data.
I have an entry form for a table named [Group Members]. The form has several fields deriving data from 2 other tables [Mail List] and [Groups] I wish to automatically display a Group ID when the relevant Group Name is selected from a drop down list.The Row Source Code is as follows;
SELECT [GROUPS].[GROUPS ID}, [GROUPS].[GROUP NAME FROM GROUPS].
The Bound Column is 1.This code fails to display the [GROUPS ID] when a Group Name is entered. Which other controls do I need to modify to achieve this simple matter? I have similar code installed to achieve auto display of Member ID when Member Name is entered. That code is equally ineffective.
I have created two tables one for long term goals (tableA) and one for short term goals (tableB).Each table has its own PK but in tableB I store the PK of tableA for linking the two tables. The relationship is for each long term goal you can have many short term goals to achieve the long term. I have created a form that has the long term on a main form and the short term in a subform. and the linking of the ID's works correctly.
My problem is that on the main form I have another ID field (not a PK) that when I click a button to add additional long term goals I want the ID field copied and populated when the new data entry form is opened.The button is created with the wizard to add a new record.How can I copy the ID from the open form to the same field on the form when the new record button is clicked?
I have a company that has a field for MailingAddress and PhysicalAddresses for shipping. When I enter the mailing address information I'd like the shipping to automatically populate with the information; however, I want to be able to change the physical address, if it differs. Is there a way I can do this without using a combo or list box? I tried changing the control source, which works, but I can't go in and make a change on the physical address without it re-populating the mailing address.
I have 2 fields, a "Total' field and a "Submitted" field. The 'Total' field value will never change as it is used for reporting purposes but the 'Submitted' field will be edited as the work is completed but the initial value should be the same as the 'Total' field.
Is there a way to have the data in the 'Total' be set as the default value for the 'Submitted' field?
I have a text field that I would like to have some information automatically populated when the form is open. I know the basics but the trouble I am having is having the date and time populated before the default text.
Here is what I tried but no luck on it
Code: Private Sub Form_Load() Dim strQuery As String 'Dim js As Integer Dim currDateTime As Date currDateTime = Now() Me.Description = " & currDateTime & " & " " & "J.Adams 41066 CLT SMB - AM : " & " " & "" End Sub
Hi, basically what i want to do is append a record to a table using vba. I would like to take two values from my form (productID, supplierID) and insert them into a table (supplierProductsTBL) under the same headings. I've constructed an sql statement but am getting the following error:
runtime error '3346'
number of query values and destination fields are not the same'
I think this happens because the table also contains an autonumber field (supplierProductID) and i'm not referencing this in my sql statement (below):
mySQL = "INSERT INTO SupplierProductsTBL ( SupplierID, ProductID ) VALUES ('" & SupplierID & "'), ('" & ProductID & "')"
i wuld just get rid of the autonumber field but i need this.
Any help on this would be appreciated, cheers mark.
I have a form with a main form and two subforms. The first subform automatically populates it's linked field with the data in the key field of the main form, but the second subform does not auto populate it's linked field with the data from the key field of the first subform. I have created main forms and subforms before and this was not a problem. Is there a way to cause the second subform to automatically populate it's linked field with data from the key field of the first subform?
I have a database where my indexed field in my table is a number set up like this (ex, 1111-0108) where the first 4 numbers are the record # (so can't dupe) and the second 4 are the month and year. Of course the whole field is indexed with no dupes but changing the first 4 provides the change.
Right now we enter manually when starting a new record in a form. Is it possible to auto populate the new record with the next number in the sequence for the first 4 digits and the current month and year for the second 4? If not, is it possible to auto populate it with the next number in the sequence for the first 4 and leave the next 4 blank?
I'm a noob as far as programming goes, however I built the database so I have a "fair" understanding of access.
i've got a data entry form. when i click the button add all the other buttons go grey, i am in mode "New" also i am able to add, edit, records in this state, when i press save i want the supplierID field to automatically populate itself with the next SupplierID record THAT IS EMPTY. So say that my last record was ID number 45 then when i click add on my form and go into "New" state the SupplierID field automatically populates itself with "46" btw this is all an unbound form,
Both tables are joined with 1 to 1 relations based on apm_id as both of the fields are same. The table [APM] is pre filled with data. The idea is to list data from [APM] and collect data from user to be saved in [DATA] based on the info from [APM].
I created a form which list all the fields from both tables. The fields from table [APM] are only for displaying data and created a combo box based on [APM].apm_id to display the fields by chosing an APM ID from the drop down box.
A user adds a record and moves on to second record, completes the second record. Now if the user wants to list the first record by chosing the APM ID from the drop down box it only populates the fields from table [APM] but not the fields from table [DATA] which the user just added. Infect the fields related to table [APM] changes, but the fields from table [DATA] stays the same.
How ever if I click on the small arrows on the bottom which lets you cycle through records than it populates all the fields from both tables correctly.
How can I fix the issue so that all the fields would populate based on APM ID selected from drop down box.
First hurdle in my database tables, I have a field called Date_Created which I want populated just once, whether from a form or an import.
I have another field called Date_Updated which I want to update any time the record is changed. I know I can do this by using the default value of Now(), but how can I get the Date_Created field just to update when the record is created and not any time after ?
I also want to show these values on the form, but have them as view only, hoping that is possible ?
I am new to Access and have started to move across some Excel based programs.
I have a simple example with two tables and a form where on the form a customer ID is entered which displays the name and below it is necessary to enter the total payments made by that customer for the day ( all records for the same day are entered at one time, which is why I would like to autofill the date).
I can enter the date directly on the form for each customer entry but I would like to automatically enter the required date in the payment table using the value of a datepicker on the form to ensure that no date errors are made.
I have been trying to use the expression builder to do this but the datepicker does not seem to appear as a valid option.
I'm currently building my first database for a research project. When we enroll a participant, we need to have an enrollment date/time as well as an activation date/time (and they are not allowed to be the same because, rules). I was able to figure out how to auto-populate the current date/time when we've marked a person as enrolled. What I'm wondering is if it is also possible to auto-populate another field with the date/time, ten minutes in the future?
I have created a basic Volunteer Events and Hours Volunteered tracking database.
I created a form Volunteer Hours to allow an end user to use that form to record the volunteer and hours volunteered on a specific Event. There are two tables needed in the form Volunteer Hours to be used for the end users to record the Event, Volunteer, Date and Hours. The form has drill down fields from two tables:
I want to be able to select the Volunteer Event and have the event date automatically populate in the Volunteer Hours form date field when the Event is selected to eliminate the end user from having to enter the date in.
Also; I would like to be able to add more than one volunteer at a time to an event on the form, this would also decrease the data entry time.
