Search results

Rather than use a bunch of combo boxes on your search form, why not use checkboxes there as well? I think it will be more intuitive for your users and simpler to reference in your query. ~Abby [This message has been edited by Abby N (edited 08-23-2001).]

This is a more difficult problem than it appears at first glance. I played around with a few different ideas and here's my best advice. (Apart from, get out of politics; it’ll suck the life out of you. *wink*) First, you can get rid of the county table. As you already have the counties in the...

Doh! I just thought of a better way of doing this. Forget everything I said in my last post. I'm leaving it up in case this doesn't work for some reason. But, there should be no need for a second form. Code your original form's On Error property with: If DataErr = 7971 Then Response = 0 and...

Ok. I replicated your error and found a solution! (When something like this comes up it drives me nuts, like an itch on the back of my eyes. So, I’m rather happy to have solved it. Or at least to have found an acceptable workaround.) Here is what I did. First, I created a new form and coded its...

Could also be the problem you're encountering is caused by the single quotes in the criteria you're sending. When comparing numbers instead of text you don't use them. This may do it. stLinkCriteria = "[IDNUMBER]=" & Me![IDNUMBER] Good Luck ~Abby [This message has been edited by Abby N...

Is the field's Data Type defined as a 'Number' or as 'Currency' in your table? If it's 'Number' is the Field Size some type of integer? ~Abby

What I've done in situations like this is create a table containing one field. That field lists each of the items I wish to include in my report, in this case each month. For the purpose of this discussion I'll refer to that table as tblMonths and your source table as tblData. Include tblMonths...

I'm no closer to figuring out why you're getting the error and I'm not. Your probably right about it being some simple setting. But I can't seem to find it. What version of Access are you using? I'll keep working on this. In the mean time, here's a link to an API that claims it will change the...

All you need is to enclose the variable in single quotes when you set the field's default value. Mailing.DefaultValue = "'" & strMlgCde & "'" ~Abby

I don't see anything that sets the value for your variable ctr. Try adding this line somwhere before your ReDim statement: ctr = Me.Controls.Count ~Abby

Looks like it’s a big day for Domain Aggregate functions. (Most of my suggestions today have used them. Which is noteworthy only because of how much I dislike them.) Anyway, give this a try. =[Agent] & " is responsible for " & DCount("[ID]", "YourSourceTable", "([Status]= ‘Active’ and [Agent]...

Ah. Now I see. Though I'm not sure why you're getting that error message. As a test I created a report based on a query that returns no data. I coded the reports No Data event with the following: Cancel = True MsgBox "No data is available." I then created a label on a form with its Hyperlink...

Opps again! <<5.73 MB of vulgarities deleted>> This is what I get for cutting back on caffeine. Here you go. I assure you this will work. (The old one would have if [Job ref] were a number instead of text.) DMax("[Schedule ref]","Schedule Date","[Job ref] = '" & [Job ref] & "'") Alternatively...

What attributes are you looking for?

Opps! It makes perfect sense. I missread what field you wanted the max of in your original post. This criteria in the [Scedule ref] field should do it. DMax("[Scedule ref]","Schedule Date","[Job ref] = " & [Job ref]) Sorry about that. ~Abby

Just place a set of quotation marks ("") in the labels Hyperlink Address properly. You may also want to code it's On Click property with: DoCmd.ShowToolbar "Web", acToolbarNo to prevent the web toolbar from opening when the label is clicked. Good enough? ~Abby

You can use the ampersand (&) to join text strings together. A typical example is: “Hello “ & “World” is equivalent to “Hello World” So, if this is a subroutine in a form and [modulename] and [coursename] are fields on that form whose values you want to use in your message box, you could do it...

Assuming the [Job ref] field is a number field and indicates the group from which you want to get the latest date, this criteria on your [Schedule date] field should do it. DMax("[Scedule date]","YourTableName","[Job ref] = " & [Job ref]) If my assumptions are incorrect please correct me and...

I assume that [FN1] and [FN2] are text fields, yes? If not this may need to be altered. SELECT Nz([FN1],"") & " " & Nz([FN2],"") AS Expr1 FROM centres AS centname;

Exactly. Once you create the function you can use it the same way you would any other function, as a control's source (with the = in front), in subroutines, in query calculations, ect... ~Abby