Tiffany-
What is the SQL of the query? Open the query in Design view, switch to SQL view, and copy and paste the text you see in a reply. I bet the query is not updatable.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Friday, October 21, 2011 7:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Not working....confused
John-
Yes I can enter data in in the field in datasheet view and it shows the data in datasheetview on the data sheet form. But it will not show on the query or even allow the query to update. I still get the same error message.
Tiffany Atchley
PO Box 1003
Fort Duchesne, UT 84026
435-722-7833
WWW.ODYSSEYMINISHETLANDS.NET
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, October 21, 2011 10:41 AM
Subject: RE: [MS_AccessPros] Not working....confused
Tiffany-
That makes no sense. Access doesn't use SQL to update your table via a form/query. Can you open the table with the new memo field in Datasheet view? If that works, can you enter data in the new memo field on any row?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Friday, October 21, 2011 6:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Not working....confused
John-
That worked. So I added a memo field to the table and the form. Then query run and the memo field does not show up in the table window so I can add it to my table query. I tried updating the table and then hit run and I get this message "syntax error in UPDATE statement".
What should I do?
Tiffany Atchley
PO Box 1003
Fort Duchesne, UT 84026
435-722-7833
WWW.ODYSSEYMINISHETLANDS.NET
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, October 21, 2011 10:02 AM
Subject: RE: [MS_AccessPros] Not working....confused
Tiffany-
Probably, but it should't crash. Open the query in Design View and add it to the query.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Friday, October 21, 2011 5:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Not working....confused
Okay I found the instructions on how to turn it off and I ran the repair compact & repair. But, it is still not allowing me to add the field or any existing field for that matter. I wonder if it is because I have table query and it cannot update the table query.
Tiffany Atchley
PO Box 1003
Fort Duchesne, UT 84026
435-722-7833
WWW.ODYSSEYMINISHETLANDS.NET
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, October 21, 2011 9:30 AM
Subject: RE: [MS_AccessPros] Not working....confused
Tiffany-
Which version of Access?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Friday, October 21, 2011 5:23 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Not working....confused
how do I turn auto correct off?
Tiffany Atchley
PO Box 1003
Fort Duchesne, UT 84026
435-722-7833
WWW.ODYSSEYMINISHETLANDS.NET
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, October 21, 2011 9:20 AM
Subject: RE: [MS_AccessPros] Not working....confused
Tiffany-
When was the last time you compacted and repaired your database? If it's still
broken after that, try creating a new empty database, then import all the
objects from the old one. Oh, and turn Name AutoCorrect off!
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Friday, October 21, 2011 5:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Not working....confused
I added a column to my table. The field is a check box. Now I would like to add
it to my form, but when I select it in "add existing field" it shuts down access
and says to back up dbase for repair.
Any suggestion?
Tiffany
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Jumat, 21 Oktober 2011
RE: [MS_AccessPros] Not working....confused
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar