Recent content by irishblue

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