Recent content by HiTechCoach

Do you have the Form called "frmRecSelect" opened before trying your code? It would also help a lot to know what errors message you get.

When you send an email with the request for a read receipt, that is all it is, a request. The email recipient and their email client application are in total control of whether to send a read receipt back to the sender. It does not matter if you are using VBA, .NET, or any other programming...

I would create a function to send the email. Use parameters to pass all the requires info. Here is the code Access/VBA Tutorials - Outlook Send E-mail Without Security Warning (everythingaccess.com)

I use database properties to store info in both the front end and back end. Things like version numbers etc.

What version of Office 13 did you install? Was it Pro or Pro Plus? It sounds like you may have only the Access runtime versions.

It is very easy to add the code to send the PDF as an email attachment after the PDF is saved. I use the exact same code to send emails. I just left out that part to allow you to use whatever method you want to use to send the emails. I generally send directly via a SMTP server because it is...

You should never (the rare time never should be used) want to link Word mail merge to an Access database, epically if you have it opened. You are only asking for trouble. From: Page Title (kallal.ca) The Super Easy Mail Merge by Albert Kallal does exactly what you described as your needs...

This might help: RecordNavButtons (lebans.com)

I created this example that might help you get started. It creates a separate PDF for each customer. Batch Printing and Save As PDF

Great point plog. You will need to doing something other than preview each report.

Have you tried storing the rst!CustomerID in a TempVar? TempVars are great for passing criteria to a query. Do TempVars.Add "CustomerID, rst!CustomerID ' open report here rst.MoveNext Loop Until rst.EOF Else MsgBox "None"...

DB-noob, are you using a none ACE/JET (accdb/mdb)backend, like MS SQL Server, MySQL, etc)?

Sounds like the textbox control is not wide enough to display all the data as a barcode. . Try making the control's width larger. Can Grow will make the control taller, forcing the text to wrap to a second line. This will not work for the 3of9 (39) barcode because it must be on a single line.

If you will not need to add records on the form, I like to change the recordset type to a snapshot.

Microsoft Office is all about letting the end-user use the data however they need it. The great thing about building applications with Access is that it works so well with Excel. This allows users to pull the data to get exetly what they need. Do you know if the users will actually try to...