Search results for query: *

The problem I am having is when I execute a report with no data, I get a blank report. So i implemented on the "no data event" on the report a message box and then a process to kill the action and return to the form. This works flawlessly on my developer edition but when it is actually run on...

The problem I am having is when I execute a report with no data, I get a blank report. So i implemented on the "no data event" on the report a message box and then a process to kill the action and return to the form. This works flawlessly on my developer edition but when it is actually run on...

I have a form with a bunch of checkboxes, to procede to the next form you need at least 1 of them to be checked. So I run a if statement on each checkbox and end up with: If AreBlank = True Then MsgBox "You must select at least 1 Product", vbOKOnly, "Error" End End If This works fine for me...

I'm executing a report via another form, passing it a variable. Based on the variable it spits out a report. However, is the report is empty and no records are returned, how do I make a message box to say "Sorry, no records available"? Seems like it should be pretty easy... but i'm stumped...

I have a combo box that I want to populate data with from a table. I'm using this form as criteria for a report. So if the table contains "Option A and Option B" they can select either and get reports dealing with either option A or option B. However I would like a "Both options" selection in...

I have a form with a bunch of fields, you can select various drop downs and such and hit submit and it'll print a form using what you selected as the criteria. Well there is one field that keeps "exploding" and it gives the error described in the topic. It's a drop down using the following for...

Currently I have a form. From it I am passing values to a report to generate a SQL qry which I then execute using Me.Recordsource = Foo Within the report code I am also putting together a string based on the criteria of the form i'm launching the report with. The variable is of type string...

I have a form with a bunch of check boxes. Each check box is a certain criteria for a report, the user checks however many boxes they want and when they hit a comomand button it executes a report based on the criteria they selected. However at the top of that report I would like to display the...

Sorry this is my second post, I hope to make it clearer and to find a answer :( Using the following line GenerationDateValue = Nz(Generation_Date.Value, 0) If Generation_Date.Value contains nothing at all then the value of GenerationDateValue becomes "12:00:00 AM" Therefore later on in my...

I have a simple variable defined as date: Public GenerationDateValue As Date I assign data to it using: GenerationDateValue = Nz(Generation_Date.Value) However in the following code whe executed it puts in: 12:00:00 AM for its value in it making it seem as if there is data in there even when I...

I have a simple form to show a report and the records it shows are based off of the standard "due today", "5 days late", "10 days late" and "More than 15 days late" Is my code correct for filtering the SQL? I recall having to surround the dates with # but will this suffice? If...

Using a simple Dim foo as Database is for some reason returning the following error: User defined type not defined it however was working, what would trigger such an error? Thanks

(Cross posted in Report forum, sorry, just now realized its a query issue, I think) I was asked to fix up a report that stopped working. Well I fired it up and instanty get a error box saying "Too many crosstab column headers (269)" I hit ok and then get the same message but with (290) in...

I was asked to fix up a report that stopped working. Well I fired it up and instanty get a error box saying "Too many crosstab column headers (269)" I hit ok and then get the same message but with (290) in parens. Where should be I begin looking to fix this error? Like I said, i'm unfamiliar...

My code was working fine, I made a few changes to a report, but didn't touch this form but now all of a sudden I get that error on the following line: StatusValue = Nz(Status_Code.Value) It was working flawlessly before, what could have triggered it?

I'm trying to pull in data for a report by using a form, then passing values from that form to the report and using a Me.RecordSource to display the report. The value passes to the report fine and I can hold my mouse over it and see it's value. The following line screws up and gives me the...

I've got a form with a bunch of fields, when a command button is pushed i'm assigning those fields to a bunch of variables which will then get passed as criteria for a report. However I'd like to have it so not all fields need information, whichever fields have data in them will be the only...

I have a form full of controls that will be used to trigger a report and based on the information on the form will determine which records show up on the report. ex) type in the date due and reports with that due date show up, simple stuff =) Anyway, 3 of my search criterias are text boxes that...

How do I go about creating Aliases to shorten the length of stuff in a SQL query? Thanks

This ties in with my other problem. Here we go. I'm generating code for a report and storing it in one long string, conatanating each line with the next. Most of it is just a SQL query taken straight from the qry editor, the other stuff is parsing data from passed information from another...