form with subform (1 Viewer)

Okay that is exactly what I needed.

When I try to enter a payment in the "ORDER ENTRY FORM WITH PAYMENTS" there is an error appearing about the "ADB ORDER #". This error did not appear before.
 
That works great.

I added a column NOTES to the ORDERS table. I added it to the query you created as well.

I added it to the ORDER ENTRY FORM WITH PAYMENTS too. I am having trouble binding it to that column. What should the control source be for that box? I tried binding it to the table and query but it returns #NAME?

Also on the OUTSTANDING ORDERS query, I have the OUTSTANDING field criteria as ">0" yet it is still returning a negative number. It shows up on the report as well because it is based on the query. I am not sure why it would return the orders with a negative number.
 
Last edited:
If you can post a copy of your DB (A2003 mdb format) with the changes that you have made, I would be happy to see if I can help.
 

Attachments

OK. The query is not returning the result you expected because you have put the criteria ">0" in the COMMISSION column. The negative figure is in the OUTSTANDING column. So it would appear that you are applying criteria to the wrong column or perhaps it needs to be applied to both columns to exclude negative figures from both.

The "Notes" column has been added to the table but NOT the query called "ALL ORDERS QUERY" which is the query to which the form "ORDER ENTRY FORM WITH PAYMENTS" is bound. With the query in design view, drag the "Notes" column to the query grid. Save the query. Open the form in design view. Change the Control Source property to Notes and save changes.
 
I feel stupid now. I had fixed the >0 on the other copy but not the one that I sent to you. I had figured it out previously but converted the wrong DB.

I just changed the query that the form was bound to to the new one you created and that fixed the problem.

Thank you for your direction. I want you to know that I am trying to help others with the information you help me with!
 
Thank you for your direction. I want you to know that I am trying to help others with the information you help me with!
I'm glad you got it sorted.:)
I had already noted your involvement in also trying to help someone else. There are people in this forum at all levels of knowledge and ability with Access. Even those of us with limited knowledge can help someone. IMHO that's what it's all about. So, Well Done You.
Mind you don't get addicted. :eek:
 
Hello Bob,
I have been working well with the database and have been transferring information into it. I am running into a slight problem with the paid check box that you created for me. It does automatically check if the outstanding is zero but not if it is less than zero. ALTHOUGH, if I look at the query, the PAID column will convert to "YES" if it is zero or less than zero. I am not sure why it would show in the query but not check on the form. Are you able to help?
 
Perhaps you could post a copy of the db in A2003 format with a little data to illustrate the problem.
 
I deleted everything and inputted 2 orders. If you look in the datasheet view of the VIEW ALL ORDERS query, you will see that both orders have been paid and it says YES in the column. Then, if you look in the ORDER ENTRY WITH PAYMENTS, you will see that Byrd Electric does not have a check mark in the PAID field. It has actually been over paid by $0.01. The query appears to be running correctly because it is marked correctly in the datasheet view. Not sure why the form view is not showing the check mark when the outstanding is negative.
 

Attachments

Change the Control Source property of the check box on the form to "Paid" (without the quotes).
 
Perfect, thank you. I now have about 3300 entries in the Form. It is taking about 30 seconds to open. Is there a fix for that? I don't want it to get worse as more entries are added.
 
IMHO that seems like a long time to get the form open. I have main forms with 7,000+ records that have a subform with 35,000+ records that open in just one or two seconds so I would think there will be a fix. Unfortunately, I can't say that I know what the problem is, or how to fix it. I can merely offer some suggestion which may or may not help.

1) Both forms are based on a queries which have calculated field. These query fields are then used as the Control Source for controls. Perhaps it would open faster if the calculations were done in the Control Source rather than the query.

2) In a split db with multi-users, the opening of forms can be made much faster by keeping a persistant connection and setting the Record Source property of forms and the Row Source property of combo boxes and list boxes with code when the forms open.
You could try this with the attached db, if you can import you data into it.
 

Attachments

I do not understanding what you mean. In my database, the control source, when I look at the field in the form shows, the calculation.

I opened the form in the one you sent and everything has either #error or #name?.

Unfortunately, because of confidentiality, I cannot attach my complete database for everyone to see. I would love to prevent this problem but I don't know what to do. I am sure it has something to do with the link to the Query because when I changed that a couple of weeks ago from on to the other, that is when the problem started.
 

Users who are viewing this thread

Back
Top Bottom