#1   Report Post  
John
 
Posts: n/a
Default Access Database

I started writing a program using Access 2002. I have updated to Access 2003
professional, and now when I want to write to an existing table using the
following code:
DoCmd.GoToRecord , , acGoTo, 1
OwnersNameText$ = TbOwnersName
[OwnersName] = OwnersNameText$

I can not write to the [OwnersName] field in record 1. The data ends up in a
new record, as if I used "acNewRec". It doesn't matter what record I try to
update, the data only goes to a new record.

This problem didn't occur until I installed OfficeXpSp3-kb832671-fullfile-enu.

Any help will be appreciated. Thanks...
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Query cannot find tables in Access database Dennis Cheung Excel Discussion (Misc queries) 0 July 7th 05 04:17 PM
Importing Data from an Access Database Including a Hyperlink Colum B.C.Lioness Excel Discussion (Misc queries) 0 May 16th 05 05:26 PM
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors X_HOBBES Excel Discussion (Misc queries) 0 March 15th 05 06:46 PM
Open Access Database under and Excel window using a Macro BMSpell Excel Worksheet Functions 1 January 8th 05 05:32 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"