Query Not Populating
Mar 21, 2014
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.
View Replies
ADVERTISEMENT
Oct 26, 2004
I’m looking for a formula that will take the last two digits of a “Code”, in Query, and search for the “Range”, in a Table. (Sometimes the “Range” may only have one code in it.) The value returned should of another column. (“Desc”.)
The formula should look at “Code: 123456”, in the Query, take the last to digits in the code “56” and find it in the “Range”, in the Table, returning a value of Supplies.
Query 1: Code: 123456
Table 1:
Code-------Range-------Desc.
10 ----------10------------Direct
20---------20-29--------Indirect
50---------50-59-------Supplies
Any help or guidance would be greatly appreciated.
View 11 Replies
View Related
Oct 17, 2006
I have got 2 tables:
TAT table with fields: ID, SPB, SET, DAYSIN, HRSIN
SETS table with fields: ID, SPB, SET, DAYSIN, HRSIN, plus a few other fields.
Is it possible to do the following:
If (SPB.TAT = SPB.SETS) AND (SET.TAT = SET.SETS)
then store
(DAYSIN.TAT in DAYSIN.SETS) AND (HRSIN.TAT in HRSIN.SETS)
Thanks for any help with this.
View 4 Replies
View Related
Oct 18, 2014
I am trying to populate a combo box (cboVenderID) with one of the two queries below.
But "Set rs = db.OpenRecordset(strSQL)" causes a Run-time Error '3016': To few parameters. Expected 1.
I am quite new to VBA and SQL.
Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim intVenNum As Integer
intVenNum = Me.cboVenderTypeID
[code]....
View 4 Replies
View Related
Oct 15, 2014
I am using the query below
What I am trying to do is get 4 combinations
1) Department + source of Tag+ specific Date
2) Department + Specific Date
3) Source of Tag + Specific Date
4) All records
This query is meeting my 2nd and 3rd condition however if I delete the parameters for 2nd and 3rd 1st combination works fine. But I want all four conditions met in one query
SELECT [Unsafe Act Unsafe Condition].*, [Unsafe Act Unsafe Condition].Department,
[Unsafe Act Unsafe Condition].Date, [Unsafe Act Unsafe Condition].[Source Of Tag],
[Unsafe Act Unsafe Condition].[Close Date]
FROM [Unsafe Act Unsafe Condition]
WHERE ((([Unsafe Act Unsafe Condition].Department)=[Forms]![frmHighLevelReport]![cboDepartment])
[Code] .....
View 5 Replies
View Related
May 29, 2014
I have an insert query that has been working just fine. I added three new columns (Paid, Balance, Invoiced) to both tables that I am using in my query. The query will insert the new records that don't exist in the one table just fine but it is not populating the new columns.
' Append records from aud_ck_reg (local table) to dbo_aud_ck_reg (table on server)
DoCmd.RunSQL "INSERT INTO dbo_aud_ck_reg ( audType, audDate, audUser, transid, customer_number_parent, transdate, create_1131, check_number, check_date, PW_voucher_date, " & _
"voucher_date, voucher_number, customer_number, credit, debit, fiscal_yr, month_number, calendar_month, calendar_year, calculated_cost, notes, CIT_number, Quarter, Hyperlink, Paid, Balance, Invoiced)" & _
"SELECT aud_ck_reg.audType, aud_ck_reg.audDate, aud_ck_reg.audUser, aud_ck_reg.transid,
[Code] .....
View 4 Replies
View Related
May 20, 2015
I have a Pupils database where I have a form with Pupil name and ID.I have a query with a calculated field and the ID and this works great.
I can display the associated calc on the form using a sub-form (I link the ID in the calc to the ID on the form) but I dont know how to get this value to display in a listbox.
View 14 Replies
View Related
Feb 27, 2015
What I am trying to do is populate the specific fields on excel sheet based on access query. so say I have 3 separate fields Name, Job, Salary on excel sheet (already designed excel sheet). and my access query has all 3 fields pulled up for all employees. Now if a person selects his "Name" on access form person should be able to see prepopulated excel sheet with his name, job and salary. I know I have to go recordset path.
View 1 Replies
View Related
Feb 20, 2006
Hi all,
I have a query which populates a form called EditPatientFrm, which asks the user to enter the patient UniqueID in order to pull up the record they want to edit from the TblPatient. However, I want the user to now be able to input just one of three criteria in order to pull up the record to be edited:
UniqueID
ChartNumber
PatientLastName and PatientFirstName (two fields)
since they may not have the UniqueID readily available to them.
Can anyone show me how to do this? I have tried to find answer to this one under queries and forms- no avail. Sure it's a simple thing...
thanks!
vrpres
View 1 Replies
View Related
Dec 23, 2014
I'm populating an unbound ComboBox with a Query via the QueryDesigner. The value of the Rowsource depends on the value of another ComboBox at the main Form.
After several hours of trial and error, I came to the solution showed at the attached image ("works"); my concern is.. why does my first approach does not work via the IIF clause? ("not work")...
View 2 Replies
View Related
Sep 29, 2011
I currently have a combo box (combo121) on a form. I select the "Company" which is connected to "Company" in the query via [Forms]![courseinfo].[combo121]..That is working. When I press the "query" button on the form the selected company in the combo box is updated in the query and it updates the report templates.I also want to use the same system to populate a different report, using the same query. This works a bit differently.
Once the company is selected in the first combo box(combo121). I have other combo boxes which bring up students attached to that company. I have multiple combo boxes because I need select multiple students for the one report. These students are in fields "First Name" and "Last Name". So in the query I can only have those fields once. I have several links to the several combo boxes under "Last Name" as that is the "bound" selection for the combo box:
[Forms]![courseinfo].[comboname1]
[Forms]![courseinfo].[comboname2]
[Forms]![courseinfo].[comboname3]
Problem I am finding is this is bringing up several lines in the query. So when I try to populate the report with all of the different Students I have selected for the query, it won't work properly because I can only put "First Name" & 'Last Name" fields on the report once.
View 4 Replies
View Related
Aug 3, 2015
I have a report based on a query. I want to populate 6 Text Boxes with Dates from fields in another query. The date fields I want to add will be headings for columns that represent weeks (they change all the time so can�t be hard figures). The two queries are not really related by any common field. I am not able to get this working because the fields I want are not part of the query that is the Record Source for the Report.
Is there any way that I can do this? Can I change the record source of just the text boxes?
View 5 Replies
View Related
Jun 20, 2006
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:
View 1 Replies
View Related
Mar 12, 2008
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.
View 1 Replies
View Related
Jan 26, 2005
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.
Need help urgently. Thanks in advance :)
View 1 Replies
View Related
Sep 19, 2006
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?
View 2 Replies
View Related
Feb 11, 2005
Hi,
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
text_open_error:
MsgBox Err.Description
Resume text_open_exit
View 2 Replies
View Related
Jun 5, 2005
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.
Thanks,
VAA
View 2 Replies
View Related
Jul 14, 2005
: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.
View 2 Replies
View Related
Nov 23, 2005
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?
Cheers,
Matt
View 1 Replies
View Related
Mar 30, 2006
Hi guys ( and girls)
Ok so Im a noob but I have a problem with populating textboxes
This is basicly the code
' dim some variables
Dim var1(10)
Dim var2(10)
Dim var3(10)
Dim var4(1000)
w = 290
y = 0
For x = 1 To 10
y = y + 1
w = w + 1
var3(x) = y
' set focus and get some data
Set ctl = Combo277
var0 = IIf(Nz(ctl.Value) = "", "", [Combo277])
var1(x) = DLookup(var3(x), "variable type", "[machine] = [machine]")
' compair the data and do some more stuff
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??
var4(w) = var2(y)
Next x
So any help would be excepted with blind thankx
Tankx in advance Chris
View 1 Replies
View Related
Jun 21, 2006
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:
View 3 Replies
View Related
Feb 11, 2005
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.
View 1 Replies
View Related
Mar 16, 2005
Dear All:
Code:
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."
This text box is blank.
Any ideas on how to fix this?
Many thanks in advance,
Dion
View 5 Replies
View Related
Mar 29, 2005
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.
View 4 Replies
View Related
May 24, 2005
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....=)
Thanks in advance,
Brian
View 4 Replies
View Related
