Replies

Wendell, I’ve created a list form, based on a sql query. When I tried to place the command button on the list form I got the previous error message – see attached. The data sources are not the same query. Any thoughts please?

Hi Wendell,
Please do, pardon my ignorance regarding opening forms. Up until a couple of months ago, rightly or wrongly, I was able to open a data form from a list form – both of them having the same data source. Opening the data form never caused an error or exception message. So what’s changed then. I think it must be an Office update? Otherwise it’s Office 2003 inter-reacting with Windows 7. Now don’t get me wrong but there is something weird going on. I thank you for the advice about basing the list form on a SQL Query – I can do this, however it would seem that I have to re-write 50% of my forms then.

Wendell, I have copied the db to another directory, so that I can experiment with it. Having deleted all of the macros and forms, I created a single form view of my IndividualData then a continuous list form. The command button to open the data form where [clientcode] = [clientcode] on the list was then created. However it does not work. Ok, you commented that “I would make it completely unbound” Does this mean that the list form does not have a table or qury as it’s source please? In which case how is the list data displayed?

Hi Wendell, both forms are based on the same query. So, you can see an abbreviated view in FrmList; then click on the macro button to open the FrmData (where) [RecordId] on the data form equals [RecordId] on the data form.

Weirder & yet weirder. When the command button with the OpenForm command is placed on the FrmList to take you to the FrmData it doesn’t work. So I wrote a macro to do exactly the same thing.
Saved the macro
Drew a command button on the FrmList and assigned the macro to it.
Switched to normal view.
Clicked on the command button – went straight to the correct record in the FrmData! Yippee.
Closed FrmData, can see FrmList, no problem as the macro did not have a close command in it.
Save and close FrmList.
Re-open FrmList, command button missing
Re-openmacro – macro missing!

Any ideas please, as to what the H is going on?

Wendell, thanks for the response. Interestingly I tried building a list form in another (name & address) db and created the macro button taking me from the list to the underlying data form = it works! So there mus be something wrong with my form???
Please advise what sort of information I can supply, properties of the list form, properties of the data form, screen shot of the query?

I’ve installed the Feb 2009 monitor driver, the screen resolution on boot up reverts to a generic driver with a low screen of 1024. The flicker to black still happens. Any further ideas please?

Ok, thanks for that advice. I’ve just checked the connect thoroughly, taken the plugs out, cleaned off the dust then re-attached securely. In the meantime Samsung advised that I should install their latest driver. Had a look on their net and find it to be dated Feb 2008! Any after downloading and installing the “latest” driver we shall see what happens…

Unfortunately the command butoon cannot now be created – the error message is that a duplicate key would be created! So I rebuit both the data and the list forms and still the same message. I have checked through all of the forms that I have both Amin and User permissions. This is quite ridiculous really. What shall I try next please?

Hans, I did have, first the macro opens the data form, then closes the list form – saving in the process. However, when I removed the Close command, leaving just the Open form, I still get the same message, and the macro gets deleted!

Wendell, I can create the command button with the Open form action and [CodCode] in the list = [CodCode] in the data – that works but leaves the list form still open; I’d prefer it closed.

OK, I’ve identified that there were 76 corrupted forms in the database – and am re-building them, a pita, ce la vie. I have created a form called companylist, is displays the company code, name and client status. From here I want to be able to click a button and open the CompanyData form, displaying the same company as had focus on the list. Simple really. I wrote the macro then created a command button and attached the macro to it. I get error message and I can’t fathom our why this is happening. Any help will be appreciated. Pictures attached which show the initial error, Macro 01 and Macro 02 shows the macro itself.

Helped me too. Thanks Hans

Hi Hans and all members,
I created a new databse, imported all the objects from the old one. Many error messages on the forms, none on the queries or reports. On opening the db to the Forms section, all of the forms are displayed… Now I can open a form – the one linked to it throw up an arror message that the Jet engine can’t find that form! After canceling the error messages the form opens and is ready to edit, however any changes made cannot be saved. Can anyone explain what is going on, and would I be better to delete the forms (some / all) ?

Thanks Hans, I’ll give that a go, and let the forum know.

So, what I really need to knowthen, is how to get rid of this corruption in the front end? Do I delete all the forms and or Queries and start again or other actions please?