Access Error

TO: MX - I am new - how do I download it to you?  

Buckeye1969 - you Accepted a post ... but the problem has not been solved yet.  

1) Click the Request Attention button and request to reopen the question.

2) To upload, click the Attach File box below this box.  Note again ... I don't have A2007, so you will need to convert back to A2003.  And be sure to describe exactly how to reproduce the problem.

Also ... did you try what cdbeste suggested ?

mx

I started by converting it to Access 2007 to Acces 2003.  It looks like all my forms and queries disappeared.  I will now try the prodecure cdbeste suggested.  


SECO-Membership-Database-Access-.mdb

ok ... One issue is ... it's looking for the 'LiveMapIcon.bmp' ...

How do I reproduce the problem you are having - be specific.

mx

btw ... I have to leave shortly - back a bit later ... sorry.

mx

I do not know - as when I put it in A2003 - the form I am having problems with did not tranfer.  Non of the queries or forms came over into A2003.  The problem is that the form shows fine in the design mode, but has no content when I open it as a form or in the layout look.  I tried the other suggestion and it did not help.  

I am not proficient and has after weeks got the codes in I needed to use dlookup - and to be honest I am not sure how to recreate the dlookup I finally got working.  I do not have a problem with recreating the entire form - but when I tried to do so for dlookup - I could not make it work again.  So ... if I lose this form - I do not know where to go.  Is there a Lookup Wizard?

No problem - I will get something to eat and return later myself.  Thanks for your help.  I do not know where to go with this.  

When I look at the form f_contactdetails in the design mode - I can see all the field etc..  However, if I try to open it or look at it in Layout - none of the fields are there.  The first couple of times I tried to open it - I got the Error Message - "Object of class does not support nthe set of events."  It has now disappeared.

MX - are you there?

I just got back ..

mx

OK - I tried to do another form to see when the problem happened - it was when I added a combo box. - Although I had something similar working prior to the time this happened.  It happened again when I added a combo box.

I was adding combo boxes when it happened before also.

Could I somehow be doing something wrong with a Combo Box - I am using the Wizard.  Also, is there a Wizard for dlookup in access?

Thanks for the other answer - any idea what could be going wrong with the combo boxes?

"When I look at the form f_contactdetails in the design mode - I can see all the field etc."

When I open it, I get the error message about the bmp file.  What/Where is tha ?
And ... I don't see the controls either.  All of the controls are on the Tab control.

mx

I know nothing about a bmp file.  I am not sure what you are asking about controls.  I guess I am in over my head.  I have learned on my own by trial and error and do not know terminology.  If you cannot help after seeing it - not sure what to do.  Thanks so much for attempting to help me!

There is a tab control on the form.
There are controls on the tab control.
I'm trying to find the reference to that file now ...

mx

Thank you.  I just found a backup to my database!  The form is working on it!  I will proceed with it and make sure I have a backup to fall back on.

Thank you for your help.  I will continue working on my backup.  I appreicate your time and help.  I have already entered excellent point value for you.  

ok ... found the LiveMapIcon.bmp problem ... it's on the command button Click To Map .. in the picture property.  I changed it to something else from the Browse list.

The reason you don't see the controls is because of the Record Source for the form.

SELECT t_Membership.*, t_CountyDistricts.[SECO District], t_Position.Position, t_Level.Level, t_Annualdues.Cost, t_Committees.Committees, t_ExtraInfo.Notes, t_ExtraInfo.[Web Page] FROM (((((t_CountyDistricts INNER JOIN t_Membership ON t_CountyDistricts.CountyID=t_Membership.CountyID) INNER JOIN t_Position ON t_Membership.MembershipID=t_Position.MembershipID) INNER JOIN t_Level ON t_Membership.MembershipID=t_Level.MembershipID) INNER JOIN t_Annualdues ON t_Membership.MembershipID=t_Annualdues.MembershipID) INNER JOIN t_Committees ON t_Membership.MembershipID=t_Committees.MembershipID) INNER JOIN t_ExtraInfo ON t_Membership.MembershipID=t_ExtraInfo.MembershipID;

For sure that is going to be problematic no matter what.  If you temporarily remove it, then open the form - you see the controls - of course they will all have #Name ...

mx

As a start, try changing the form's record source to just t_Membership - then open the form.  Now you will see controls and data.Then only control hosed up is SECO District ... which is not in the RecordSource.

mx