Search results for query: *

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 <> &quot;&quot;) Then crit = crit & &quot; AND [C16-VEND]= forms!Form1![myListBox]&quot; Else: crit...

Thanks Ben, Well the extra quote was a copy/paste error :( About the two fields, both are text values. What's wrong with this and how can I can expect to solve my problem? Thanks again.

Hi everybody! Why does this line is ok DoCmd.OpenReport &quot;test1&quot;, acViewPreview, , &quot;[C07-CODE]=forms!Formulaire1!criter_code.value&quot; And that this line makes a report with no data? DoCmd.OpenReport &quot;test1&quot;, acViewPreview, ...

Hi there, I wonder if someone can help me. I want to import a database from Linux to Microsoft ACCESS. Thanks for your answers, John.

Hi there, I have to import a database located on a Unix platform to Microsoft ACCESS. I'm searching how to do it. Thanks for answers :)