Re: [ExcelVBA] An error message "field cannot be updated"

 

What do you mean by "database"? Is this a real database or just an area in
the Excel workbook?

Regardless, please show your VBA code, and quote the exact error message,
and indicate which VBA statement is causing the error.

Regards, Dave S

----- Original Message -----
From: "Bap Wan" <pak_wan2001@yahoo.co.uk>
To: <ExcelVBA@yahoogroups.com>
Sent: Saturday, August 13, 2011 12:07 PM
Subject: [ExcelVBA] An error message "field cannot be updated"

> Dear ExcelVBA Experts,
>
> I faced a problem with VBA in Excel 2007 during adding new record on
> database.
>
> I have a main form with some
> textbox fields and 2 commandbuttons which is ADD and EXIT button. I try
> to add a new
> record by clicking ADD button after filling up all information. It doing
> fine for
> the first time. But I get an error message "field cannot be updated"
> when I try to add another new record.
>
> Can someone help me through this one? Thanks in advance
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1392 / Virus Database: 1520/3829 - Release Date: 08/12/11
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (18)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___