I have a form (Form1) with subform (SForm1) embedded in it. Now my Form1 is based on query (query with search criteria) which is dynamically linked (with VBA code). I want to populate SForm1 dynamically with records based on one field (customerID) of Form1.
I am able to populate Form1 with search query, however, the SForm1(subform) is not populated. The SForm1 is based on query with criteria which is supplied by (customerID) in the Form1.
Any help is appreciated.
Thankx in advance.
Prodigy.
I have a Form1 and Sub Form2...Form1 is a list of tasks: Each task has a quantity of Items.The forms are in Datasheet format.I have a list of people who can only do specific tasks and at present my Form2 is able to only select the relevant people for that task.The only way to "Trigger" who can do which task is to populate what quantity of work I want them to do. ie. create a link.
Is there anyway of clicking the little + button on Form1 that it prepopulates the total quantity to Form2 therefore creating a link and therefore being able to select who can do that task.If you look at the pic I want Items in the dropdown box to pre populate with the same amout as in the Form1 Items ie "1"
A subform on a main form is not populating after the user clicks on the subform and then returns to the main form and updates the field which the subform is linked to. The first time the subform populates absolutely okay; however once the user clicks on the subform and then returns to the mainform and updates the field which the subform is linked to the subform goes blank.
Now, I have created a main form based on student table and a subform based on studentCourse table. However, because I needed to populate the courseName and CourseDescription in the subform I changed its record source to a query (stID, courseID, courseName, courseDescription) so that when I move between the subform records the courseName and courseDescription still show in the subform.
To populate the courseName and courseDescription in the subform I changed the courseID to a combobox so that it brings the courseName and courseDescription from the course table and show it in the subform.
Everything is working fine so far BUT when I choose to input a courseID manually into the combobox, it does not populate the courseName and courseDescription as it does when I choose the courseID from the combobox.
I have created a form "PAYMENTS" that include a sub form "PAYMENT DETAILS".
In the sub form control Policy Id is defined as combo box, and retrieving the list from Policies and Payments where Policies.Client=Payments.Client the query of Combo Box is as follows:
Code:
SELECT POLICIES.[POLICY ID] FROM POLICIES WHERE (((POLICIES.PAID)=False) AND ((POLICIES.CLIENT)=[Forms]![PAYMENTS]![ClientId]));
Only first time Combo Box display the Policy Ids according to the Client, but when I change the client and always displays the previous clients Policy Ids.
how to retrieve correct list of Policy Ids according to the Input Client in Payments.Client control
I'm trying to get a combo box to populate the box next to it.
Basically pick a project number in the 1st box and have the project name show up in the second box.
I have it working, but the problem is that when it puts in the name of the project, it fills the whole column with that name, and not just the one box.
Here is what it's doing: http://img156.imageshack.us/img156/2659/dbhm4.jpg
Here is the code im using.
Private Sub ProjectNumber_AfterUpdate() On Error Resume Next
Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String
ProjectNumber.SetFocus If ProjectNumber.Value > 0 Then strSQL = "SELECT * FROM ProjectList WHERE ID = " & ProjectNumber.Value
Set db = CurrentDb Set rs = db.OpenRecordset(strSQL) If Not rs.BOF Then Me.ProjectName = rs("ProjectName") End If rs.Close Set rs = Nothing db.Close Set db = Nothing End If
I am new to database and hope this is a simple problem. I have a few thousand products each with their own code and description.
I would like to create a form that when I type in the code the description self populates in an adjoining box. I would like to enter at least fifteen codes and their descriptions per form. Have tried related tables using forms and sub forms with child/parent link but any editing of code changes the information back on the table. Tried parameter query but how can I get more than one code on a form at a time? Any suggestions greatly appreciated.:confused:
I am looking to populate fields of one form based on another table with about 100 records.
Information Table Name: 1) StaticInfo 2) Data
Form Name: EntryForm (Based on the Data table)
I want to be able to select a value in a combo box in the EntryForm and have certain fields populated in that form based on the StaticInfo table.
Want to use all of the fields in StaticInfo to populate the same fields in Data. Historical data in the Data table needs to remain intact, meaning that if something is changed in the StaticInfo table, the historical records will remain unchanged in the Data table.
So, if I am able to select a department in a combo box in the EntryForm and have the fields populated in this form based on the StaticInfo table, will the records in the Data table change or not change if there are changes made to the fields in the StaticInfo table?
Also, could someone provide a method as to how I would go about populating these fields from table to form.
I created a form and in form I have created a combo box, and I can make as many selection I want through multiple box properties; however, its not populating in the table. Now if I keep select non in multiple menu I can input the value in table through that form. How can I make this field populated with more than one value.
I have two tables. One is a simple two column table with Short Date and the corresponding Day of Week. My second table is an employee schedule based on Day of week. I bring the two together by the "Day" variable to generate a schedule for a specific time period, but I also want it to return the days where there is no data.
For example, I have a schedule listing like this:
J SMITH MON 8:00 16:00 J SMITH TUE 8:00 16:00 J SMITH WED 8:00 16:00 J SMITH THU 8:00 16:00 J SMITH FRI 8:00 16:00
My result is this:
J SMITH 9/18 8:00 16:00 J SMITH 9/19 8:00 16:00 J SMITH 9/20 8:00 16:00 J SMITH 9/21 8:00 16:00 J SMITH 9/22 8:00 16:00
I want to see the following:
J SMITH 9/18 8:00 16:00 J SMITH 9/19 8:00 16:00 J SMITH 9/20 8:00 16:00 J SMITH 9/21 8:00 16:00 J SMITH 9/22 8:00 16:00 J SMITH 9/23 J SMITH 9/23
Is there any way that i can see this without manually entering the "Days Off" in the main table?
Trying to populate a listbox using a .txt file created used WORD. This is the code i'm using:
Private Sub cmdDisplayFile_Click() On Error GoTo text_open_error Dim sTemp As String Open "m:myaccessumber.txt" For Input As #1 Do While Not EOF(1) MsgBox ("in loop") Line Input #1, sTemp lstShowTextFile.AddItem sTemp Loop Close #1
I'm getting nothing in the ListBox. Any hints would be much appreciated. text_open_exit: Exit Sub
I need to find out how to populate a blank form with the results of a query i.e. by selecting an item in a combo box and populating the form with the results.
:confused: I recently added a find button, using the wizard in access, i am searching three feilds ( Id, Last name & first name) when i type in these feilds and want other info to populate on the same form. now i need to update the code, so that when i hit the find button it does populate. can anyone help
Thanks
PS the form is based on a table and not a query, I saw some info in the forum about using a combo :confused: box, but i don't want to do that.
On my form i have a list which takes information from a table. I have set column headers to "on". What i want to do is populate my combo box with the column heads in my list box. Anyone have any ideas?
If var1(x) = "" Then var2(y) = "" If var1(x) = "1" Then var2(y) = "Set" If var1(x) = "2" Then var2(y) = "Act" If var1(x) = "3" Then var2(y) = "Prod"
' this is where I am having trouble- var 4(w) holds the name of the text box that I wish to use on my form ' and var2(y) holds the data I wish to place in the text box ' so how can I tell the code that the data in var4(w) ,290 for example, is actually a textbox name instead of ' just a numeric variable??
Hi everyone. I'm new to database design and hoping htis is a simple question.
I have nine thousand products each with their own code and description. I want a form that allows me to enter a product code and will then self populate an adjoining box with the corresponding description. I would like to enter at least fifteen codes per form.
I tried a linked form and sub form with a child/parent link but the tables info can be changed if the form user edits/deletes etc a code.
I tried a parameter query but don't know how to do more than one and the format isn't really suitable.
Any suggestions would be very much appreciated. Thanks :confused:Sunstar :confused:
I have an expression in a field on a report. I would like that calculation to populate my table. Do I ad something to the expression in that field that would tell it to take the sum of the field and place it in the table? What would the expression look like?
The report is created from the results of a data entry form.
Private Sub text458_AferUpdate() If Graduation_date = 2/1/2005 Then
TEXT_GRADUATION_DATE = "DATED AT THE CITY OF NEW YORK THIS FIRST DAY OF FEBRUARY TWO THOUSAND FIVE."
End Sub
The Graduation_date is a combobox where the dates are selected. In a textbox titled "TEXT_GRADUATION_DATE", it should return "DATED AT THE CITY OF NEW YORK THIS FIRST DAY OF FEBRUARY TWO THOUSAND FIVE."
Can a form be directly Bound to a dao recordset? I read an article form microsoft showing it being done in ado by setting the recordset property of a form.
I'm attempting to reverse engineer a Cascading Combo Box database into a Fire Extinguisher Audit app.The Cascading Combo Boxes.zip file is found at URL....I've successfully created the tables and forms, along with the appropriate Event Procedures. I've duplicated the one query, but there is no data.Do I have to populate the query with data? If so, why aren't there dropdowns in each cell like the original query? I'm not seeing any other table that contains all the data that the query has.
I wasn't sure where I should have posted this question so please feel free to move it if necessary.
I am not even sure this is possible and I didn't know where to begin but these forums have always been extremely helpful.
What I would like to do is export data directly from Access (via form, table or query) and populate it directly to an existing, external webpage.
A little background. My company orders cars an for certain manufacturers, Toyota for example, we order via a secure website. All of the other manufacturers have their order directly transmitted to them. The orders for Toyota take 3-4 times longer to place and I was hoping to speed the process by exporting existing order information directly to the webpage.
Please let me know if it seems like I am smoking something and I will gladly step away from the pipe....=)
Is it possible to fill up multiple (say four or five) textfields from a combo box(or lookup) I looked in previous posts saw something about RecodSource, but couldnt figure it out?
I have a main form with project data and a sub form that has related financial information. Once the user selects a particular project from the ProjectType drop down box, a field called Project Codes in the subform should be populated with only project codes for that particular Project Type.
I have created a query from two tables. One table is Job information the other is job notes. How do i populate the query with the job # and job prefix from the job information table? I have the query(field) structure I want but its just gives me blank fields in the query form. How do I populate the fields with the info from the tables?