Search results for query: *

I am trying to email three existing MS Excel Workbooks from Access via a button. Any code would be great!

Any other help for ObjectType and ObjectName?

Can anyone tell me how to have the user push a button and have someone emailed (three separate files that reside in MS Excel)?

I have a subform that displays the first field with white background. (I'm assuming it has the focus) How do I get the subform field to display gray until the user actually goes to the subform fields?

Can anyone tell me how to enlarge the hourglass (when code is running). I want to be able to see a large icon on the screen to know that the application is still running. (From across the room).

What do you mean? Range object?

How do I get objects to be included in the workbook tab order?

How do I email an Excel Workbook from Access?

Does anyone know how to export a report as a PDF?

How do I get a combo box to display the first record automatically (not blank)?

The field is really chkComplete. Sorry! It is a check box. I changed the Record Type from Dynaset to Snapshot, what is the difference? When I now try to click on any of the checkbox's, a message displays in the lower left hand side of the application: Searching....Press Ctrl+Break to stop...

Can anyone tell me why I get an error message: "Invalid use of Null"? Function AdjsAmt(txtElement, dblTrackAmount, dblOrigAmount) As Double Select Case txtElement Case Is = "WCOF" AdjsAmt = dblTrackAmount - dblOrigAmount Case Is =...

I used: DoCmd.GoToControl "cboComplete" DoCmd.FindRecord "False" and checked your 2 things... Upon form open, I am brought direct to the first available false cboComplete. I can check any box I want. But I still can't UNCHECK any of the cboComplete boxes that I check. Help?

I don't want all the text to appear running. I would like a carriage return. Why does this not work? DoCmd.SendObject acSendNoObject, , acFormatRTF, "John.Smith@libertymutual.com", , , "Weekly JC File", "Amy please upload the weekly file and let me know when this is...

Does anyone know what the vb code for RETURN is?

This code works...but....now I can't check or ununcheck any of the already checked boxes! Help?

You are awesome. THANK YOU SOOOO MUCH!

In code behind a button, I put the following: AppActivate Shell("C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" & Chr(34) & "\\LX-file-ABC-01\central\Corporate\Group-Markets-2\Svc1Vol8\Reports\AdHoc\XXXXX\Req1358-XXXXX-Weekly\Completed...

I have tried this but I get an error message. What is chr(34)?

What do I do if my path is too long?