Let’s say I’ve got 3 product description fields with the values AC-120 XXX, AC-120,CCC and AC-120 BBB. How would I get that information from a table using only AC-120 as my search argument? I’ve tried using the subStr function but that won’t return any values either Answer LIKE is very appropriate for this comparison. However, MS Access uses different wildcards
Tag: vba
How can I get the last date of different activities in a access table?
I want get the last date of each service. I would like to achieve the following: I tried this but it just get the record when the selected service have the last date Answer I think you want:
VBA SQL update/insert to local table using values from form
I am trying to update a row in a local table stored in access (or insert a new row if that ID doesn’t already exist) using values populated in a form by the user. I am writing it in VBA using SQL. …
‘CREATE TABLE’ generates Run-time error ‘3290’
I have a syntax issue in the first CREATE TABLE statement. I’m receiving the following VBA error: Run-time error ‘3290’ The goal is to move the distinct data to a new table dependent on values in …
Transfering Data with VBA(Excel) to SQL Server but avoiding duplicate column?
My main objective is to transfer some data from excel to SQL server while using vba but in the process I would like to detect and avoid transferring some duplicate month columns. This is what i have …
VBA Function/ Code – Convert Dynamic Column of Data into Text String
I’m creating a tool where users can query an ODBC through excel. I need a function which will look at a column of item id’s which the user has pasted in and then create a text string which can be used …
Error 424 object required after NULL SQL query
I am running some EXCEL VBA code to update the contents of an ACCESS database table along the lines suggested here: IF @@Rowcount = 0 — SQL Syntax Error in Access . When I execute the SELECT query, …
How to update a third table with the result of a select inner join of another two tables
I have an access data base with three tables named DD, Export , and RPL I have the result of a inner join betweent EXPORT AND DD which is working fine Now with those results I want to update a third table RPL which is currently empty but has those fields to be populate for example RPL.[Hotel ID] should be
Carriage Return in Table Header
I’m writing an Excel macro to pull in data from another Workbook. I don’t have any control over that workbook, which is a shame because then I could fix this issue at source, as it is i have to work …
How can I include a “Select All” option in my combo box?
I have a combo box that has the list of my distributors, when I select a distributor in the combo box I have a sub-form that list the transactions of that specific distributor. Now I want to include a “Select All” option in the combo box that will display all the transactions of my distributors. I tried to do it