Recent content by GC2010

@Gasman - I'll have to google to figure out how to use vba to set a printer :D

I have looked at those :) My issue is that if I do ctrl+p to print, and select Adobe no barcodes are printed, if I use the code above acFormatPDF no barcode is printed, but if I select cutePDF the barcode prints exactly as I need.

Oh, I didn't realize Office had a built-in PDF generator. Is there a way that I can "force" it to recognize the barcodes added? I'm using 3 of 9 barcode which is pretty standard.

I am using acFormatPDF to convert a report to a pdf. I have both Adobe and CutePDF installed on my computer. Is there a way I can select which one generates the PDF? I ask because Adobe is not writing my label to the PDF but cute is, so I would need to use cute.

@CJ_London - apology, I am getting ahead of myself here. Let me get a sample datas together and post here so we can all see full picture

I have verified before import by right clicking the column and selecting format cells and selecting Text that in each workbook the column type is set to text. Access must not like some of the data in the column.

I've never done a Cartesian query, I'll have to look that up. What would be sample syntax on an update statement using a Cartesian query?

AH, I didn't think about this route. Sounds quick and easy, and I can then use VBA to change the DataType of userid in the temp table before pushing to the main tables.

Sorry, did not mean to contradict. The constant between different iterations of the workbook are workbook 1 will ALWAYS have headers, name, address, city, state, zip, orderID, userID and workbook 2 will always have userID, orderId, managerID, orderstatus Plus multiple other columns that do not...

I am importing two spreadsheets into access for comparison. I am using this to import the spreadsheets as I do not know how many columns the workbook will have. DoCmd.TransferSpreadsheet Sometimes the workbook will have 20 columns of data, while others it has 8. The only thing that is...

I did do a google search, but my situation is that the sheet already exists and I am not the owner, I am a sharee so not sure if that solution would work for me :/

Is there a way to link a google sheet into Access (similar to how you would link a Sharepoint table or ms sql table) and I can use that as the datasource of an access form?

I am taking over a project that someone else created and I want to understand what the code is doing. This line of code, is it simply finding the last column with data? Dim dColumn As Long dColumn= Excel.Cells(1, Excel.Columns.Count).End(Excel.xlToLeft).Column

Thanks for that advice. I've been dabbling with VBA for quite a few years, but never done anything too advanced/outside the macro recorder. Is there something I'm doing that is causing this code to sometimes leave excel open in the Task Manager/Details wb.Close xlApp.DisplayAlerts =...

yes, I get intellisense. I am sure this is bad practice, but I declare it as a function when I am testing and still working on it, then set it as a sub when I have verified the code works as expected.