Search results

WOW. That was beautiful. Worked like a charm, thank you so much. :D

sorry to be redundant, but I still don't know where to place the requery command. The parameters are on the main form, and the info comes up in the sub-form. I haven't been able to requery the subform on an event in any of the main form fields. I have tried placing in all sorts of events on...

This probably sounds dumb, but I cannot figure out how to up date the form after I have entered parameters, except by opening it up with a command button.

Hi everyone. This probably sounds simple, but I cannot find the answer here, google, or my books (don't know if I'm searching the right words). I have a main form with five parmeter values, any of these acn be filled in, to filter the results in a query. I created a subform to display these...

Thanks. :D

Thanks Wayne. :D After a good deal of trial and error, I figured it out :D . I got rid of the "*" and inserted a command to accept null values. This is what I ended up with for anyone wonding how to do it Disclaimer: theres a good chance this isn't the best or easiest way, but it worked for...

I actually want the query to return only one result, but even when I enter everything for the query that matches one specific result, it still comes up blank.

I do not know if I'm shooting for the moon here (I haven't seen anything like this yet). I have a database that keeps track of different flights for screw conveyors. The part number on these flights are based on many fields in the database, with a couple characters that aren't. I am trying to...

Thank you Len for your advice:). I thought it may have had something to do with null values. I actually tried to get the query to ignore if nul by using "*", something I read on one of the forums. Does anyone know of a way to ignore parameters if they are left null. I would much rather have...

I am trying to strengthen an already developed database at my work. They had a form with five different text boxes, each one that would run a seperate query on the same table, and the results would open on a different page. I am trying to combine all these text search parameters from the form...

:D Well, after a long night and an early morning, I figured it out from much trial and error. I just created another database with only the add entry form, and linked the tables back to the main database. It seems to work great, hopefully it stays that way.

I am still new to Access and am loving the learning process. I am stuck on a problem though. I have serached the forums here and various other places and haven't found the info I am looking for. I was wondering if there is a way to have a relpica (or a seperate database that can syncronize)...

I ended up going a different route with it, but thank you for the relpy

Yep, it works perfectly now. Thank you again.

I was refering to ReportFilter1, but I looked at it closer and the problem is that the different criteria expand the search rather then limit it. Example if I enter an order ID and a Part number I get every record of that Order ID along with every record with that Part number. I would like it...

sorry to bug you again, but getting into, I had one more question. Is there a way of making it possible to use more than one search criteria? The way it stands now, If lets say orderID is entered, then anything else is ignored. If not I think I could make do.

Thank you so much. It works great, and I was able to see how it was set-up which helped me learn a little too. Thanks agian.

OK, here it is. The info on it is all made up as I am trying to develop the DB. I probably explained this thing completely wrong, thank you for your help.

Sorry, the "Report Filter" is essentially supposed to run the report, however the set-up is in a way that a user clicks on the report to open it up, and the "Report Filter" pops up as a dialog box to enter the criteria for the report. I hope this makes sense I am bassically trying to provide...

The "Report Filter" opens when I open the report, but opens blank. The "OrderId" control does have entries in it (all seven digit numbers). your right about the space thing, its already caused me some confusion.