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 ????

HI there, sounds like the same problem Im having. I checked in Options, which autocorrect option do you mean? all three name autocorrects? (those are the only ones I can find)

This may not be the best way to get your sum, kind of a different approach. You could just delare variable global to the report, then keep adding the value from the detail section to the variable. at the report or detail footer, place the variable value to the textbox (or whatever) that the sum...

Yeah, that's what I figgured, thank's anyway

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.

As far as determining what the user wants, I can do that. (using radio buttons actually, I think that combo box may work better) How do I get that criteria string to transfer to the query as a criteria? (semi-new to runtime queries) if I point the query field to the unbound textbox, won't it...

Sounds like you have the basic set up so far. Form gets the info, calls query that runs using that info, which opens a report to display the gathered info. What it sounds like is your form is unloading before the query actually runs, which is why the query starts with...

Sounds like you have the basic set up so far. Form gets the info, calls query that runs using that info, which opens a report to display the gathered info. What it sounds like is your form is unloading before the query actually runs, which is why the query starts with...

Sounds like you have the basic set up so far. Form gets the info, calls query that runs using that info, which opens a report to display the gathered info. What it sounds like is your form is unloading before the query actually runs, which is why the query starts with...

Sounds like you have the basic set up so far. Form gets the info, calls query that runs using that info, which opens a report to display the gathered info. What it sounds like is your form is unloading before the query actually runs, which is why the query starts with...

As long as the record hasn't been saved yet, you can use the DoCmd.Close acForm, "formname", acSaveNo or use the acSavePrompt option to prompt the user to save yes/no/cancel

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...

Thanks, for the above info, helped me out as well. Further on that.. is there any way to have the first(or any) day selected when a new month or year is selected from the pulldown menu? or at least update the textbox when that happens?

another suggestion: in the ONCHANGE event of the areacode for instance, check if the len of the field is 3, then set focus to the next field. use different sizes for applicable fields

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...

little trick: create an unbound textbox (Tbox1) place it where the yes/no should go. Make the bound textbox visible=false. in the FORMAT event of DETAIL, enter code that will make Tbox1 = Yes if true or vice versa. the invisible control can still be referenced, but user sees the unbound Tbox1.