Search results

Thank you Jon K, this is what I needed. It's doing what I want now.

As an update, I've been messing around with the "And" operator. Under criteria I tried "[forms]![frmMyForm]![cboManufacturer] And [forms]![frmMyForm]![cboType]" but this isn't returning anything The format for the record is "Manufacurer Type". I've tried playing around with the spacing as well...

Hey guys, my problem is this: I want to run a query that runs off of two list boxes on a form. However, I want both these parameters to filter a single field in my query. Why I want to do this is I have several types of accessories made by several manufacturers, both included in the...

Hey guys, Ok, so here's my problem. I have a form which has several combo boxes. The user uses these to filter the information they need for a report. Each combo box relates to a different query and each query has a sub report. Now, on the first form there is a button to preview a report based...

Hey guys, When I try to open a report or a form in a database I've been working on for the past couple of days, a dialogue box pops up saying that I "do not have exclusive access to the database at this time". Does this mean that I can't access these form because someone else has the database...

thanks for the help ghudson, got it working beautifully

Hey guys, I figured out to maximize a window when a report is opened, but now I want to restore the window sizes when this report is closed. I think I kind of know what to do with the DoCmd.Restore and something about OnClose, but I'm lost in the syntax. If someone could help me out by giving...

Thanks for the tip. I know, I'm sorry for the double post, put my comp lagged when I tried to submit and created 2. Very frustrating working on dial-up.

Thank you neileg, it's working beautifully now. So simple, but things like that usually need someone else to look at. Thanks to everyone for your help.

I guess I should clarify what I mean by "empty report". What I mean is that the report follows the layout that I want, there's just no data under any of the headings. I'll attach a copy of what I have so far. It's a 2000 version

The data field type is number. It's still only opening up an empty report. Does it have to do maybe that the button only "previews" the report?

that's exactly what I want to do but it doesn't work. When I open the report on its own, not through the form, a dialogue box pops up prompting you to input Forms!frmInvoice!Control or whatever, and when I put in the ID i want, the report populates properly, but when done through the form, the...

Ok, I get what you mean now. Thanks for the help. There's another question I need an answer to, and it's posted in the other thread with the same name, my computer lagged while I was trying to make the thread and ended up making two, sorry :o

Ok cool, I got that now. What I would like to know next is how I would update that query while staying in the form so that when I open the report, it'll use the updated field entry from the list box. I think it would have to do with the BeforeUpdate event, but I'm not sure of the syntax

ok, I thought about it a bit. So then what that would do is it would input the value of the list into the SQL and use that as a filter?

how would that do what I want it to. Sorry, I'm really new to Access, only been working with it for a few days now

Sorry about the double thread posting, please look at the other thread with the same name. Thanks in advance for the help

Hey guys; What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report...

Sorry guys, posted this in the wrong forum, please ignore:o

Hey guys; What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report...