Search results

My report runs from a query. If the query comes up blank, how do I prevent the report from opening? right now my code Opens query Opens report. is there a command so I can Open query if query is not empty then Open report ????

is there any quick and easy way to make a control array in Access(2k)? I can do it manually in code, but I mean is there any easy way like in VB5 (and up)? just make multiple same-named controls.

I want to close a report if conditions occur at the DETAIL level. Access won't let me docmd.close while the report is still being generated. I have to wait until the entire report is finished to close. Any way around this? Calling the Report_close sub doesn't work either

What is the 'proper' way to delete a bunch of records, using a form? (and VB) Basicly go through all the records and if date = xxxx then delete record. The best way I have right now is running through all records with code, then using docmd.RunCommand.DeleteRecord. If there's a better...

Is it possible to use only one report, with one query to show all records with dates: ON a certain date AND/OR AFTER a certain date AND/OR BEFORE a certain date the report draws from query with recDATE as the field with criteria. can I change the recDATE criteria with VB code from a form when...