Re: MS Access VBA Programming - Queries on the Run - Crystal Report

Hello All

I have a small problem with a MS Access developed in VBA.

The programme is developed as queries on the run using SQL.

I have a number of private forms which are bought together in a global form.

Every thing is OK if I generate a report with the complete database, but if I
select parts of the to selectively sorted database it is calling for
parameters, using the filter.

The code line on the global form with the following command appears as
follows:

Set rst = db.OpenRecordset(marSQL, dbOpenDynaset)

The set rst command shows rst = nothing and the dbOpenDynaset command = 2

These notations appears in the debug mode.

I was wondering if you could help me.

I have completed a number of these programmes in the past without any
problems but now this problem is coming to light.

Regards

Alan Dunn

.

Relevant Pages

  • RE: Delete still shows the deleted record
    ... Put this in the click event of your "DELETE" command button: ... Public Sub DelCurrentRec ... Set rst = Nothing ... On Error GoTo Err_Delete_Command_Click ...
    (microsoft.public.access.forms)
  • Re: 16 Bit Programme
    ... I HAVE IN THE PAST RUN THIS PROGRAMME ON MY ... Error message when you install or start an MS-DOS or 16-bit ... In the command prompt, type in the following two commands exactly as ... torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway ...
    (microsoft.public.windowsxp.general)
  • Re: .doc is not a valid Win32 application Help, help. help.
    ... PROGRAMME IN THE FILE ASSOCIATION LIST, EVEN IF I BROWSE AND MANUALLY ... DOS prompt) session and run the following command. ... If assoc doesn't show anything for the .doc extension, ...
    (microsoft.public.office.misc)
  • Re: whats wrong with this code from a book?
    ... > not even sure about the command when feeding it data. ... > so, all that in short, how do you think this programme is supposed to ... The declarations go *before* the first statement. ... int main ...
    (comp.lang.c)
  • RE: Delete still shows the deleted record
    ... Put this in the click event of your "DELETE" command button: ... Public Sub DelCurrentRec ... Set rst = Nothing ... On Error GoTo Err_Delete_Command_Click ...
    (microsoft.public.access.forms)