Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adjusting a macro that retreives access data
Can anyone help me adjust the "big macro" GetDataFromAccess from the
following link, so that it counts the number of records, not retreive them in the test examples ? http://www.rondebruin.nl/accessexcel.htm Any help would be appreciated. -- Regards, timmulla |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adjusting a macro that retreives access data
You can check the .RecordCount property of the returned recordset. For this
to give reliable results, you need a client-side cursor also. something like this as far as I remember: With MyDatabase .CursorLocation = adUseClient .Open MySQL, MyConnection, 0, 1, 1 MsgBox .RecordCount End Sub NickHK "timmulla" wrote in message ... Can anyone help me adjust the "big macro" GetDataFromAccess from the following link, so that it counts the number of records, not retreive them in the test examples ? http://www.rondebruin.nl/accessexcel.htm Any help would be appreciated. -- Regards, timmulla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adjusting comment box size by Macro | Excel Discussion (Misc queries) | |||
Adjusting Macro | Excel Discussion (Misc queries) | |||
Is there an excel funtion that retreives the last cell of a list | Excel Worksheet Functions | |||
Chart Adjusting Macro II | Excel Programming | |||
Macro / VBA adjusting variable columns | Excel Discussion (Misc queries) |