is it possible to save few bookmark fields into ms access

[Haroon]

hi

i made a template and vb form for user to enter data and the bookmarks also
get saved in ms access database, i want to find out if i can insert few
fields in ms access database, i have this code which inserts data into ms
access database,

strSQL = "INSERT INTO Time_Costs " & "VALUES (" & strOurRef & ", " &
strTodaysDate & ", " & strTotal & ", " & strTotal2 & ", " & strLetterType &
", " & 0 & ", " & strPaid & ")"

...with the rest of the code, which works fine, i have to match the number of
columns with the number of bookmarks in order for this to work, e.g. if i am
inserting 6 colums, i should have 6 columns filled with data in ms
access,otherwise it wont work.

anyone knows work around this?
cheers.

 

[Doug Robbins - Word MVP on news.microsoft.com]

See the last of the following series of articles:

http://www.mousetrax.com/techpage.html#autoforms

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com