Search results

Ok I have a macro in access 2000 that runs a query and then outputs the data to an excell spreadsheet. I have a macro set up in excell that will process the data and get it ready to send back to access via import queries (needed an running sum in a query couldn't figure any other way to do it...

aarg, I can't seem to put this into the right words. I want to run an inventory report that will look at a table that has the product received, the volume recieved, the invoice # that the volume was billed on, and the date that we received the volume. Here is the trick and what I am having a...

Is it possible to copy the value of a control to clipboard and then paste it into another control using vba? What I am trying to do is create a "calendar on double click". I am using the activeX calendar. In the date field on my form I have the double click set up to bring up a popup of the...

I am trying to create a button that will check all "checkBox"s on a sub form. I have created a form that has a subform on it, in the subform are checkboxes, the checkboxes are tied to a true/false field in a table. I have the button on the main form. This code may be way off, I am a huge...

This is giving me a syntax error of "Missing Operand" I have tryed putting an = sign inside the ( out side the ( removing the outer() and using a varible all come back with various syntax errors. this is on an access report <code> Private Sub Report_Activate() Do Until (DSum("Gallons...

Hi, I have a small problem. I am trying to create a gain/loss report for my office and I need to create a loop code that will pull the most recent inventory up to a certin volume. We receive several shipments per month. The report needs to pull the most recent shipments untill it can't pull any...

I need to write a loop code in a reprot that will apply a payment in acending order by date and bring back the invoices that the payment will be applied to. I have a query that sorts open invoices by date in acending order. I don't want it applied I just want to see what invoices can be paid...