Deb-
You must have re-downloaded your old file. Did you try my "fixed" file? I've
sent it again to 2_AssistanceNeeded.
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 Deb
Sent: Tuesday, July 26, 2011 7:53 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Display all records in subform datasheet
Hi John,
Thanks! I deleted all of the files. I download the fixed file, opened it,
and as soon as I tried to go to design view I got the same error message as
yesterday. (" This expression is typed incorrectly, or it is too complex to
be evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplfying the expression to variables.")
IF I delete all data from the main form, then that error message stops
coming up, but now I get an error message that says Part_number cannot have
a null value as it is set to True.
Did you get any of the error messages while checking the file?
I'm really sorry this is being so difficult and I totally understand if you
are tired of dealing with it, I don't want to take up all of your time!!
Your assistance is greatly appreciated!
Thanks!
Deb
On Tue, Jul 26, 2011 at 12:33 AM, John Viescas <john@viescas.com> wrote:
> Deb-
>
> See the "fixed" file I uploaded. You had the Primary Key wrong on the
> Parts_Purchase table.
>
> Please delete all the other files you uploaded to make space for other
> users.
>
> 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)
>
>
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar