I've created an ADO connection within DTS using vbScript ... can I limit the number of records returned?
I've tried using MaxRecords but it doesn't like it!
If Not isNull(recSQL(5).Value) then
connDW.MaxRecords = recSQL(5).Value
End IF
connDW.Open = "DSN=" & recSQL(2).value &...
Using ado from excel to execute sql statements against an access db. I have a problem when using the "like" statement though, as it never returns any data. Even though if i paste the same sql into the query builder it returns data. i've tried diff wild card characters ... anyone help????
sql...
Hi all,
Can someone give me a clue what this function is doing?
I'm not, as you may guess, familiar with Javascript, but doesn't stop the boss asking me to look into it!
The function I believe, should be counting the number of jpg's in a folder 'charts' that start with a specific string ...
1. Can you remove options from the autofilter drop down list ie the (Blanks) / Top 10 etc.
2. Can you detect when an autofilter has been applied / removed?
I have a column of TEXT formatted cells in the with dates in the format DD/MM/YYYY. when using cdate in vba to convert to a date, the dates seem to randomly convert to both UK & USA date formats, even if i use the format command to try and force it to DD/MM/YYYY ... any ideas?????
Is it possible in workbooks open, to determine if a reference is missing to avoid the compile error message. Is it also possible to select another ref instead, ie if word 10 missing and work 9 available use that????
Cheers
J
I'm using the code below as part of a subroutine to reformat some Excel data files. When I run the code from an Excel module it takes around 1 to 2 minutes to process the data. When I run it from Access, after creating an excel object etc, it takes 30 minutes +. Can anyone suggest why / how I...
Hi all,
I've got numerous workbooks made up from the same template workbook.
On the Workbooks_Activate event there's a line:
Application.Calculation = xlCalculationAutomatic
Which works fine on some workbooks, but on some i get a critical error, asking me to send report to MS & recover etc...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.