On Sep 25, 1:39 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Viasys, can you provide some more info?
Do these forms have combo boxes on them?
Is the RowSource of the combo a table or a query?
How many fields in the table/query?
Anything in the Format property of the fields in the RowSource table?
Hi Allen, sounds like you know something :-)
Looking at one of the forms now, there's one combo box that uses a SQL
statement against a table.
Rowsource = SELECT [zstblWhatsNew].[WhatsNewID], [zstblWhatsNew].
[VersionNumber], [zstblWhatsNew].[ReleaseDate] FROM [zstblWhatsNew]
No formatting in the combo box or the source table. The form does not
open in design mode either.
Another form I just looked at is a template one I use for unbouind
forms, it has 7 buttons, 4 labels and a box. All the buttons have a
function call (=Functionname(form) or some such) and are no different
to all the other forms that do work. In fact, everything on tjhis
template form would exist in the other forms, which makes it hard to
narrow down. There is a smart tag saying one of the button's short cut
key is used more than once but that doesn't occur i nthe other form
that I looked at.
Now (I purposely re-applied SP3 to a machine) if I try opening in code
in normal mode I get "The microsoft jet database engine cannot find
object '', make sure the obect exists and you spell its name and thre
path name correctly", opening in design view gives the "not enough
memory".