I have a table with a few fields, which include a field called StartDate and a field called EndDate. From the table I plan on finding the Min StartDate and the Max EndDate, is it possible, to make a table from these 2 sets of data and have the fields in between be auto populated in increments of a month?
For example. (Dates in dd/mm/yyyy format)
StartDate=1/1/2014 and Max EndDate=1/12/2014
So the table should show:
1/1/2014
1/2/2014
1/3/2014
1/4/2014
1/5/2014
1/6/2014
1/7/2014
1/8/2014
1/9/2014
1/10/2014
1/11/2014
1/12/2014
Okay--I have a table of scholarships, and each one has fields for primary contact, secondary contact, tertiary contact, etc., in which the names of the contacts associated with each scholarship are stored. What I need to do is to have every name pulled from this table and listed--each as its own row--in another table. I'd like it to do this automatically so that if a new name is added to the scholarship table, it will create a new row in the other table.
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 have a Table (tblFPAData) that is being populated with entries from a form I created. There are several fields but if I can get an answer for one relationship then I can repeat it for the others.
In tblFPAData there are the fields MaterialNo and Description.
I am creating another table called tblSchedule and using a form to enter the information. I need the user to select the MaterialNo from a combo (cmbMaterialNo) and the then table auto populates the Description from tblFPAData.
I have two forms - Main and StudentAdvisor (filtered by student ID#) SAdvisor.jpg
The main form originally had a combo box field to display advisor, the problem is that some students had multiple advisors during the course of their program. This problem was fixed by the creation of a StudentAdvisor (table/form) for recording ALL advisors. I set the form to display by newest term so the current advisor (or initial if no change) is the displayed record.
On the main form I then added "add" to open the StudentAdvisor form for entering information, and an unbound txtfield to display their current advisor (or initial advisor if no change).
The problem is I can not get the txtfield to display the information. I have managed to get the error ( #Name?)
Advisor Type 1=Initial, 2=Current, 3=Previous Changed 1=Yes, 2=N/A
so a record would record as: Initial and N/A Current and Yes Previous and Yes
I tried writing DLookup but could not get that to look up the combinations (above) and display either initial or current.
also tried pulling form SA = Advisor to form Main = txtAdvisor
For report purposes I need to know not only current advisor but how many were assigned during the program and also how many students each advisor was assigned during certain time frames.
In my UpdateForm I have 3 fields. PartNumber, Description and SerialNumber. I use 2 tables for these. My MainTable and PartsList Table.
In my PartsList table I have the list of PartNumber in Column (0) and Description in column (1).
In my MainTable I have 4 fields: TransactionID (autoNumber), PartNumber(text), Description(text) and SerialNumber (text).
Now, In my UpdateForm I want the user to just select the PartNumber with a combo box (that also show the "Description" (I created this using the combo box wizard)). But I want to auto populate the field in my "Description" text box every time the user will enter new record and will also update my MainTable with all the values they entered in my UpdateForm.
I tried this codes in the after update of PartNumber combo box (properties):
I have with my database. It's holds cost data including purchase made in foreign currencies which need to be converted to GBP using the correct exchange rate so a variety of reporting & stats can be performed.I have a table called Costs within which there are 2 fields
Purchase Currency Exchange Rate
I also have another table called Exchange Rates 13/14 within which there are 2 fields
Currency Exchange Rate
When a value is entered in the Purchase Currency field on the Costs table (this is a look up field linked to Exchange Rates 13/14 so it shows the listed currency in drop down) I need the database to automatically populate the Exchange Rate column in Costs i.e. match the value in the Purchase Currency field to the Currency field in Exchange Rate 13/14 and populate with corresponding Exchange Rate from Exchange Rate 13/14.I have tried the following and none work:
SQL Tried
1. UPDATE Costs SET ExchangeRate = [Exchange Rates 13/14].[Exchange Rate] WHERE Costs.[Purchase Currency] LIKE [Exchange Rates 13/14].Currency
2. UPDATE Costs SET ExchangeRate = [Exchange Rate] FROM [Exchange Rates 13/14] INNER JOIN [Exchange Rates 13/14] ON Costs.[Purchase Currency] = [Exchange Rates 13/14].Currency
3. SELECT [Exchange Rate] FROM [Exchange Rates 13/14] WHERE Costs.[Purchase Currency] LIKE [Exchange Rates 13/14].Currency
I know it is possible to have a drop down for Purchase Currency which shows 2 columns (both Currency and Exchange Rate) you can then use the exchange rate figure for a calculated field. The problem I have is that I am importing data into the costs table from excel. In Excel I can only have 1 value in the Purchase Currency column on the upload template. If I just have Euro in this column the database does not match it to the Euro in the Purchase Currency drop down and also store the correct exchange rate.
Or is the alternative to put this into the calculation of GBP Unit Cost where this somehow matches the Purchase Currency in the Costs table to the Currency field in Exchange Rates 13/14 tables and uses the appropriate exchange rate from Exchange Rates 13/14 to calculate GBP Unit Cost in Costs table.
Is there an easy way to auto-populate a Junction table [in access 2010] given the following two tables with a many-to-many relationship for Tasks? The two tables are
I am creating a database to keep up with the expenses for my art business. I have a table for Vendors with a field (Mileage) for one-way mileage that I enter manually (EX: 11.8 miles). Then I have a calculated field that basically just multiplies the Mileage field times two to get total mileage to and from my house to vendor location. (Total Miles) {The reason I want to do this this way right now is because I didn't keep up with my mileage this year and I am having to look up the distance from my home to each location)
Then I have a "supplies" table where I show the date, the vendor, the item, cost, etc, and I want to add a Total Mileage field based on the calculated Total Miles field in the Vendors table that will automatically populate based on the vendor of each transaction. I just can't remember how to make this work and I know just enough SQL to be dangerous.
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?
I have a form in datasheet style .....it only has 3 columns Id ,date and hrs what i would like to do is poulate the date column with the dates for the month based on the first entry I.E if the first dat inputted is 1/7/06 or chosen somehow )it would fill the remaining dates for that month into the column any ideas ???
What I’m trying to achieve is a database that I can enter the number of calls a salespersons makes in a day. Please find diagram below.
<< Date >>
,,,,,,,,,,,,,,,,,,No-Calls Name Ben,,,,,,,,,,,,,,,1 Bob,,,,,,,,,,,,,,,2 John,,,,,,,,,,,,,,3
I have kind of got one working but when I create a new day I have to type in all the names every time and it get a bit boring. Can anyone point me in the direction of how to auto populate the names of salespersons when I ad a new date ?.
I have attached a quick mock-up of what I have got so far so if I haven’t explained myself very well hopefully you can see what I’m gibbering about.
Hi all,I tried looking for an answer to this but I haven't found anything yet. I have a form that features a 'Bill To' and 'Ship To' section with 'City, State, Zip etc..' for each one. I'm triyng to create a button that my users can press to automatically copy the data from 'Bill To' into the corresponding fields in 'Ship To' to save time if the data is the same. I tried creating an update query but it seems to confuse the form code and throws errors.Any help you can give me would be appreciated.
I know this is a easy task, but I can't just figure it out. I have a table with branch No and Branch Name. In my form I would like the user to select the branch number from the combo box and the Branch name field will be placed in the Branch Name field automatically. How do I go about handling this task.
Ive been through-out a decent chunk of the internet, trying to figure out how to Auto-Fill or Auto-Populate a select number of Text Boxes on a form.
Example ill sit there type in someones ID number and his Name, Where he works. all of that information have come up yet considering its probably a really simple question, can someone please help me out.
Hi, everyone! I hope that someone is willing to help me with a database that I'm trying to set up. I'm a teacher and want to use Access to track behavior notes and parent contacts. I'm trying to make the database work efficiently for me and need some help with auto-populating fields.
Here's an example of what I want: Field 1= date (I have this setup to fill in automatically) Field 2= student name Field 3= behavior code Field 4= comment
I want to type in a code for a behavior in Field 3, such as "t", and have "talking excessively" automatically pop up into Field 4. This would just make it faster for me to enter all my info, and then I can make a report that only shows the date, name, and comment without the codes showing up. I currently have the behavior codes listed in another table, but I don't know if that's where they belong or what. I've found some web sites that have codes for auto-populating, but I have no idea where to put them or what to change in order to personalize them for my database. Is there anyone willing to walk me through this? TIA!
These are the codes that I have: codememo bdid not have book in class cdclass disruption dadetention assigned dcdress code violation dsdetention served hdhad head down throughout lesson nwdid not complete classwork ooffice referral rreferral for 4 tardies ssleeping sdskipped detention ttalking excessively wdid not have workbook in class
Maybe im just having a brain fart, but I cant get this method to work.
There are two forms, the first records Two Names, The Bride and The groom along with their wedding date and where they registered. After all the data is entered on the first form, the first form is closed, and the second one is open.
What I would like to do is pass the info from the first form on to the second one. The second one uses the bride's info and the wedding date.
I tried using the query to fill it in but I havent had any luck. Been a long day.. maybe just not thinking clearly.
Any help would be appreicated, and thank you in advance to any replies!
I accidentally posted this in "general"...so I am posting it here under "forms", since it is "form" related. My intention was not to double-post...sorry. Summerwind had posted an example to auto populate a combo box. The code below follows his example, but is not working for me:
The fields I have on my form are:
cboCompany cboLocation
cboCompany is based on tblCompany( with fields CompanyName, Location)
When I update the cboCompany field, I want the cboLocation combo box to populate with all locations for the company that was entered into the cboCompany combo box on the form. E.g. The company "Visions" may be exist in the tblCompany with 3 different locations: Visions (Las Vegas), Visions (Ohio), Visions(California). When I pick the company "Visions" from the cboCompany combo box, I want the cboLocation combobox to be populated with "Las Vegas", "Ohio", and "California".
The code is as follows but returns empty records in cboLocation:
Code: Dim StrSource As String
StrSource = "SELECT Location FROM tblCompany WHERE tblCompany.CompanyName Like " & Me.cboCompany.Column(1) With Me.cboLocation .RowSource = StrSource .SetFocus .Dropdown End With
I have a standard Data Entry Form based on a WorkOrder. I am dealing with over 90 offices nation wide with mulitple offices in a state. I have a seperateTable that lists all 90 Offices which I have created a Query to Promt the user to enter the State code for that State.
Is there a way I can Select an Address from the Query and auto populate that information onto my WorkOrder form?
Any help would be greatly Appreciated as I have Exhausted myself trying to figure this out!
I am creating an inventory database and was wanting to know how to make a combo box or any box auto populate information from tables. I would like to have a combo box so that you can do a search inside of it and find the necessary product, select it, and all the product specs will be displayed. I have created the combo box with this information, but no luck getting it to populate on the form itself. Thanks in advance for your help.
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:
When I populate a combo box named BusOrgCode, I want to auto-populate the HRName box with the name that corresponds with the Bus Org Code. I get a run time error "2001." Help!
Here's my code: +++ Private Sub BusOrgCode_AfterUpdate()
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function. strFilter = "BusOrgCode = " & Me!BusOrgCode
' Look up HR Partner Name and assign it to HRName control. Me!HRName = DLookup("HRName", "HR by Bus Org Code", strFilter)
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.
