Replies

Edited by HansV to replace Word doc with a cropped version of the screenshot it contained

I am working with a database in 1997 that was created previously by a programmer who is no longer involved. When I go to the window to view the tables, queries, forms, etc there is nothing listed (except for three tables). How do I view these? Are there certain permissions that were put into place. The menu of the database is also different in that it allows you to pull up different forms but not the usual menu and toolbars that open with Access. This is the first time I have come across this so please forgive my ignorance.

Also, how difficult will it be to convert Access 1997 to a later version? I am getting the following (see attached file) message when trying to open the database with
Access 2000 and also when trying to convert it. Again, were there permissions put on the database. Thanks.

Hi Francois,

I am confused. I am not sure how to get labels from the subreport. I meant Avery labels if there was a misunderstanding there. They will be used to put on badges to list contact info etc. I am creating a label mergel tablet in Word with the data source as a query, which is where I am getting into trouble. If I am missing something (very possible, lol) can you give me more detail? Thanks.

dorothy

Thanks all. It worked out well.

One thing I should have mentioned. The reason I would like to move them out of the table is that the primary key is related to the condo unit and my client has to keep this same key for the new owners (coming down from upper management.) I cannot have a duplicate key in the same table, which is why I need to move the record. What do you think?

Dorothy

Thank you, thank you, thank you. It worked. Dorothy

Used the following code:

Private Sub Tab Control: TabCtl0_Change()
If Me.TabControl.Value = 2 Then ‘ third tab, zero-based
Me.SubFrmPoolValOwner.Requery
End If

End Sub

Still is not working. Dorothy

Much clearer, thank you, but does not seem to be working. The name of the third tab is “Pool Information”, with a space between “pool” and “information”, and when I click up the subform and look at properties the name is SubFrmPoolValOwner. I used the following code:

Private Sub PoolInformation_Change()
If Me.TabControl.Value = 2 Then ‘ third tab, zero-based
Me.SubFrmPoolValOwner.Requery
End If

End Sub

One problem is that I could not use “Pool Information” in the coding with a space in between it, so I closed it. When testing this ,under the first tab I enter names in a form (with an underlying table) then when I go to the third tab – Pool Information – the subform is blank. Does not even show the fields any longer. When I close the form and reopen the info is then present under the third tab. What am I doing wrong? Thanks.

Thank you Hans. It worked great! Thank you.

Hi Hans,

I am not sure what or where the On Change event of the tab control is. I also don’t understand the value of the tab control is the zero-based index of the active tab. Sorry. Would you be able to guide me a little more. Thanks. Dorothy

Thank you Hans. You have been an incredible help. Off to sunny Florida. Take care.

Dorothy

Thank you Hans. You have been an incredible help. Off to sunny Florida. Take care.

Dorothy

Hi Hans,

IT WORKED!!! Thank you so much for your help. I did not imagine when I set up this report using a subreport it would take much more than a simple formula to get grand totals. As usual, a very good learning experience. Take care and probably will be seeing me again soon.

Dorothy

Hi Hans,

IT WORKED!!! Thank you so much for your help. I did not imagine when I set up this report using a subreport it would take much more than a simple formula to get grand totals. As usual, a very good learning experience. Take care and probably will be seeing me again soon.

Dorothy

Hi Hans,

When I open the report in design view there is just one subreport. In the regular view the subreport displays once under a Lead Company, which is part of the Main report, but there are many Lead companies, each with a subreport listed with company info. The subreport is link as follows: Link child fields – Lead_Name. Link Master fields- Lead_Name.

Dorothy

Hi Hans,

When I open the report in design view there is just one subreport. In the regular view the subreport displays once under a Lead Company, which is part of the Main report, but there are many Lead companies, each with a subreport listed with company info. The subreport is link as follows: Link child fields – Lead_Name. Link Master fields- Lead_Name.

Dorothy