ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> Using a query as record source
http://www.istechforum.com/YaBB.pl?num=1350408105

Message started by heliosquare on 10/16/12 at 10:21:45

Title: Using a query as record source
Post by heliosquare on 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?

Title: Re: Using a query as record source
Post by Kelloggs on 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.

:P

Kelloggs

Title: Re: Using a query as record source
Post by heliosquare on 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.

Title: Re: Using a query as record source
Post by Kelloggs on 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.

:D

Kelloggs