Recent content by grgimpy

It looks like it gives examples at the bottom of the FAQ: Open a folder: fHandleFile("C:\TEMP\",WIN_NORMAL) Call Email app: fHandleFile("mailto:bpo@yahoo.com",WIN_NORMAL) Open URL: fHandleFile("http://uk.yahoo.com";, WIN_NORMAL) Handle Unknown extensions...

You are probably missing a refence to Outlook Object Library in the database you are trying to execute the code from. Open up the Visual Basic code then choose Tools -> References. Make sure the Outlook library is selected.

Worked great...thanks again!

I will play with the beforeupdate event. Thanks for the input.

I have a master form with a child subform setup. This is a one to many relationship. I want to ensure all fields are being filled into each subform record before new records are added. I would like to accomplish this without requiring the fields to be entered in the table properties. I have...

Many times Error 6: Overflow is caused by trying to store data in the wrong data type. Maybe you are trying to store data from one table into a field that is of a different data type in the other table. Another way this error will come up is if you divide by zero in your calculations. You...

Try the method outlined here: http://allenbrowne.com/ser-47.html

Thanks AceMan, but I'm still getting the same error...

I have my main form (frmORC), a subform within the main form (fsubDatasheet), and a subform within fsubDatasheet (fsubTestShot). I am getting Error 2455 (You entered an expression that has an invalid reference to the property Form/Report) on the following line of code...

I should note that the relationship from tblORC to tblTestShot is one to many in case that wasn't clear.

I have two tables (tblORC and tblTestShot). tblORC has the following fields: [ID],[Date/Time],[Item Number],[Discrete Job] and a lot more that aren't important. tblTestShot has the following fields: [ID],[Test Shot ID],[Test Shot Number] and some more fields about that "test shot". I have a...

I personally like using this calendar form created by Allen Browne: (http://www.allenbrowne.com/ser-51.html). Also, just bring up the calendar automatically when the user moves to the text box (got focus event).

Here's something I dug up from a project I worked on. You may have to make a couple changes. Public Function OpenFileDialog(boolMultiselect As Boolean) As Variant On Error GoTo Err_Handler 'The following function utilizes the Open File Dialog 'built-in Microsoft Office feature. It...

Try using the Form_Close() event.

The code for opening a report is DoCmd.OpenReport "Report Name", acViewPreview Do you have a form that shows each record? How is this code run? With a command button? Need more information to help.