Search results for query: *

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...

Thanks to you all for your quick response. All help was appreciated. I wanted to Proper case the active row only and Tony provided me with a solution. Thanks Tony!! [thumbsup2]

I have a problem with the proper function. 5 Stars for the one who can me with this. Set X as Variant If ActiveCell.Column = 2 Then Application.ScreenUpdating = False Application.EnableEvents = False Application.Cursor = xlIBeam Set X =...

Thanks for sharing the knowledge of VBA. I am growing more proficient, at least I hope, with this language. Now, I am asking specific scenarios that are not easy to look up in a Microsoft Excel files. Here was my previous scenario: I created a workbook that had 15 sheets of 1 formated Page...

Yes, the Call ShowModeless2 is the function the provides the option for XL 2000 for the optional argument of .show Modal vbModaless. I made another userform that insert rows and using that same syntax (IF THEN ELSE), it works for that userform. I do not know if the Application.run function...

I have a protected VBA project which I wrote code in XL 2000. Please HELP!! I can not determine in the Module1 the compile error, all the code below is in Module1 and the Sub Showdialog is called on the Worksheet Selection change event in the workbook. I have this statement and call ShowDialog...