yeske03
Last Activity: Jan 26 '11, 08:26 PM
Joined: Feb 12 '09
Location:
-
Nevermind on the last post. I moved my DoCmd.Quit up a few lines and works perfectly now. Thanks for the help ADezzi. -
Thanks, that works great now. Is there a way I can add that code to the command button I have to close the application, so that it will email the file and close when finished?Leave a comment:
-
How to send email to predetermined address in Access?
I've created a form for use by our employees. I have it simple as possible with a New Record, Save Record, and Email command buttons.
The email command is set up to mail a specific query that I have created. Everything works properly, but when you click to email a command pops up to select my format, and then opens microsoft office to have me type in the email addresses.
...Code:Private Sub MAIL_Click() On Error GoTo Err_MAIL_Click
Last edited by Niheel; Jan 26 '11, 08:05 PM. -
How to automate a query and send it via email at a regular time?
It's been a few years since I've built anything in Access 03, so I'm a little rusty.
I've built a simple database to be used by employees and what I'm looking to do is make it as idiot proof as possible. The basic thought behind building this is to replace the need for hand written purchase orders and move everything to computers.
I've made a query that shows all transactions they've made during the day. Now what... -
Actually, I accidentally right clicked on the column and hit the Sigma sign that said totals. After doing that, I looked at the query and datasheet view and did exactly what I wanted it to do. Thanks for the advice though. I'm sure it will come in handy down the road.Leave a comment:
-
sum query
I have a query built that shows my products, whether the product was put into inventory or sold, the quantity of the transaction, and an expression built that will make the quantity become negative for the sales transactions.
What I am having trouble with now is creating a new query or report that will sum my transactions.
For example: I purchesed 6 of product A and 4 of Product B and have only sold one of each. I want... -
Sum Query
I have a query built that shows my products, whether the product was put into inventory or sold, the quantity of the transaction, and an expression built that will make the quantity become negative for the sales transactions.
What I am having trouble with now is creating a new query or report that will sum my transactions.
For example: I purchesed 6 of product A and 4 of Product B and have only sold one of each. ... -
Thank you very much, works perfectly.Leave a comment:
-
combo box not updating
I'm currently using Access 2003 to create a simple form. I am using two tables of information to go into this form.
One table I named "Categories " with fields of "CategoryID " and "CategoryNa me"
The other table is "Products" with fields of "ProductNam e", "ProductID" , and "CategoryID ". I have a relationship between the two so each product is in one of the...
No activity results to display
Leave a comment: