Recent content by AustinMan

I am trying to Update a table with a user-defined function using this below. DoCmd.RunSQL "UPDATE tblTickler SET tblTickler.DueDate=dhAddWorkDaysA(10,[tblTickler]![SignedForOn],[b]Array(#10/08/2007#,#11/12/2007#))"/b dhAddWorkDaysA is a function taken from MVP/ Access revised from VBA...

I am not just taking the code as my own but modifying it for this particular use - I left the proper owner declarations in the comments. Can anyone help me with this problem? I am trying to update the Date using this function call and have tried Array(Date1, Date2,Date3) and have unsuccessfully...

I am trying to Update a table with a user-defined function using this below. DoCmd.RunSQL "UPDATE tblTickler SET tblTickler.DueDate=dhAddWorkDaysA(10,[tblTickler]![SignedForOn],Array(#10/08/2007#,#11/12/2007#))" dhAddWorkDaysA is a function taken from MVP/ Access revised from VBA Handbook to...

I was wondering if there is a way of concatenating text at run-time from Data Access Pages. There is not much information on the web on this point. At the controlsource, I have done: 1. Text2: Text1 & Text2 - Errors out 2. Text2: Text1 + Text2 - Errors out as well. Any workarounds other than...

Thank you very much, that did the trick. Thanks for your quick response. (:I

I am trying to retrieve the Tab Color from Excel 2003. I can locate the Tab Color Dialog on Format -> Sheet-> Tab Color...; but when you right click on the tab, the tab color selection does not appear. I have repaired using Detect and Repair, I have reinstalled Office 2003. I do seem to find...

No, You are not alone. When I was using Microsoft Access 2000, using the Import Spreadsheet Wizard, when you are creating a new table, when you clicked on the white space of the appropriate column, the Field Name changes and the Format whether Text, Number, Date/Time would change. Our company...

Is it possible for LengthRowDetail, a variable representing a number instead of a straight numeric literal (an actual number)? It defeats the purpose of looping through.

The actual value is 10.

The value of irow is an integer value (a number). Any other suggestions?? I am totally stumped!

This is what I got so far. Option Explicit Type ProgramData pContract As Long 'pDocumentNumber As Long 'pID As Long 'pName As String 'pCOBJ As Integer 'pCalDRS As Single 'pDRSMatch As Single 'pNHICcert As Single 'pMACMatch As Single End Type Sub WriteShit(iTitle As Integer, iDetail As...

I am trying to error-trap the RefEdit Control so a range must be entered. How do I do that? Thanks!

Yes, It seems to be working now. Thanks for all of your quick responses.

I have tried that option and it still gave me the syntax error. I would like it set to xlveryHidden and have also used the constants (xlVisible,xlHidden, XlVeryHidden) with no luck. It seems to be a syntax problem with using the Worksheets collection. Any other suggestions?

I have a procedure called Copy Range How it should work is this: On Workbook Close event Call CopyRange and CopyRange2 (Sheet20 & Sheet21 respectively) I have to sheets set to xlveryHidden and having difficulty finding the correct syntax to change the Visible property to visible, if I need...