Search results

I need to keep an audit of records deleted in a table. I would like to make use of Access 2010 Data Access Macros for this! In the table tblProduct I have a field ProductId Users need to log onto use the database so I know the user ID and would like to keep this in the audit. How do I...

I have found users "cheating the system" by adding and then deleting records at form level! What is the best method to create an audit of records added / deleted at form level? The forms Record Selector is set to yes, so the user can select multiple records for deletion Each user has a login...

Found the problem! I use a string called Wclause in which I build the filter criteria. I declared it as Public Wclause as String I repeated in the print module as Dim Wclause as String Thanks so much for your efforts.

Many thanks for the explanations. As mentioned, the recordsouce of the report is a query built into the report. How could I apply the filter using a querydef? The query is fairly complicated so I don't want to create it in code! Failing which I will consider one of the following: * creating the...

Opening the report with DoCmd.OpenReport ... filters the report. I hide it because the user does not need to see it. Then when using the DoCmd.OutputTo acOutputReport... the pdf report is referenced to the open report. Don't ask me how, but it works! The pdf report is corectly filtered! I have...

Me.Filter = strRptFilter Me.FilterOn = True This is in the reports On Open Event strRptFilter this is a public variable Public strRptFilter as string

Hi vbaInet May I join this discussion? I have exactly the same problem. In the reports On Open event I have: Me.Filter = strRptFilter Me.FilterOn = True but the code never runs! The reports recordsource is a query built into the report. By clicking ... on the right of the recordsource...

I have the following code to print to report to pdf DoCmd.OpenReport strReportName, 2, , Wclause, acHidden DoEvents DoEvents DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, FolderPath & "\" & strReportCommonName & ".pdf", False, , , acExportQualityPrint DoCmd.Close acReport...

Did you manage to solve this? I have the same problem!

With Access 2010, I use the following to print to pdf: DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, FolderPath & "\" & strReportCommonName & ".pdf", False, , , acExportQualityPrint How can I add a filter (where) to the above to limit the records in the report If I am not...

Thunderbird

Many thanks The code uses Exchange. I don't use any Microsoft e-mail client. Outlook would be best but Outlook creates an address book for each account. I don't want that. I want one address book that can be accessed by all accounts! CDO is great. The problem with CDO is that I can't...

Thanks Do you have sample code using the windows API? For a variety of reasons I don't use Outlook

How can I use simple mapi with Access 2010? I am also running windows 7

Is there a method to read / write data from Mozilla's Thunderbird Address Book? I have a contacts database, and find that I often duplicate the data in Mozilla's Thunderbird Address Book. I would like to be able to "share" the data. I anticipate problems with possible duplications but I will...

I use CDO to send e-mails At work I need to use one smtp server, at home another. Frustrating! How can I automatically determine which smtp server my computer is connected to, and then use this server when sending e-mail?

I think I have found the cause of the problem! I stumbled across another forum where Stephan explains that including graphics in the report that needs to be converted to pdf can cause the memory problem. to test this, I removed the graphic and the problem disappeared! Although he does not state...

No. Each report will be its own. They are company invoices. So each invoice will be its own pdf

I am using Stephan Leban's "Print To PDF" solution. www.lebans.com/reporttopdf.htm On a form I have a list box of reports that I wish to print to PDF. The user selects the reports and the code loops through the selected reports and prints them to PDF If the number of reports selected...

I think that this is where the problem is