I just spent 15 minutes trying to figure out what was wrong with a form I created using R:Azzak's marvellous "click to switch sides" form with a view and a temp table.

I opened the form in design mode and got error 2038 "Table does not exist". My On Before Design action created the table. It dropped the table first, with error 2038 off. What the heck?

Well, DUH - when you create a view that refers to a table that you have not yet created ... So I switched the table and view definitions so the table was there when I created the view ...

Just one of those mornings, I guess.

Albert

--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]

(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================


Reply via email to