Page 1 of 1 1
Topic Options
#89595 - 2002-11-18 11:59 PM Access table
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
Hi there!
I got to read and write to an Access mdb with a sigle table. I guess with two linked tables in the same mdb would be throught SQL, cause I tryed with no success.
code:
 $SQL = "INSERT INTO TBL_COMPUTERS (WORKSTATION,DOMAIN,) VALUES ('@WKSTA','@DOMAIN');" <--- and SQL1 
$Command.CommandText = $SQL

Is this the way?
Thanks guys
_________________________
Life is fine.

Top
#89596 - 2002-11-19 12:07 AM Re: Access table
Howard Bullock Offline
KiX Supporter
*****

Registered: 2000-09-15
Posts: 5809
Loc: Harrisburg, PA USA
See the DB* UDFs from Sealeopard.

[ 19. November 2002, 00:22: Message edited by: Howard Bullock ]
_________________________
Home page: http://www.kixhelp.com/hb/

Top
#89597 - 2002-11-19 01:19 AM Re: Access table
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11164
Loc: Boston, MA, USA
For starters, see DBExecuteSQL() - Executes a SQL command on a database .

You should also read Cannot find what you are looking for?

[ 19. November 2002, 01:20: Message edited by: sealeopard ]
_________________________
There are two types of vessels, submarines and targets.

Top
#89598 - 2002-11-19 03:39 PM Re: Access table
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
Howard:
As first sight UDF Collection is amazing you people have done a lot. IŽll make you know wen i am done with it.
Thanks for the searching stuff sealeopard.
The last one. Has anybody saw or made a support request form for network users with kixform ? cause my goal is to have a button from the login form that calls this support form that writes to a database the user problem. I am done the shape but not with its functionality (not easy). Only clues or links needed.
Thanks again.
_________________________
Life is fine.

Top
#89599 - 2002-11-23 04:43 PM Re: Access table
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
About forms I think I shoul have asked this last question in a new topic, finally I took the example of http://harmsy.freeuk.com/kixforms/Archive/index.htm usrmgr and changed to my needs.

The fact that I am a starter allows me to ask in COM Scripting or do I have to do it on Starters despite it is a COM question? I ask this cause havent seen a reference about that in the FAQ page. Please guide me if I am wrong.
Thanks boys [Wink]
_________________________
Life is fine.

Top
#89600 - 2002-11-23 04:58 PM Re: Access table
Shawn Administrator Offline
Administrator
*****

Registered: 1999-08-13
Posts: 8611
Jose, the COM forum is for COM questions and scripts, for folks just starting and for experts alike.

-Shawn

Top
#89601 - 2002-11-23 05:31 PM Re: Access table
Les Offline
KiX Master
*****

Registered: 2001-06-11
Posts: 12734
Loc: fortfrances.on.ca
As Shawn said, for beginners and experts alike.

Let the forum byline be your guide.
"Discussion on COM automation (includes ADSI, WMI, etc. within the context of KiXtart)"

Of course, based on each forum's byline, there will always be some overlap so we ask that you "Pick the most appropriate forum".
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.

Top
#89602 - 2002-11-23 05:32 PM Re: Access table
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
Thanks Shawn, by!
_________________________
Life is fine.

Top
#89603 - 2002-11-23 05:34 PM Re: Access table
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
Thanks LLigetfa !!
_________________________
Life is fine.

Top
#89604 - 2002-11-23 06:01 PM Re: Access table
Kdyer Offline
KiX Supporter
*****

Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
jose3,

Looking at some old Access code I had lying around.. The INSERT Statment is not the traditional ANSI SQL:

This is in VBA:
code:
DoCmd.RunSQL "INSERT INTO ErrorLog ( TStamp, Loan, ErrorMessage ) SELECT Now()," & Chr(34) & loan_nm
' Split
& Chr(34) & "," & Chr(34) & oDTrac.ErrorMsg & Chr(34) & ";"

HTH,

Kent

[ 23. November 2002, 18:02: Message edited by: kdyer ]
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's

Top
Page 1 of 1 1


Moderator:  Shawn, ShaneEP, Ruud van Velsen, Arend_, Jochen, Radimus, Glenn Barnas, Allen, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 507 anonymous users online.
Newest Members
gespanntleuchten, DaveatAdvanced, Paulo_Alves, UsTaaa, xxJJxx
17864 Registered Users

Generated in 0.107 seconds in which 0.073 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org