Hi,
I wonder if somebody knows: Is there a way to append records of a recordset simply into an another recordset (table)? (ADO).
I have a read-only database. I want to insert some (120-100) records all at once from this into a table of the client...
call the following code from the on close event procedure of your main form (or an invisible form what loads when the client starts). I use it on NT and 2000.
'**********************************************************************************
Sub sbCompactCurrentDatabase()
Dim FS, a
Dim...
How could I open a DDE channel to the Netmanage Telnet application?
The path of program
"C:\Program Files\NETMANAG.32\TELNET.EXE".
How to handle that application, send message to that?
pls F1
thanks
hi,
My problem: i have an Access database. I want to open a telnet client
(myHwnd = Shell("C:\Program Files\NETMANAG.32\TELNET.EXE")) and write from Access into telnet (VBA).
How to do it? How to handle the telnet?
all help is appreciated
ide
I have an sql query with in its first line an index command (bellow). Could I use it in Access query (and how?) or could I give the index command to the ODBC in Access with ado, dao? ..Because without this it's terrible, terribly slow..
10x
:-) ide
SELECT /*+...
I have a query (bellow) in sql. Into the first line I insert an index command line.
Could I use it (and how?) in an Access query? Or give it anyway to the ODBC with dao, ado?
1000 x 10x
:-)
ide
SELECT /*+ INDEX(INV.MTL_MATERIAL_TRANSACTIONS INV.MTL_MATERIAL_TRANSACTIONS_N15...
I want to link a table.
If the BetetMain.mdb hasn't database password, the
DoCmd.TransferDatabase acLink, "Microsoft Access", _
actPath & "\Betet\BetetMain.mdb", acTable, "Betet", "Betet"
command works.
Otherwise it inputs the correct password and after...
Hi you all,
(and sorry for my English..:)
I have a problem, what I couldn't solve for a long time (DAO).
How could I link from mdb1 a table of a database-password protected Access file (mdb2) via VBA?
mdb2: actpath & "\Betet\BetetMain.mdb"
table name: "Betet"
If it hasn't...
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.