Search results

I tried your recommendation, still the same issue. When I run the code without break, the report prints blank, when I add the break to analyze the code, prints with the information. Rick

Thank you for your recommendation. I'll try in a bit and report back. also, whats the difference between your method and the one i use? Best regards, Rick

Hello there, yes, I 100% agree with your observation. I had a similar issue when I tried printing the barcode report, but then I move the code to a lower section and it worked. In this case, how would you add the timing, is there a function that allows that? Please let me know :) thank you as...

Hello friends, I hope everyone is fine. I'm having a problem when printing a report after processing a receiving goods. The idea is to print two reports, one of them is a barcoded label(no problem), and the other is a report summary of the item received into inventory, this is the one printing...

Programming is about efficiencies. I'm changing my ways then. got it, thank you! Rick

lol, yep it was the space between the 2 and where. thank you Gasman. what about the the other question? is there any difference between doing a Currentdb.Execute and the dividing the code in smaller chunks? - is it just preference, best practice?

Dear friends, I hope you are doing well. I've been running into a syntax issue when executing a update statement on VBA. The line in discussion: CurrentDb.Execute "UPDATE tblPurchaseOrderDetail SET lineStatus_FK = 2" & "WHERE [IncomingID]=" & IdLine & ";" lineStatus_FK is number (connected...

great idea! let me try that. thank you! Rick

Hello DBguy, Thank you for your prompt response. I tested that option, the only issue I ran into with that is when running the query(tblOrderDetails) to print the order, the expedite line doesn't come up since it doesn't have the condition listed...I had added a "---" in the conditions table to...

Hello all, I hope everyone is doing fine. I have an open question regarding orderTbl and OrderDetailsTbl. The tblOrder is pretty straight forward with the usual requirements, Supplier name, order date, etc. the table has an Autonumber as well. The OrderDetailsTbl table (connected with one to...

Thank you Mike Krailo. i just found information in stackoverflow plus your recommendation have made me rethink the table structure. I think i know which way to go now. here is the info for reference: Existing comments all contain good information, but it can be useful to put it all together...

hello theDBguy, no that im aware of, im using plain access 2016. I just posted some picture for better context Rick

Hello all, i have a quick question, I'm playing with a database trying things and i came across something that i wasn't expecting, here is the issue: i noticed that ms access provides has an option to generate a custom autonumber, so i switched on (input custom sequence)to try the...

Hello everyone, i just wanted to share the solution since I just figured it out, not sure if to call it rookie mistake, I might not be the only one out there that might have had this problem before :LOL: Solution: Make sure to add your text field in the actual report footer of the report, I...

Hello All, I hope everyone is having a good night or good morning, depending on what part of the world you are :) I have the following problem that I've been trying to fix for at least a few hours. When I print a purchase order report from the PO form, the report shows everything but the...

Thank you! Rick

Thank you for your response. How can i do that? maybe it will take care of the JS problems. Rick

Dear, I hope everyone is doing fine. I wanted to pick your knowledge regarding the Access web browser object that comes in Access 2016. I'm currently using it, and it works until I go into a more JavaScript intensive websites and thats when the problem begins. I start getting this famous...

No, its not for the purpose of the report its running, so date is the key in this case. Thank you for your help! Rick