Search results

Example Application: http://www.myaccesstips.com/UI/Reports.html FIxed

http://www.mvps.org/access/tables/tbl0001.htm

The best solution is to create a function that will update the local FE database if an update is available. Running a batch script file to update the FE and launch the application is a good way to do this. Check Out: http://www.myaccesstips.com/deploy/deploy.html

You are welcome, glad I could assist.

You are welcome – glad I could help.

The MDE file will lock down the objects to prevent users from accessing the design view (forms, reports, modules). I use this in place of workgroup security if locking down my application is the goal. The mdw files needs to be distributed along with the mdb/mde. Not having it could prevent...

Check Out: http://www.databasedev.co.uk/login.html

Remove the criteria form the query and assemble the where condition in VB code. Then pass the where condition as an argument in the Docmd.Open Report action. http://www.mvps.org/access/reports/rpt0005.htm

Try: Private Sub YourTextBox_Click() Me.YourTextBox.SelStart = 0 End Sub

You are welcome.

Install and use Oracle’s version of the driver, not the Microsoft one.

Does your application currently capture the user though some king of login? That function would have to exits first. Then the code cam be modified as follows: --------------------------- Function EmailSnpFile(strEmail As String) Dim olApp As Outlook.Application Dim objMail As...

You are welcome – glad to hear you got your report working.

No – the MDE HAS to be created from Access 2003.

Simply copy and paste the code into a new module. On the Click event of your command button select Event procedure, click the build button and code: EmailSnpFile Make sure to add the Microsoft Outlook Object Library to your References (Tools > References from the Menu Bar in VBA Editor).

You are welcome.

Reports are designed for Printing. You need to create a report for your form. Then have the form button print the report. http://allenbrowne.com/casu-15.html

Add code to the double click event of the textbox: Private Sub YourField_DblClick(Cancel As Integer) Me.YourField = Now() End Sub

Older versions of MS Access cannot open MDE files created in newer versions. Did you have the 2003 removed? I always keep the old version of Access for development purposes. If so, can you have it reinstalled?

If you are using outlook as your email - I wrote a an function for this posted here.