An expert who has achieved level 2 by getting 100 points
An expert who has answered 20 questions.
An expert that has over 10 points.
An expert whose answer got voted for 2 times.
Re: tabs/sub-form in access 2007 form will not scroll...
Open the form in design view open the properties dialog box by right clicking in the general form area not in the gray area of the detail section. In the properties click on the format tab. In the format tab goto the default view and select continuous form. This should create a virtical scroll bar once a record in the data base.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:
1. Do not Open Access database must closed
2. Sufficient storage space available - minimum double in size of your Access database on that Disk.
3. Close the .mdb file related to .ldb file before you delete the .ldb file.
4. Then Run the Compact and Repair tool
Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?
This will SOMETIMES serve to rescue most if not all of the corrupted entities .
You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!
Under the pages tab in the Database window is a wizard that will walk you through creating the page. You can then copy the code or tweak it as you need to. If you do this and want to continue to mange using forms however, you may want to split your database. that means load all the forms in one file and link them to the tables in another. There is a tool to do this automatically under TOOLS > Database Utilities > Database Splitter.
if the form "products" really exists, then your office 2007 security settings are not allowing to load macros. Try the following settings:-
Office 2007 has some security settings disabled by default to prevent any harm to your system.
go to trustcenter settings(click the office button at the top left of the office 2007 screen then click Access options, then select Trustcenter, then click trustcenter settings.)
In trustcenter settings, select message bar then select "Show the message bar in all applications when content is blocked" radio button.
Then from macro settings ,make sure to select "Disable all macros with notification" . Click ok twice to close the settings windows and try opening the file again.
It seems that you have your Database(.mdb) file is created in Office 2003.... thats why you are unable to open it in 2007.... I faced the same problem.... then I came back to 2003 in order to use our database......
have to follow few steps.
1. new database - give any name
--> design table
e.g id, name and file (the datatype of the file should be hyperlink other wise it wont work)
--> enter some records (in file field write a, b ,c)
--> when you put record in file field then click on hyperlink option on top.. (like first record id=1, name=fahad, file=A) select the A and click on hyperlink option on top and give the hyperlink of the pdf file
--> design the form
--> run the form
--> click on desired file
--> it will open
--> looks complicated but its easy
Start, Programs, Microsoft Office, Microsoft Office Access 2007.
Click the Office Icon in the top left corner of the Access 2007 window.
Click New, locate where it says "Blank Database". In the field labeled "File Name", type the name of your new database. To choose a folder on your computer to save the new database, click on the folder icon next to the "File Name" field, and select the folder, then click Ok. Then click "Create".
Please let me know if this helps or if you have any questions.