Search results

total price? total quantity?

If I set a reference to an object library and then distribute the application to other machines that may not be running the same version of some application, will errors occur? For example, I have a reference set to Microsoft Excel 10.0 Object Library. If I give this app to someone running...

Set the control source of the appropriate field to: =LName & ", " & FName &" " & MIName

http://icons.visualnoise.net/ http://i-cons.tk/ good luck!

set the bottom combo box enabled property to false. only enable the bottom combo box after a valid entry has been selected in the top combo box. feel free to email. good luck!

The default value of the combo box is in the bound column. Use the Column(index) property to access other data within the combo box. For instance, if the bound column is column 1 (ID) and the column displayed is column 2 (MachineName), you would return the machine name using...

DoCmd.RunSQL ("SELECT tblExercise.* INTO tblNewExercise FROM tblExercise;") DoCmd.RunSQL ("DELETE * FROM tblNewExercise;")

I send email through Outlook all the time. If you'd like, send me an email (with your code or db attached if you like) and I'll try to help noodle it through.

You probably don't have a reference set to Outlook. Open any code window. Got to Tools>>References. A dialog box will open. Scroll down until you see Microsoft Outlook. Check the box next to it. Click OK. Try your code again. Good luck!

good call

I hate to tell you this, but the general rule is: Do not STORE calculated data. Only DISPLAY it (on forms and reports and such). It is in your best interest to NOT have the summed total IN your table.

Go to this site: http://www.candace-tripp.com/access_downloads.htm Look for Audit Trail example. Good luck.

I assume, you're summing the check box values? Why not multiply the final figure by -1?

Shoot me an email.

nevermind. i'll use the Full Path property and parse out the root.

I am using a treeview in one of my forms. It works beautifully, with one exception... I would like to use the tree view to update an underlying table after all adjustments have been made. I would like to update: ThreadText with Node.Text ParentID with Node.Parent.Key and InitialThread with...

You're welcome. Future reference (and for the others on this board): If you are using Headers in your list box, you must check for an integer when looping through the items, . The first item will return the Header value, NOT the value of the first data item. Good luck!

send it on over.

Try this... Private Sub Hrs_Calc() Dim i As Integer Dim JHrs As Double For i = 0 To lstResults.ListCount - 1 JHrs = JHrs + lstResults.Column(4, i) 'assumes the data you are looking for is in column 4 (the 'fifth column in the list box) Next Job_Hrs = JHrs End Sub If you are still...

which column would you like to sum?