Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Knicks

  1. Knicks

    Nested Column (Excel, CSV) : How to extract just the metadata or column names within a column of data

    I am working with some complex data that originated in JSON format that I am downloading from Databricks into EXCEL format. What I am trying to do is parse out the Column names from an individual nested column. Basically something like this, The Excel file has multiple columns but a single...
  2. Knicks

    Microsoft Access VBA Coding to Excel Password Protect Fail

    I was able to see the 2 sheet names as it looped thourgh. It fails at WS.Protect And generates a Run Time Error '91' Object Variable or Block Variable not set. This is a different error than I have gotten in the past
  3. Knicks

    Microsoft Access VBA Coding to Excel Password Protect Fail

    I tried to super simplify it to see if one could loop through the Worksheets to apply Protect. This still generates an ERROR 1004. I also tried adding the qualifier WB.ActiveWorkbook.Worksheets to see if that would help but it generated a different ERROR 438. This seems fairly straightforward...
  4. Knicks

    Microsoft Access VBA Coding to Excel Password Protect Fail

    I just ran a test. It has something to do with the ADDED worksheet from the 2nd query making it fail. They wanted additional data on the 2nd worksheet and I was going to add in the various formatting and protections using the first part as a template to do the 2nd worksheet...
  5. Knicks

    Microsoft Access VBA Coding to Excel Password Protect Fail

    The Protect Worksheet was working when I had created the Excel spreadsheet by manually clicking the export button on the ribbon. I needed it more automated so I use the transfer spreadsheet 12xml to get the file in XLSX format. That works for the correct file format and I am still able to...
  6. Knicks

    Microsoft Access VBA Coding to Excel (early binding)

    Thanx, Works like a charm
  7. Knicks

    Microsoft Access VBA Coding to Excel (early binding)

    Microsoft Access 2016 I am trying to create code in MS Access VBA to edit a created Excel Spreadsheet (coming from Access). I want to put a formula in Column N that is basically Column L + Column M from row 2 to until Used Rows. Any help on the Range portion would be appreciated. So in the...
  8. Knicks

    LDB File Chinese Characters (Access 2013)

    Using some of your suggestions, the one user with the Chinese characters showing in the LDB file, I experimented opening the LDB in Notepad (Chinese characters) and then Word, which showed the true computer name. So it seems to be a software reading issue as Notepad was not savvy enough...
  9. Knicks

    LDB File Chinese Characters (Access 2013)

    I am trying to figure out why when a user is in the database their computer ID in the LDB file shows with Chinese characters. As soon as I went into the database as the 2nd user, the Chinese characters disappear and it shows the actual computer name. I don't believe it is causing any known...
  10. Knicks

    Access 2013 SQL and Apostrophes/Commas ERROR 3075

    I assume "" quotes in a name would mess it up as MS Access needs to use one of these text qualifiers.....but the chances of a double quote in a name are extremely low
  11. Knicks

    Access 2013 SQL and Apostrophes/Commas ERROR 3075

    Just ran some testing and that appears to have fixed it. Still finds the duplicates while also allowing the P'ing, LLC in. Thanx for the quick and quality response
  12. Knicks

    Access 2013 SQL and Apostrophes/Commas ERROR 3075

    I have inherited a piece of code that tests for duplicates and the code is triggering error 3075 when encountering apostrophes and/or commas. Here is the SQL code, any help and or direction. I tried isolating the error number but I don't think that is the answer, I would prefer the form entry...
  13. Knicks

    MS Access 2013 late binding to Excel, compare columns

    My error, oddly some earlier code that was not causing any trouble was not coded correctly and only became a problem with this new piece of code. I fixed the earlier section and it is now working. Thank you all for helping and clearing the code that I presented was helpful. I am not using...
  14. Knicks

    MS Access 2013 late binding to Excel, compare columns

    The XLS file is a template from the Gov't and it always has 4 rows of header information, so the actual data starts on Row 5. Its always at least 1 row of actual data starting at row 5. I am not exactly sure where the failure is, I may need to remove the On Error that is more deeply embedded in...
  15. Knicks

    MS Access 2013 late binding to Excel, compare columns

    I have been using MS Access VBA to create the Excel object and perform data analysis from within Access. I have been able to do this successfully when looking at a value from a row & column. I am now attempting to compare a data point in a column to another data point in another column, both...
See more

Part and Inventory Search

Back
Top