GTC-KTX
asked on
Microsoft Access form - Everything visible in design view but invisible in Form view
I have a Microsoft Access form that i have been working on for a couple weeks. It has a tab control object with 9 tabs. Each tab allows the user to input data for various categories of a sales opportunity. As i'm building this form, i typically toggle back and forth between design view and form view. For some unknown reason, when i made a change today i toggled from design view to form view and there is nothing visible except the form header. The only change that i had made was to add an image control on one of the tabs. When i toggle back to design view, everything is there. I'm pretty worried about this, since there is a couple weeks work involved if i lose it. Any help would be greatly appreciated!
I expect you tried removing the entered image control.
Can you post a sample db?
Can you post a sample db?
ASKER
I tried removing the image control and i still have the same problem.
I'm relatively new to access, so i'm not sure exactly what you would need me to post as far as a sample db. Are you talking screenshots of the properties? or should i post my actual table somehow?
I'm relatively new to access, so i'm not sure exactly what you would need me to post as far as a sample db. Are you talking screenshots of the properties? or should i post my actual table somehow?
You can create a copy of the database, remove any sensitive data from it and then attach the copy to this thread.
ASKER
How big of a file can i attach? What is the easiest way to create a copy of the database?
let's start this way: Create a new, blank database. Export the form in question into it and attach that to the thread.
ASKER
It says "The extension of the uploaded file is not in the list of accepted extension"
I'm trying to upload the blank Microsoft access database file with the form in question.
I'm trying to upload the blank Microsoft access database file with the form in question.
If using access2007, save it as 200-2003 format.
Make sure u have the form and necessary data tables behind it.
Make sure u have the form and necessary data tables behind it.
ASKER
It wont let me save it in an earlier version. Evidently i used features that are included in Access 2007 and not supported in earlier versions. Any other suggesions? I'm dead in the water until i get this fixed.
ASKER
I uploaded it at a different site. You can get it at this link:
http://www.speedyshare.com/903715396.html
http://www.speedyshare.com/903715396.html
Downloaded file did not open!
Rty to add .txt tothe end of yo ur database and send through EE.
To reduce the size, select Office Button - Mange - Compact and repair.
To reduce the size, select Office Button - Mange - Compact and repair.
ASKER
Thanks hnasr. Attached is the file.
changed extension to .txt (original file had extension .accdb)
Database1.txt
changed extension to .txt (original file had extension .accdb)
Database1.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Relatively new to Access, so i apologize if this is a stupid question. where do i view/change the source query you are referring to? This worked before as i was developing/testing. do you think that what you're seeing is a result of how i exported this into a blank database so i could post it?
In design view of the query. click the line joing the tables to highlight it then right click on the line and select "join properties"
Form - design
Properties Sheet
Select Form
Record Sourse
click ...
You see the query which supplies the data for the form
Properties Sheet
Select Form
Record Sourse
click ...
You see the query which supplies the data for the form
ASKER
Thanks Guys! That worked. Appreciate the help!
Good luck.