Selasa, 26 Juli 2011

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]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar