Search results

Hi All, I've got a theoretical problem I'm hoping you can help with. see the image below. It's one of my forms. The form basically holds info concerning the products (and customers they belong to) that are coming in on each shipment. I want to be able to send an email to all these...

Hi There, I need to get visual basic to find the record with the most recent date and give me the value of the date. Can someone give me an idea as to what the coding would be. Would I need to use a DLookup statement?

Hi Guys, I set up a sales system back in September for our business. We sell hot tubs. The database incoporates all sales info, we then use the info to generate invoices, delivery manifest etc. We also use the database to produce reports and graphs of sales. It will show me a graph of the last...

I have a table that holds sales info. I have a select query that gather the relevant sales info for a particular sale and then uses that info to produce a report in the form of an invoice. So for example, access will ask me to enter the invoice number and will then produce an invoice for the...

Hi Guys, I'm very new to Visual Basic so you'll have to bare with me. I've got some great big books that I've brought but I'm not even sure where to start. I did a bit of visual basic programming back when I was in college however I need my mind to be refreshed a little, I can't remember a...

Hi There, I'm creating a sales system for my business. I've been doing pretty well so far however I need some assistance. I have two tables. Table 1: Includes details on my budgets for a particular product. Table 2: Includes sums of my weekly sales, and also what the weekly budgets should...