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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.