Search results

Thank you so much for the details explanation MajP. I needed the explanation, so I can continue moving forward, and simplify my code even more. thanks again! Rick

Thank you so much MajP! :) it works now. can you explain the openargs form_load event of the popup? so when I click on the add item, I'm opening it with the form ID as reference, so then when the popup opens, the load events catches the variable sent with me.ID? If Me.OpenArgs & "" <> "" Then...

Thank you for your help! I can get it to work the way you setup the form as well. The problem is when you set the PO header form to "Data entry: yes", then the problem of not showing the new record in the POdetails persists after closing down the popup window. i figure out a way to do it, but...

Thank you for your response. I did what you explained, but still doesn't work. I have attached the test DB, I'm testing this out. Rick

Hello there, I hope everyone is doing well. I've been trying to find a work around to add a record into a sub-form that is not by direct input into the sub-form, for example: I have the Main form that has the ID (autonumber), the sub-form is related via the MainID (ID_FK) and it has is own...

Thank you Paul! Now it works the way I need. Have a nice night! Rick

hello, thank you for the response. I tried the parenthesis as recommended and still doesn't do the proper calculation, I tried: Me.qaTest.Value = Nz(DSum("[QtySold]", "tblSalesOrderHistory", ("[SL_FK]=" & Form!SL.Value & " and [TransactionType]='Sale'" &) " or [TransactionType]='Exchange'")...

Hello friends, I need a hand with a DSUM calculation I'm trying to do, here is the test code: Me.qaTest.Value = Nz(DSum("[QtySold]", "tblSalesOrderHistory", "[SL_FK]=" & Form!SL.Value & " and [TransactionType]='Sale'" & " or [TransactionType]='Exchange'"), 0) I'm trying to add [QtySold] only...

Thank you everyone for your points of view. I went for the calculated field option, I think it simplifies the handling of the problem. Have a nice rest of weekend! Rick

Good point. fair enough, thank you! ill start working on the solution based on that opinion. Rick

Hello friends, Happy new year 2021! I hope this year is much better than last one, I don't think it will be really hard to make it better :LOL: Here is my finding while troubleshooting/testing. this is Inventory management DB - MS ACCESS 2016 I have tblSalesOder connected to...

Okay, friends. I'm not sure what was the problem, but here is my solution: I changed the format to portrait. Yes, that's it. Thank you for everybody that tried to help. Best regards, Rick

I have attached examples of the behavior. I changed font again from google. The label size is 2.3inX3.9in

Hello, thank you for your suggestion. I tried that, still eats part of the barcode making it useless. Rick

Hello, I followed the steps, but still has the same problem. I have some old labels that printed fine, and I can tell by comparing at the barcode pattern that the new print out are still missing information. Rick

thank you, so you think the font was the problem? Rick

Hello my friends, Here I am again asking for some support. I'm printing a label with the idea of using a barcode scanner, the source for the label is a Query. I'm using = "*" & [Field] & "*" in a unbound textbox, with the font Free 3 of 9 or also known as 39. When looking at the layout view...

I just wanted to report that I got it to work by adding a me.refresh just before closing the form where the user inputs the data. Thank you for your help :) Rick

I added a "do while loop" to recreate a wait time, and still doesn't work. do you know other way of inserting a delay?

haha, might as well try it :D. further context : The information I'm trying to print is loaded in subform inside where the user inputs information of the item being received, then after clicking receive item button, information gets transfer inside the subform, the idea is that subform is to...