Search results

I don't know what happened. I posted the DB 4 hours ago but it only seem to go through now. Thanks for the replies and advice I appreciate it. I will try MajP suggestion. The spaces in the field names are not by my design...Too many cooks!

I know (I actually don't :)) it is somthing stupid. I had this DLookup working but for some reason now it isn't. When it was working I had me.txtSerial, but with tiral an derror and other fourm suggestions it has changed to below. If DLookup("[Serial Number]", "[tblPassed]", "[Serial Number]...

Thanks again for all your help with this.

Thanks June7, Only spotted your repliey after I replied to arnel

Thank you, works perfectly now.

Hi arnelgp I found an issue with the loop, that I hope you can help me with. If the total order quantity equals the box quantity, the total number of boxes should be 1 but the loop is adding +1 to the total number of boxes. Code is perfect if the qty in the last box is an odd number. Hope...

Ahh arnelgp, just when I had my ugly code written! :) I prefer your way much cleaner, I just couldn't get it to work when I tried, more than likely where I was putting my operators. Thanks for this, its a great help.

Not the prettiest of code, but got this to work i = 1 Do Until lngTotal < 1 lngContent = min(lngTotal, CLng(Me.txtBoxQty)) CurrentDb.Execute "insert into zzTable (content, label) " & _ "select " & lngContent & ",'Box " & i & " of " & Me.txtBoxes & "'"...

Back again, Just wondering arnelgp is it possible to modify your loop code to insert fixed data from the form I am running this off? I want to add 5 or 6 fields to the table, barcode, customer name etc etc. I tried adding it into your code but keep getting syntax errors. I also tried a 2nd...

Jdraw and Arnelgp, Thank you for your quick responces. I am nearly afraid to say how long I spent at this. I am spoilt, code and a working database. Thanks again.

Good afternoon. I am hoping some one can help, as I am at a complete loss. I have tried searching for this, but its not the easiest term to look up as it pulls results about counting combo boxes etc. I have being trying queries and count loops but with no success. I am trying to create labels...

Thanks for getting back to me. Still couldn't get it to work. Ended up using a loop. Do Until intPrint = Me.txtNoLabel DoCmd.OpenReport "rptCard", acViewNormal intPrint = intPrint + 1 Loop

Hi, Hope someone can point me in the right direction. having trouble coding. Have a text box on a form (txtNoLabels) that determines the no of copies of a report to print. The problem is I cannot get the report to print out the number of desired times using DoCmd.PrintOut Even if I replace...

My bad. June7 you are a star. Thanks you so much for your help with this.

Hi June7, Thanks for taking the time to help. Just wondering about query1, it is not displaying all my records. What seems to happen is if there are 2 or more rows with the same po the query only shows one result. Regards and thanks, Poco Table PO OrderNo PO P1/1022 11266 PO...

I do and increment the number if the po number changes.

I hope someone can point me in the right direction. Not really sure what sort of function I need. I have a table with order numbers and po numbers. Some of the order numbers can be matched to one or multiple po numbers. I am trying to group orders with the same Order number and po number to the...

I know this is an old post, but I tried the code and was having some issues with it and Outlook 2016. The first error was stopping at .To = rsEmail.Fields(7) Thanks to Pauls post on http://www.accessforums.net/showthread.php?t=57490 I got the code somewhat working. I then started to get errors...

Sneuberg, Can you tell me how I can create a file from your code? I am not sure how I should use it. I inserted it into a module and tried to call it using an event procedure, but had no luck. thanks Poco

Doc Man, Sneuberg, Thank you for getting back to me. I could be snookered alright as the application creates the image on the fly and stores it into the table. In the application you can view the file but I was hoping to do it outside of the application. The application is very customized and...