I have a workbook that's generated form a website and needs to be imported into Access 2000. However the workbook is created, Access will not import it with a message something like "incorrec...
Scenario:
We need to better track our phone lines and their extensions at the block level. Then take that data and make a dynamic phone directory for the company to utilize.
To do this, we...
How can I use Instr() to find the location of the first alpha character in a string?
For example, can I use some sort of bracketed group, letters A-Z, in the string expression sought area o...
My client has an Access 2003 database (mdb) that has been in use for several years. All customer workstations have Office 2003.
Several fields in the database store objects (word documents/...
I have the following:
=IF(DATE="","OK",
IF(DATE<25,"MONDAY"
,IF(DATE<35,"TUESDAY",
IF(DATE<45,"WEDNESDAY
",IF(DATE<75,"THURSDAY"
,IF(DATE<88,"FRIDAY"
,IF(DATE<92,"SATURDAY"
,"WEEKE...
Hello -
I am trying to open an ADO recordset using a parameter query and am having problems getting it to work. At this point, it is becoming apparent to me that I need another set of eyes t...
I am struggling to import excel files into an existing Access table. I have designed a database to automate certain recurring (once a month) processes within the company. Currently it is worki...
Hello,
I am trying to connect to SQL from access via an ODBC connection without creating a system DSN through admin tools. I need the full code to create the connection when running a macr...
I tried to use "A:P,T:U,W:X" as my range in DoCmd.TransferSpreadsheet acImport but I got the error:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ntblNewItems", GetInputDire...
I have an access database that contains a table (table is Transactions_tbl) for all transactions for all customers. I need to run a query that will pull only the most recent transaction (fiel...
Hi,
Wondering if it is possible, and easy(!!), to link to, or import data from Active Directory into MS Access 2007?
I've google'd this and have found some references to VBA, but ideally...
Hi,
How can I multiple select items in a ListBox without knowing the Index?
Any workaround?
I'm using MS Access 2002.
tblCApos contains unique records (Cusip) with one financial model's opinion of YTM, Duration & Curr OAS...tblCAaudit contains multiple instances of CUSIP for each PORT (portfolio) it exists wi...
I am working on an application that could use the Bill of Material database methodology.
The application consists of items, sub items, and sub-sub items down to 5 levels.
Each item has an I...
The question has two parts
1) Corrections for an update query
2) Advice on a delete query - Is it possible to delete records no longer relevant in the Files tbl
1)
I have two tables Fi...
Hi, I don't understand what is wrong in there,
If Not IsNull(txtID.Value) Then
Const conNumButtons = 8
Dim con As Object
Dim rs As Object
Dim stSql As St...
Need to pass a SQL query into a list box when a record is selected from an adjacent list box. On the trigger even, the below SQL query resuls are sent to a list box with the RowSource command...
I have a Form (frmSortByLocation) created from a Query (qrySortByLocation).
I have this Combo Box (cboSortByLocation) Which it's Row Source is a table of locations (tblLocation), Example SoCa...
I have a combobox which is a limited list from database query. The problem is when the user select "Quickly" an item from this list and try to execute the treatment I will got an Intermittent ...
I have a group header on a report which I only want to repeat for the detail section. We have a separate Group Footer section with its own header and detail.
How can I get a Group Header t...
I have this code below that I'm trying to use to build a conditional/dymanic query of a table. It works great until I input a number to search by. Then I get "3464 Data type mismatch in criter...
Hi Everyone-
I am fairly new to developing with VBA and I am stuck on a problem. I have an Access database that current runs a screen scraping process to get data. The screens are being retir...
Hi Experts,
I have a form where the user selects from a combo box 1 of 3 values; H, M, or L. If the user slects 'H', I want to set the font color or another textbox (yet to be filled in) wit...
I have 6 excel files, that are in the same format, that I have to import into Access each month. Can I write a macro to import all of the files into Access as individual tables or even as a m...
Hi,
Sorry if this is long winded, but im trying to give you as much detail as possible, so that you understand the problem better.
I have designed a database in access to use with my VB....
