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?
- 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.
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.
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.
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