Search results

worked like a charm!!! thank you so much!

I guess it gives an error with FindFirst. And this is quite advanced for me, so I don't know how to fix it :(

If I used the Where argument it finds the record but it's filtered. I did not understand the second option you gave me

tried this one too. Still goes to #1

I have 2 identical buttons and one is working properly and the other is not. I have a form (SuppliersListF) that has a button to open another fom (SuppliersInfoF). When it opens I need it to be unfiltered, but also find the specific record I'm asking. However this one will always go to #1 no...

It worked! Thank you very much everybody! It seems I have a lot to learn! 😁

Oh! I just built mine following a tutorial almost step by step and I just tweek it where I need to (like the customer codes pex). But the guy had the total in the subform. Anyway, I'll read on what you mentioned and try to fix it. Thank you

Hey thanks for all that. My proper db is not such a mess. I did this really quickly. 1. I was typing at random and didn't notice. But thank you for pointing out. 2. Yup, my db doesn't have that 3. This is the only thing that I literally NEED to work 4. Did that, hadn't noticed. In my db it works...

I only ever start from blank templates, but I do have the tendency of naming things the same. Anyway, I recreated it from scratch and put some random numbers. The only thing I didn't manage to make it work - heck i didn't remember how - was to synch the detail subform in the order form. But in...

=Forms![OrdersF]![OrderDetailsF].Form![TotalSum] tried it this way as well. Still getting #Error

Ok So I want to refer SubD to SubB. Main forms remain untouched And since the two forms are unrelated I tried this command on the control source of that text box =Forms!Mainform!Subform1.Form!ControlName or properly =Forms![OrdersF]![OrderDetailsF]![TotalSum] But it gives me #Error

I already started reading about the normalization! And that link is very helpful thank you. I don't know how the DSum() is different from the Sum, but I'll look it up. To my problem now, I don't need to store it at the table, so that's not a problem. I'll just reference it on the list. I repost...

My database is in Greek so I'm suppying the picture below with explanations. I have an Order Detail Form and a Order List form. It just so happens that my returning wholesale customes sometimes call me and I need to have that total sum listed in their list. However, the total sum is an unbound...

I typically do, and you are right, I didn't in this case. I just needed a coma and not (). I apologize Do bare in mind that I started about a week ago and I built this monstrocity of a database, so it's not easy for me to understand everything. I do have another question about order sums...

Fixed!!!!!!! Love you all!!!!!

I added the Me.CusoterCode argument part before the Len but I still get the error at the same Right spot Access hates me :(

I understand what you meant. But what should I write as the rest of the argument? Me.CustomerCode again?

I read #10 top to bottom so many times and I copied the code exactly but I don't understand why I get the error :(

I assume you referred to post #11? I wrote that before I refreshed my page so I hadn't yet read #10. But I can assure you I read everything and follow your instructions carefully :(

Wow Thank you so much!!! Ok, questions: I copied it exactly as written and only changed my table names (I use an english version of access but the names of everything is in greek) However, when I try to input a new record I get the error you see below and it highlights the Right part of your...