Re: My main form won't open

Tech-Archive recommends: Fix windows errors by optimizing your registry

How the heck do you "undo the changes" after you saved? This does nothing.
Even when you close the database out for the day & go home from work it
saves.

"tina" wrote:

> mel, you're giving vague information and asking for a specific fix. we can't
> see your database.
>
> you mentioned a number of changes you made to your form and/or its'
> underlying table. suggest you go to the last backup copy of your db that
> does *not* include any of those changes, and begin again. make one change
> and then test the form. if it's working, make the next change and then test
> again. repeat until you've either made all the changes again, or have
> identified which change is causing the problem. at that point you can start
> a new thread explaining the specific details of what you did and ask for
> help with a fix or work-around.
>
> if you don't have a backup copy of your db, try to "undo" all the changes
> you made, make a backup copy of the db, and then proceed as outlined above.
>
> hth
>
>
> "melwester" <melwester@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:F6FB2591-79B7-435D-B685-B6F1B8C46197@xxxxxxxxxxxxxxxx
> > OK - I've redid the query. Still nothing. There are records to be
> viewed.
> > both in the Table & query. Why don't they show up on the form????
> >
> > "Chaim" wrote:
> >
> > > Ditto Mr. Roberts comments, especially his Rick B assertion.
> > >
> > > When you deleted columns from the main table and moved text boxes to a
> > > subform, you no longer had the form that had been "working just fine all
> > > month long". If the form is based on a query, did you also update the
> query
> > > to reflect the changes to the table?
> > > --
> > > Chaim
> > >
> > >
> > > "Ronald Roberts" wrote:
> > >
> > > > If your form is driven by a query, open the query to see if it
> > > > displays any records. What Rick told you is correct.
> > > > Also, check to see if you have and filtering going on.
> > > >
> > > > Ron
> > > >
> > > > melwester wrote:
> > > >
> > > > > The main table is FULL of records to VIEW in the main form. This
> form was
> > > > > WORKING....Now IT"S NOT!!!!!!!!!!!!
> > > > >
> > > > > I would Like to know how to fix it?
> > > > >
> > > > > "Rick B" wrote:
> > > > >
> > > > >
> > > > >>Normally a blank form indicates that two conditions exits...
> > > > >>
> > > > >>1) There are no records that match the data source criteria (in
> other words,
> > > > >>there is nothing to see).
> > > > >>
> > > > >>AND
> > > > >>
> > > > >>2) The data source is not updatealbe, so new records can't be
> added.
> > > > >>
> > > > >>
> > > > >>
> > > > >>--
> > > > >>Rick B
> > > > >>
> > > > >>
> > > > >>
> > > > >>"melwester" <melwester@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > >>news:27185F66-60F7-4AB9-BF8C-77860307BACA@xxxxxxxxxxxxxxxx
> > > > >>
> > > > >>>My main form won't open it has been working just fine all month
> long
> > > > >>>including yesterday. Now All I get is the Header at the very top.
> The
> > > > >>
> > > > >>rest
> > > > >>
> > > > >>>of the screen is Grayed out.
> > > > >>>
> > > > >>>I did delete some columns in my main table where the form is based
> on.
> > > > >>
> > > > >>And
> > > > >>
> > > > >>>moved some text boxes that were on the main form into a subform.
> Did both
> > > > >>
> > > > >>of
> > > > >>
> > > > >>>these today. Now the form doesn't show anything.
> > > > >>>
> > > > >>>What do I need to do to get this working?
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
>
>
>
.

Relevant Pages

  • Re: User defined function in SQL statement
    ... backup will be stored and creates a name for the backup that includes the ... > Option Compare Database ... >Query shown below. ... >to jointly form the primary key of the [UNITS CONVERSION TABLE] Table. ...
    (microsoft.public.access.queries)
  • RE: Append tables
    ... Sounds like you want to UPDATE and not APPEND. ... BACKUP the database. ... Create an unmatched query using a common field like SomethingID. ...
    (microsoft.public.access.gettingstarted)
  • Re: update item code
    ... BACKUP your data before attempting the following. ... To build that In the design view of a query ... We have a a replacemene code database has 2 fields. ...
    (microsoft.public.access.queries)
  • Re: How can i control objects of another DB thru code?
    ... If the other mdb is not being used by anyone, ... Another way is for you to use DAO to open a database object ... it's just to make a backup of the table then you don't need ... Use your maketable query to ...
    (microsoft.public.access.formscoding)
  • Re: Finding and deleting dupe queries across two fields
    ... Backup your data before doing this. ... There is no undo ... available when you run the last query. ... qDeleteA should give you all the duplicates. ...
    (microsoft.public.access.queries)