Welcome, Guest. Please Login.
03/29/24 at 06:06:51
News:
Home Help Search Login


Pages: 1
Send Topic Print
Using a query as record source (Read 2421 times)
heliosquare
Full Member
***




Posts: 121
Gender: male
Using a query as record source
10/16/12 at 10:21:45
 
What I've done:
 
1) Created a new blank table in Access call SerialNumbers
 
2) Created a parameter query (invoice #) to pull invoice header and line item info from DBA.
 
 
What I want to do:
 
Update the table SerialNumbers with the results of the query.  I created a new form and set the query as the record source.  When I view the form and input the parameter, the results in the form fields are #Name?
 
Any suggestions as to what I'm doing wrong?
Back to top
 
 
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Using a query as record source
Reply #1 - 10/16/12 at 12:55:25
 
MS Access XP, or 2003
 
http://www.scorevalves.com/john/dba_serials.zip
 
hold the SHIFT KEY until the app is fully open
Click on Queries
Select DBA, click Design
Click on Query Properties
click one ODBC Connect Str
 
there you can connecte it to your own ODBC
save, save, save.
 
 Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
heliosquare
Full Member
***




Posts: 121
Gender: male
Re: Using a query as record source
Reply #2 - 10/19/12 at 12:50:09
 
Thanks for the reply but the link returns "file not found".  Perhaps I waited too long.  I solved my issue programmatically using VB, but I was initially looking for a way to do it without.  I'm an Access newbie so still have tons to learn.
Back to top
 
 
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Using a query as record source
Reply #3 - 10/20/12 at 08:47:16
 
http://www.scorevalves.com/john/dba_serial.zip
 
Sorry it was a typo.
I am glad that you figure it out on your own.
 
 Cheesy
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print