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!

  • 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!

Search results for query: *

  • Users: Knicks
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. Knicks

    MS Access 2013 late binding to Excel & WorkSheetFunction

    I am trying to work with the Excel object without references to Excel (Late Binding). I am unable to get MS Access to recognize the excel function/method WorkSheetFunction in order to test for duplicates and make a simple background or border color change for the duplicates in a column/range. I...
  7. Knicks

    MS Access VBA to Save Excel XLS as CSV

    I am using MS Access 2013 and am using VBA and late binding (No Excel Reference in VBA) to take an Excel file perform some processes and then Save As a CSV file. Everything works as desired except the Save As portion. Dim db As DAO.Database Dim RS As DAO.Recordset Dim RS2 As DAO.Recordset Dim...
  8. Knicks

    Record sets and looping

    I have a nested Do Unil loop and an interior loop for table defs. I am basically comparing 2 lists and updating a list when the linking fields are the same and a criteria is met. It works as far as making an update. The problem is it only does the 1st record in the loop, so I believe it has...
  9. Knicks

    Looping Through Recordsets and Tabledef

    I have a table that has records with field names as the data that then needs to be matched up with Yes/No fields that uses the same name. So I was planning on looping through the recordset and looping through the tabledef. So in situation below I would loop through the records and where...
  10. Knicks

    Extract Text from Equation

    I have a field where the data is John Smith(4321) Adrian Bellows(5432) William Grey(123) I need to extract the name portion only stripping out "(", ")", and the numeric portion. There is very few examples of where the numeric portion is 3 digits instead of 4 but it would be great if it is...
  11. Knicks

    VBA SendObject and Hyperlinks

    I am trying to get a hyperlink in an email in VBA using the SendObject command. I would like to use a variable as the hyperlink in the body of the message that will change each time it is run. The hyperlink type is toward a network folder that will change depending upon the data. I've tried...
  12. Knicks

    MS Access VBA coding Excel

    I have code that I've created that is super close to working. It essentially loops thru a record set creating query defs and then transfers to Excel and creates a file. Each loop creates the query def, deletes def, and outputs an Excel file. After Excel file is created I open the Excel file and...
  13. Knicks

    MS Access 2010 - TransferSpreadsheet Not Treating 1st Row as Field Name

    I have a fairly simple chunk of code where I create the Excel file and then using transfer spreadsheet have a number of queries put the data into worksheets of that file. I believe I have the settings right but it is not treating the 1st row as field names except in the 1st worksheet created by...
  14. Knicks

    MS Excel 2010 - #REF error

    Okay, once again I find reason to really hate Excel over Access. I have an already created highly programmed Excel workbook. The process was for the user to cut and paste data into the 'Item Tested' worksheet. They were running into difficulty with the column ordering so I decided to try using...
  15. Knicks

    Union Query Error: Multi-valued Field

    Ms Access 2007-2010 format I have imported queries and tables from another database. The query in question works in the original database but when I import it into a new database file the Union query does not work. I have tested the underlying nest queries and they do work. It appears that the...
  16. Knicks

    MS Excel - Keep Formulas in cell

    Excel 2010 An overview of what I am trying to do. I have form that users are going to fill out with a bunch of IF formulas. The formulas are dropping off when the IF statement is not satisfied. I want the users to be able to use the spreadsheet multiple times so I don't want to lose the...
  17. Knicks

    Ms Access VBA to open & edit Excel

    I am using MS Access 2010. I would like to create an Excel worksheet from an Access query and then afterwards have MS Access VBA open the worksheet and lock the first row of column headers and save. End users will ultimately send the file back with data for importing and I want to make sure...
  18. Knicks

    Access 2007 Code to Determine Excel Column Names

    I have a process in place to transfer a spreadsheet into an Access table but I would like to programatically generate the Excel column names prior to transfering to determine if the column names in Excel have changed and cause an error. I have code to determine Excel column count but am having...
  19. Knicks

    Conditionally Format All Fields via VBA

    I have a continuous form with about 20 fields. What I would like to do is conditionally format all these fields with the same rules. Something like: If criteria = p make background = red If criteria = L make background = purple If criteria = Z make background = yellow If criteria = M make...
  20. Knicks

    Do While Loop with Dates

    I am having trouble looping through a date set. Is this something that is tricky? The main issue is I can't get the simplest portion which seems odd - basically setting the begin date variable. Here is my code any help would be appreciated!! I've tried this as a date variable and variant. Dim...

Part and Inventory Search

Back
Top