Search results for query: *

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.

In Access click on Tools -> Options. Then click the "Forms/Reports" tab. Then deselect "Use Windows Themed Controls on Forms". Apply and reopen your form. The tab control should be the normal background now, but your command buttons and other controls will also look slightly different.

Is "onHand" a function you created? Is the subform in datasheet view so that it lists all the records associated with the entered date? If so, where does it show the total, and what exactly is the total of? You need more details to your question. Also include the error number and description...

Create a query based on the data table. Use SQL similar to the following to get rid of the hyphens and spaces for the field containing the identifier: SELECT Replace([Name]," ","") AS [No Space], Replace([No Space],"-","") AS [No Hyphen] FROM Table1; Then just base the query on the newly...

you are wrong missinglinq unless something has changed in recent updates to VBA. http://support.microsoft.com/kb/212673/en-us

if you do not declare each variable separately then dim x,y,z as string is actually translated as dim x as variant, y as variant, z as string maybe i was not clear in my explanation but please tell me if this example is incorrect.