Hi everybody. I got a question. I'm trying to create a report in VBA. I want to determinate the fields, but the fields depend on a selection. If I have [C-NAME] and [C-FAX], I just want those two informations and nothing else.
Set myReport= Reports.Application.CreateReport(CurrentDb)
How can...
Hey guys!
I'm getting error 2501 when there's not data for a sql string. I try to put a message (MsgBox) and just put a end to the action "DoCmd.OpenReport", but I still get a message that tells me "error 2501". Well, thanks for your help.
Hi everybody! My problem is: I'm trying to put a var (who contains some values from a multi selected list) in a DoCmd.OpenReport. Please help me! Thanks!
Dim crit As String
If (crit <> "") Then
crit = crit & " AND [C16-VEND]= forms!Form1![myListBox]"
Else: crit...
Hi everybody!
Why does this line is ok
DoCmd.OpenReport "test1", acViewPreview, , "[C07-CODE]=forms!Formulaire1!criter_code.value"
And that this line makes a report with no data?
DoCmd.OpenReport "test1", acViewPreview, ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.