I have an access 2003 database with 3 subforms with scroll bars that won't scroll beyond record 82 of 102 available. If you could see what you were doing adding records would still be possible, and checked against the related table which will contain the new record. I have needed input directly into the table so far.
Is there a property that needs to be changed or could this be a system or hardware problem?
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US. click here to Talk to a Technician (only for users in the US for now) and get all the help you need. Goodluck!
- 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.
Why to depend on anyone else suggestion. You may download one of the best access recovery tool which will repair your inaccessible access database file. This tool work on windows 10 & below versions also best thing is that free version of this tool will preview all your records after repairing your database. So you may preview your database and can easily review that your data is recovered and to export it you have to use full version. Try this access recovery tool. Access Recovery Tool Repair and Manage MDB or Accdb Database Files
You say corrupt, in what way exactly? Do you get any specific error numbers/messages?
Have you tried Access repair program? Compact and Repair. If not, use it. But ensure that you made a backup, it is necessary because all the recovery tips can make the damage even worse.
Also try Jet Compact Utility. This tool created by Microsoft and it is much like Compact and Repair, but more successful in repairing.
If no one of above advice helps, then perhaps you need more powerful solution. In this case try to run a good third-party. I would recommend Recovery Toolbox for Access. It must help you. https://access.recoverytoolbox.com/
Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.
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.
Sure, Assuming that the field types used offer that option, and most do, but memo may not.
While in the table view mode go to the design mode. Once there look for field length option, and make your change. Be prepared to have existing data truncated to the new max length. You have found out that the datasheet view is the quick and dirty way to update table fields and it uses the properties from the table design.
Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!
Hi Raul from your description it is very unclear what you are trying to do.
First we need to know what information is on the first form, second unless you are trying to do a subtotal of all orders in the subform there is no real need for you to create a subform.
Now if you are trying to create a subtotal form for all records, you will have to set it up in the record source of that subform with group by:
1. Right click on an empty space on the subform
2. Click on properties
3. Choose your table(or query) which is the record source of the main form.
4. Select Payment and items(or what ever you are trying to calculate).
5. Press the group by button
6. In totals instead of group by choose sum.
7. Exit and save
8. Now when you will select the control source you will see "sumofpayment" etc... just select them for each textbox.
9. To create the third text box you will have to use the Expression builder and just do [textbox1]-[textbox2]
* for some reason the nz function does not work in this case.
I hope that helped you I will be able to give you a better answer if you give me more details...
Let me know what happend