Search results for query: *

Oh yeah, i'm using Access 2000. I'm not too sure what version of the access runtimes the user is running.

Looks like it makes sense however I dont' think I have the correct reference libraries... Dim stDocName As String Dim qry As String Dim rst As New ADODB.Recordset Dim cnn As New ADODB.Connection MilestoneValue = cboMilestone.Value Set cnn =...

I understand what you're saying, i'm just not sure how to do that, or execute it in code... All of this needs to happen on a command button click. Could you elaborate a tad to help a newbie out? Thanks.

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

Bump - Anyone able to help?

heh, I implemented that actually, i'm just using this as a fallback method. The person using this database works in a seperate building and I can't get a hold of him right now to try it out, so I figure why not try this other method just in case... However your "cancel = true" did work...

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

Replacing "End" with "Exit Sub" worked great. But now on another set of code on a report: Private Sub Report_NoData(Cancel As Integer) MsgBox "Currently no status exist under that Milestone", vbOKOnly End End Sub Again, this code works fine for me, a form is run, data is selected, if data is...

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 such an idiot!!!!!!!!!!! I didn't see the "No record" event or whatever for the report.... Sorry!

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

Your code produces the same result. If I leave the field alone and select nothing at all I get the .(dot) error, but if I select an option from the field it works... So leaving it blank is the problem

I have a union query that displays the results fine in the combo box. SELECT TBL_Org.OrgNumber, TBL_Org.OrgName FROM TBL_Org UNION select 0, "All Orgs" from TBL_Org ORDER BY 2; and then to assign the value of the combo box to a variable I use OrgValue = Nz(cboOrg.Value, 0) It works if I...

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

Ok, now i'm using SELECT TBL_Org.OrgNumber, TBL_Org.OrgName FROM TBL_Org UNION select 0, "All Orgs" from TBL_Org ORDER BY 2; However it still blows up on me.... Although it does populate the drop-down with the correct values that I need. Just when I leave it blank, it gives the error, but...

Also, when I copy the value from that field i'm using: OrgValue = Nz(cboOrg.Value) and the error occurs on the right side of that line of code. I have about 3 other drop downs doing the same exact thing and they work fine, all except for this one. However if I select a value from the...

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

I had gotten the same result from another forum and it worked perfectly. Thanks

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

what I did was if chkFoo.value = true then list = "Product" end if etc etc... So my string is full of text values and not the values returned from the checkbox. So right now I have a completed string exactly how I need it to be, I just need to display it now However I work a 9 hour 4 day...