Does anyone know how to insert a record into access without submitting a form?

I want to create a page counter that inserts and updates a field based on the date and then another field on another date. Ultimately to create a graph based on the info?

I currently have a script that creates a new txt file if the date changes so that I can see page hits per day. I want to do this with access to create some stats based on the info.

Please help!!
<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle>



Edited by - visionuk on 01 Feb 2002 11:16:13

Use Command/Stored Procedure

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Does anyone know how to insert a record into access without submitting a form?

I want to create a page counter that inserts and updates a field based on the date and then another field on another date. Ultimately to create a graph based on the info?

I currently have a script that creates a new txt file if the date changes so that I can see page hits per day. I want to do this with access to create some stats based on the info.

Please help!!
<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle>



Edited by - visionuk on 01 Feb 2002 11:16:13
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Sorry i'm still finding my feet with lots of this!

How would I go about this?
Or is a good tuturial.

Thanks in advance

Andy Smith

Sorry, but it would be little complicated to explain it here in talkzone and I don't know of any UD resource that can help. I'm using UD mostly for 'look & feel' part of the job and the rest I usually hand code. If you'd like to try to code it take a look at this: www.aspfaqs.com/aspfaqs/.

P.S. I'm sure that Owen will have some more appropriate link or explanation.

Viktor Farcic

TalkZone Manager

Edited by - vfarcic on 01 Feb 2002 13:13:38

Will do, thanks!