Recent content by JCross

go Orygun!

Well, I need to retrieve a list of dates where the criteria is >= a field on a form. Then I retrieve the Inventory Details for each date, and for each detail I need to update the Cost field to either 1) the cost the last time the item was delivered OR 2) if the item was not...

Argh! I've made a million different queries, and i had NO IDEA about subqueries. thank you so much! ok - tried it but i need to use the recordset to bring back a list of dates, and then loop through the dates one by one in the criteria..... J

Hi All! I am stuck and I posted something about this before, but then I went back and reread it and it didn't make much sense........so here goes. in a nutshell, can you use a recordset, created in a module, as criteria for a query? I have one query that brings up a list of dates, and then I...

Hi! I have a recordset based on a query that is getting a 'too few parameters ' error. I think it is because I have a form referenced in the query that I need to set the value of? Is this right? I checked the KB article, but didn't quite understand it.. Thank you! jennifer

Hi Wayne! what it the hth that everyone signs out with? thanks for the code, i'm going to give it a try! Jennifer

I've been trying to work this one out myself, and I just figured out that you have to .movelast before you recordcount to find out how many records you have! I really need some help, though - because I have to nest my loops and I just can't figure it out. 1) click event on a form button - got...

Thank you John!

Thank you, Peter. I also e-mailed you .....if you get a sec. I really appreciate the help. Jen

How and where do I go about replaceing the filecopy statement with the code in the KB? J

I looked into the maco, and I don't think that will work for me. What I am really interested in is the Winzip route.........will this work with the runtime i am distributing? Can you tell me more about how to implement it? I've downloaded the command line ad on.........now what? Thank you for...

I'm an ass. I'm so sorry. I was looking at the picture for "Option Group" and thinking that it LOOKS like a frame, so i typed frame. But it's the Option Group that you want to use. apologies J

Nope - in design view you have your toolbox with all of the things you can put on a form.........and one of them is a frame. Have the wizard icon clicked( the magic wand) and put a frame on your form. the wizard will open and run you though all of your options for the form. one of the last will...

If you use the frame wizard, then you can assign any value you want to the checkboxes in the frame. Jennifer

Hi! I am packaging and deploying my DB, and my boss wants to start thinking about how people (we're sending it out all over the country) can backup their runtime versions of the DB so that they can restore from it if they screw up their DB. Is this possible? Thank you! Jennifer