Search results

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

Hi! I havea button to print out a report... Reports!rptSalesMix.OrderBy = "[PLUNumber] ASC" DoCmd.OpenReport stDocName, acNormal and when you click it it opens the report in design view before printing it. How can I stop it frlom doing this? Thank you! Jennifer

HAH! That sounds a hell of a lot more tempting than chsing code around...............I think i'll do it! Jennifer

I really have no other way to describe it - if i click. ..too fast? not hard enough? that's when it closes the form without running any of my queries. I'll do a really close check on my code to see what's going on, but when I tried to step through before, of course it performs everything just...

When I click Build Event for the button, it just takes me to the code I've already written. i only have an On Click event.......... I know it sounds ridiculous, and it is a good chunk of code, but nothing complicated. It validates the form, then runs some queries and closes the form - updating a...

Hi! I have a button on a form that runs through some queries before closing the form. Weird thing is, you have to click the button..hard? to make the queries run? SOmetimes if you click quickly it just closes the form, and then if you go back and click hard it runs the queries and then closes...