Recent content by T. McConnell

Sorry for the late reply, I work 2 jobs and trying to do this in between kind of stinks lol. So basically what I have is a spreadsheet that gets loaded into tblMain that has all the information of work orders for each truck. Before this I never knew a good way in implementing a a price to update...

Greetings all, I have a question to see the best way to go about this. I thought I may have found the answer through a different page on here, but lost the link to it (stupid phone) and now I can't remember where I saw it at. I have a table (tblMain) that has on a daily about 700 to 1000 records...

@arnelgp, this is the same database you helped me with in the truck log one. I'm using the import spreadsheet function to pull in the excel document. I've labeled the column as text in excel, and the column in the temp and main tables are set to short text, however when it imported the the...

Good evening, I have an excel spreadsheet that I import to a table that has item numbers, some of the item numbers will contain an underscore in them. When the spreadsheet gets imported it creates a table with import errors which says conversion error and it happens on the ones with the...

You guys rock!!!! I love this forum as it has helped me so much and lots of the users here who keep this forum going. Thanks again for all the help on this matter. I'm going to button up a couple of things and if everything goes good I'll go ahead and close this as solved.

Ok, I am an idiot sorry, I saw the correct info. One thing I am getting an error now trying to open the report Truck Log it gives a parameter error asking for tblMain.TruckID which is a valid field.

This issue pertains an earlier reply above with getting the error "Query is too complex" I looked at the Query tied to the report and removed the Criteria in both the item number and model number fields as maybe it was trying to filter out too many different items not needed in the report...

I can try and get a screenshot of it and upload it. What's weird is I can get that code to work for a different field, but for some reason that field won't adjust the font size when equal to 18 or greater than 9 etc..

I actually had tried this, when this code is in place or not and if I have a 10 digit or more number in the field, that whole row is blank on my report. I have it set to allow to grown and shrink to yes and as well as to no, so not sure why it's being dumb. I don't think I have any validation in...

Ok, so I think I have a pretty good thing going, one snag I've ran into is sometimes the fields will contain text that will cut off in the text boxes, I know there is a way to shrink the text based on length of the textbox and make it fit. This affects one field the most which is the order...

Once again, thank you for the help. I think what I am going to end up doing is just run with opening the Report up with all showing. However I tested your one sample I think you posted in Post #12. What is weird this is doing what I need, however I uploaded our actual file that I would be using...

Yes, it is setup to open as acViewPreview on the button.

One last thing, I noticed when I use the main form to open the report filtered by a specific date and truck, it only displays the 2 records again and not the one with the lines, if I open up the report normally, it displays the additional lines correctly. Any suggestions?

@MajP and @arnelgp Thank you both so so so much, as always this forum has been so helpful. And thanks to everyone in this thread for their assistance, this is finally what I was trying to accomplish.

Here is my Union Query code SELECT tblMain.DateText, tblMain.UniqueID, tblMain.OrderNumber, tblMain.DeliveryDate, tblMain.TruckID, tblMain.StopNumber, tblMain.CustomerName, tblMain.PONumber, tblMain.ItemNumber, tblMain.ModelNumber, tblMain.Qty, tblMain.EToteNumber, tblMain.Trucks...