elaspina
Last Activity: Jul 28 '11, 10:09 PM
Joined: Oct 26 '09
Location:
-
This worked perfectly. Thanks a million! -
Can you elaborate on this? I'm a beginner when it comes to VBA. What is the parameter string?
thanks a bunch!Leave a comment:
-
Open form with 2 where clauses
I am trying to open a form based on 2 where clauses in a Human Resources database. I have a main form that has the employee name and type of benefit they are enrolled in. I want to then open a subform for the employee that then provides further detail on that particular benefit (i.e. I want to filter the form based on employee id and benefit type). When I only push one of the where clauses through the code it works fine, but when i try to combine... -
So question becomes: How do I get this autonumber to adjust each month if I have a static table? Currently I manually go through and change the invoice numbers by taking the last invoice number used the prior month and adding 1 to it and then type this sequentially all the way down my client list. Is there an update query I can run that can do this?Leave a comment:
-
+1 in each row of query
Hello
I am trying to write a query which will ultimately feed a report that will print out invoices for each of my clients. I currently have a query that pulls each client's name and amount due. I now need to add an invoice number. I want these to be sequential. Is there a way to get each row in the query to increase by 1? I know this is possible within the Report by using the Running Sum property, but I really need this is the...
No activity results to display
Leave a comment: