Search results

Thanks for your response Plog. I'm afraid I don't know a lot of the programming and you lost me at aggregate...lol. I see what you're saying about it not being done at the table level. That makes sense. Like I said, haven't worked with this stuff in quite a while (and hope I never have to again...

Okay, I'm back, though it's been a while, so hello to everyone, especially all of you who have helped me in the past. Retired, got out of the biz & haven't fooled w/Access for about a year, so it's like learning it all over again. I know I've done this before but lost the database I did it on...

Thanks all!

Duh....no wonder I'm called Lucy! Change the field name in the Caption option of the properties.

Thanks for all the help! Finally got this to work by creating a query and using the Totals function to sum the line totals, then created my form based on this query. Now I am trying to figure out how to change that field name, since it automatically names the field (SumofLineItemTotal) when you...

Mihail thanks for your suggestion about my naming convention. Really never thought of that. Am going to rename all my objects.

Thanks High, Won't work for me as both the frm-Order Details Subform and frm-Orders are based on tables. Hmmm.

I have an Orders form (frm-Orders) that includes a subform (frm-Order Details Subform). The subform has line item totals. I want to be able to sum the line item totals and show the result on the main form, but I can't get it to work. Seems like it should be an easy thing to do. Someone...

Thanks High! That's exactly what I did and everything is well again!

I just want to thank everyone for all the responses! Got the brain train working for me and now I'm moving right along towards the station called Finished!

Thanks RainLover! This is exactly what I did and it works perfectly. I don't know why my brain couldn't remember to do it that way, as I have done it before. Duh!!!:)

Thank you so much for your response!!!!! I am going to try this method as soon as I am able to get back to work on the database and see if this gives me what I want. You are correct in assuming that I want entry person to choose name from drop down list and then automatically populate the...

I've asked about this before but am still confused as to what to do. I am creating a customers and orders database for a client. This client has customers that are companies and customers that are individuals. Now, my method may be completely incorrect, but here's what I did: I created...

I am having a serious mental block when it comes to this. I know I've done it before, but I can't seem to find the old file to look at. Before responding, please keep in mind that I do not know VB, but can insert VB code when written for me (bad girl! bad girl!) So, here goes. I have a...

For some reason, my relationship window does not show any relationships. (Yes, I have added all objects to the relationship window, so I don't know what's going on. I think I have the issue worked out though. Thanks for trying to help me!

Sorry, Gotcha Will post.

Thanks for your response. I have included two screenshots. These two are for looking up the Company (from Customers table) in the Orders table. One shows the actual query, the other the parameters for same. The Customer field is looked up the same way and the screenshots would be exactly the...

I am developing a Customers/Orders database for a client. Some of the customers will be companies with a contact name. Some will be individual customers. So---in the Customers table I have a field for Company, Contact, and Customer. In the Orders table, Company, Contact and Customer is...

Oh boy!!! lol

Hey Debbie! Glad you got that part to work. I did leave out the part about including the delete query...sorry...when I went back and looked at my macro that was my first step. Hope you get it going the way you need it!! :-) Lucy