Tabulated Forms and pictures
- Thread starter hbaggs
- Start date
I do not understand your reply- sorry. I have a form with say five tabs appearing at the top of the form. Using your suggestion I open the toolbox and select the image tool. When I put the image tool over the form I get the changed color which enables me to position the new image. Trouble is then I have the image on the form regardless of which Tab I click on. I undretsand your tip to mean that I should not place the image using the image tool on the form but instead try to drop it onto the actual tab (the very small tab heading on the top of the form. The Tab doesn't change color and therefore doesn't accept the image (evn if it wouldn't fit.
eg. I have tabs accross the top of the form called Purchasers, Vendors, Property, etc. I need to put a picture on a purchaser's tab where all the purchasers details show but which does not also appear on the Vendor's and property's pages etc???
This is my problem and I still can't beat it!
Thankyou for any further help
eg. I have tabs accross the top of the form called Purchasers, Vendors, Property, etc. I need to put a picture on a purchaser's tab where all the purchasers details show but which does not also appear on the Vendor's and property's pages etc???
This is my problem and I still can't beat it!
Thankyou for any further help
OK I now have it...I needed to select the TAB first before I inserted the pictuire.
Problem I now have is that I have already about 100 fields over the five tabs and when I try to insert a picture as the backgound over the whole of the Tab it covers all the fileds. Is there a way to make the background picure just that...in the background???
Problem I now have is that I have already about 100 fields over the five tabs and when I try to insert a picture as the backgound over the whole of the Tab it covers all the fileds. Is there a way to make the background picure just that...in the background???
Mitch_____W
Mitch
- Local time
- Yesterday, 23:13
- Joined
- Oct 31, 2001
- Messages
- 73
Select the image and then click "Format" from the menu bar and then select "Send to Back". That should put the image behind all of the other objects on your tab page...
Hope that helps!
Hope that helps!
Mile-O
Back once again...
- Local time
- Today, 04:13
- Joined
- Dec 10, 2002
- Messages
- 11,316
Or you can use the form's Picture property to insert the image and this will actually paint the image as your form's background.
100 fields over five tabs is suspect though; are all these fields in the same table?
100 fields over five tabs is suspect though; are all these fields in the same table?
Thanks to you both- i will look at the two options shortly.
As regards the number of fields there are complex iisues here too. My form divided into 5 TABS has about 130 fields. The query which populates this form also queries several other tables and I am continually having the problem that access queries limit the number of fields it can query to 256. You may ask why the heck so many fields. Well the problem is this; The database is used as a program to handle all aspects of the legal requirements of buying a house. In USA I think you call that an Attorney. Here we are Conveyancers. To effect such a sale of a house (or indeed any real estate property) we need a program that has many variables. Depending on these variables we need to generate a Settlement Statement...kinda like a list of costs. The query has to look at every one of those 130 fields in the main table and able another 120 fields in other tables. Its a pain but I don't know how else we can do that. We live on the edge and know that one more filed in any of these tables may crash the whole thing. We constantly live with the fact that if we add one field we gotta take one out somewhere else or the query crashes..
I'm not sure if anyone has a sample database where this problem is addressed
As regards the number of fields there are complex iisues here too. My form divided into 5 TABS has about 130 fields. The query which populates this form also queries several other tables and I am continually having the problem that access queries limit the number of fields it can query to 256. You may ask why the heck so many fields. Well the problem is this; The database is used as a program to handle all aspects of the legal requirements of buying a house. In USA I think you call that an Attorney. Here we are Conveyancers. To effect such a sale of a house (or indeed any real estate property) we need a program that has many variables. Depending on these variables we need to generate a Settlement Statement...kinda like a list of costs. The query has to look at every one of those 130 fields in the main table and able another 120 fields in other tables. Its a pain but I don't know how else we can do that. We live on the edge and know that one more filed in any of these tables may crash the whole thing. We constantly live with the fact that if we add one field we gotta take one out somewhere else or the query crashes..
I'm not sure if anyone has a sample database where this problem is addressed
Mitch_____W
Mitch
- Local time
- Yesterday, 23:13
- Joined
- Oct 31, 2001
- Messages
- 73
Post your db and I will make some suggestions...
Mitch_____W
Mitch
- Local time
- Yesterday, 23:13
- Joined
- Oct 31, 2001
- Messages
- 73
No problem...
Mitch_____W
Mitch
- Local time
- Yesterday, 23:13
- Joined
- Oct 31, 2001
- Messages
- 73
Zip it first and then post it as a .zip file...hbaggs said:
Normalization
Mile-O-Phile, I have been reading up on normalization. I do have fields for all data broken down to a unique field, I have linked tables with Primary keys etc etc. I am limited in my knowledge so I am having trouble to see how this can reduce the number of fields in my query when it is essential that all the information from these fileds and tables is gathered for the report. This query is over a few different tables and a large number of fields in one table. My DB is probably flawed- you would be right! But it works within the limitataions of the query which lives on the edge of its useful life!
Any advice appreciated
Mile-O-Phile, I have been reading up on normalization. I do have fields for all data broken down to a unique field, I have linked tables with Primary keys etc etc. I am limited in my knowledge so I am having trouble to see how this can reduce the number of fields in my query when it is essential that all the information from these fileds and tables is gathered for the report. This query is over a few different tables and a large number of fields in one table. My DB is probably flawed- you would be right! But it works within the limitataions of the query which lives on the edge of its useful life!
Any advice appreciated
