Search results

Hi Mr B, No, the check box doesn't represent a field in my database? Would it make it easier it did?

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...

Thanks alot. Thats exactly what I was looking for. Couldn't remember the name!

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?

Ahh yes! Thanks alot! Just a quick one. Can you remind me how to extract the year part of a date?

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...

Hi Guys, I managed to work this out in the end. The syntax was a bit dodgy. Thanks for the help.

Yeah, so I'm trying to find the email address for a particular record. The primary key for each of these records is the invoice number. Every record has an email address. Is something wrong with the syntax? Thanks again for your help.

I changed it too this: Dim CsAddress As String CsAddress = DLookup("[EmailAddress]", "tblSales", "[InvoiceNo]=" & Forms!frmSales!InvoiceNo) However, now I'm getting back this response... HT162 is the correct actually the correct invoice number... I'm not sure what the actual error means though

I fully understand you now however I'm having a few issues getting the code to work. I've tried Dim CSAddress As String CsAddress = DLookup("[EmailAddress]", "tblSales", "[InvoiceNo]" = Forms!frmSales!InvoiceNo) As soon as it runs the second line I get the following back : Run time...

Ok I'm with you so far, what I don't understand is how I could use the report as a source of your email code? When I look at the send object macro, it simply gives me an option to input an email address. There is no 'calculation' button for me to tell it where to find the email address? I hope...

I'm with you so far, and I've discovered this already. What want is for access to automatically send the report to the right person. So, If I'm looking at Mr Bloggs sale, and I press the button, I want access to produce the Mr Blogs Invoice and send it to Mr Blog Email address.

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...