-
hi guys, can i get a little help.
i'm making a quotation program for a friend.
got almost all working. except the actual printing of the quote!
reports come from access and print readily.
quotes are stored in an access 97 db.
have made a form with a sub-form for each individual quote.
but heres the prob.
I CANNOT GET THESE TO PRINT THE SELECT QUOTE.
i've tried to send a paramemter/variable to
appAccess.DoCmd.OpenForm "CustomerQuote", acNormal, , "Select QuoteId Where !QuoteId = lblquoteid", , acDialog
i've also tried crystal reports (the version on the VB6 cd)
got the design but wont print from vb6.
-
Have a look at the thread already running on this forum - 'creating access report from ADO recordset'
-
Your condition in the OpenForm action is the wrong format. It needs to be a WHERE clause without the preceding 'WHERE'
Hence,
appAccess.DoCmd.OpenForm "CustomerQuote", acNormal, , "QuoteId = '" & lblquoteid, , acDialog
Don't use !QuoteID.
This will act as a filter on the underlying recordset.
Cheers,
P.
-
still probs
still wont function
get the following error message
'2046' the action or command 'openform' is unavailble
