Search results

That is exactly my next challenge Jack, thanks. I'll see what I can do! :)

Well good for me! :) I fixed the syntax for the file. I changed it to: "([Status].TOpCl)" and the error went away! But, this also confirmed to me that the "ElseIf" is an "or" statement. I need these conditions to be "and".....

Hmmm... It would seem that the "ElseIf" statement makes the two conditions "or"s rather than "ands". Is that correct? If so, then I need them to be "ands". I noticed this because when I enter a BA, the report runs but doesn't seem to consider the "Status" criteria. This is also evidenced...

Thanks Jack & David. It now runs without error! :) But.... it doesn't return what I'm hoping it would, so I think I've got to look at how the tables are related. Thanks again.

Jack, that article link is br0ked. Its give a "can't find" error and this is in the address line: http://query%20by%20form/ Anyway, I tried to change it to what you suggested: -------- Private Sub RunReport_Click() On Error GoTo Err_RunReport_Click Dim stDocName As String...

Jack, something w/ that link is goofed up. I click it/cutpaste it, whatever and I get a "cannot find" error.

Cool! Helpful. I'm sure this is what I need, but I'm getting some errors no doubt from syntax. Bold is the code I added ------ Private Sub RunReport_Click() On Error GoTo Err_RunReport_Click Dim stDocName As String, stDocWhere As String stDocName = "RISIF" If...

This question picks up where this one left off. I have a form, FISReports, this form calls a report, RISIF. RISIF uses a query, QISIFReport, as its record source. On FISReports, there are 3 pieces of criteria: 1. To and From dates (to unbound boxes) 2. BA (unbound combo box, this is a list...

Ah, that makes much better sense. :) Unfortunately, I'm still somewhat of a n00b user, so my voodoo isn't too good yet. But, I'll do what I can. I'm sure one of the seasoned access vets can help you out. Their voodoo has much more power than mine. Anyway, here's my "stab" at your problem...

*notes "subreport"* *runs off to investigate* I'll see what that yields. Tx Rich! :)

I've done that. I've added a footer for Task, for the Employee, even both at the same time. Its like that feature (count) is reserved strictly for detail information.

I'm a little confused. Please more precisely explain things. Or, better yet, let me see if I understand what you're trying to do. Form 1, click a button: Equip? This runs a query that brings up a 2nd form that is a list of all Equipment referenced by ID? Right? Does the criteria for the...

Sorry I didn't reply sooner, Rich. I got caught up in some of my forms and let this go for a bit. Now, my forms are in pretty good shape and I'm revisiting these report issues. The report I'm trying to get this sum for has 2 headers and a detail. I made it with the report wizard and I wanted...

FYI, I'm re-working it. :) I'm gonna just have to buttons, each calling a specific form. One of the forms called has a query as its record. That's working fine. :) It does have a criteria choice of "BA" (employee), so you have on the main form, 2 buttons. You select the BA you want and...

Yes, thank you both. LOL, so much so that I think I have those hominy grits on my face. :) David, I've already printed your information out and have it taped up next to my monitor. The problem is I wasn't explaining the problem thoroughly. Sorry for that. Here goes... And I'll substitute...

lol, I'm sure you're right. Honestly, I think I've gotten a bit too ambitious w/ this thing. So, Cogent, have Form1 call Form2, but in the "OnOpen", have Form2 run the query? You probably want to kick me in the teeth for not quite getting what you are saying... :( But I'm trying and I'm...

OK, this is where my abject lack of coding skills and my only recently acquired extremely fundamental understanding of SQL are making me pay dearly! :) Cogent1, you're saying to go to the properties of the form I want to call and then list the query as the record source? I don't think that...

Travis, thanks! That worked like a charm. Kingsburg? Down by Fresno, yes? I do have another "criteria" to add to this mix. I thought I'd described it in the original problem, but I realize after this worked so well, that I left this out... :( However, I'll try and see if I can learn from...

Is it possible to have a query call a form as output? NOT create a form, but SELECT a form that already exists and populate it with data predicated from the WHERE clause? Basically, I'm trying to work around some of the limitations of the command button wizard that only let me whittle down my...

I don't see the "next record" button on the .gif you provided, but in the form properties under data, look for some criteria, like allow additions, allow edits, allow deletions... These should be checked "yes". They generally are by default, so I doubt that's your problem. If they are checked...