I have an MS Access application where I send an email out to a customer using Vba code. I use DoCmd.SendObject to email a customer the information.
Everytime I send out an email I get a ...
I have two identical tables - I need to Delete the records in the 'Data' table that are identical to whole record (all the fields) in the Data_Intermediate table
The Tables:
Data:
Date...
Hi Geniuses, Gurus, Experts, et al.,
I want to make sure I understand. There was a question answered before about setting default values when creating a table. It was closed and the expert sa...
I am trying to open an access database from a networked drive and I recieve the message, "Microsoft Access cannot open this file. This file is located outside your intranet or on an unrestrict...
I am in Microsoft Access 2003 and am trying to make it so that everytime a user prints a query it will print in landscape view. I have tried creating a module and putting a command like this ...
Hi all.
I'm working on an Access 2003 query that will display how many working days it took to complete an order.
There are 2 dates: PromiseDate (or BegDate) and CompletionDate (or EndDa...
When designing a table structure, I would like to know what the various data types are used for (long integer, double, single, etc. Can someone give me descriptions and examples?
Using Access 2007 I am trying to create a csv file on my hard drive via an automated export.
The command line is:
DoCmd.TransferText acExportDelim, "product_master Export Specification", "...
Hi - in SQL server I would use this statement:
SELECT RunID, StartTime, ProductID
FROM ProductRun
WHERE (CONVERT(varchar(11), StartTime, 120) = CONVERT(varchar(11), ?, 120...
I have 2 tables that I need for a report. Table one has a Unique ID # and Table to has multiple entries for the same Unique ID # based on a Update Entry field. How can I create a query that ...
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...
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...
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...
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...
Hello ~
I'm receiving run-time error: 3027 - Cannot update: Database or object is read-only on line 122 of the attached code: "rs3.Edit", attempting to edit a record in rs3. (marked: '<<...
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/...
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 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...
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 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...
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...
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...
I'm wondering if anyone knows how I can disable the mouse scroll to prevent users from scrolling into another record in a form, but still allow scrolling within large text boxes or combo boxes...
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...
