|
|
cannot delete from "specified tables" by
NewtoComputing
HI.
I have used an SQL union query to join 2 tables and created a table from
this query.
Then i've used a totals query to identify duplicate records based on...
|
|
3 |
209 |
|
|
Table not available for Append query by
Mo
Hello All,
Using Access 2003.
I have a strange situation when I create an append query. One of the
tables is not available from the list of tables that is...
( 1 2)
|
May 5th, 2008 04:22 AM
by Ruth
|
17 |
293 |
|
|
Generate table by
Access Newbie
I have a large database of patients that I have set up a query to only select
patients in a specific floor. I want to create a table/form in Access OR...
|
|
1 |
165 |
|
|
Shortcuts to Desktop by
Cathy C[_2_]
In Access XP I was able to create shortcuts for various database objects to
the desktop so a user could immediately bring up a form or report. I
upgraded a...
|
|
2 |
124 |
|
|
SendKey???? by
[email protected]
I have tblAgency with frmAgencyDetails for viewing the details. Most
of the fields are locked for editing as people were overwriting
certain fields. I have a...
|
|
1 |
122 |
|
|
|
|
3 |
183 |
|
|
|
|
2 |
168 |
|
|
Invalid SQL Statement in VBA sub by
JCIrish
The following code is in a query, written in a New Blank Query, not using the
Grid. The code when run yields "Invalid SQL statement Expected "DELETE",...
|
|
9 |
252 |
|
|
input box to update query by
Carlee
Good Day,
I have a form that is linked to a query. THere is a search combo box that
the user can use to select a specific record and view the details of...
|
May 3rd, 2008 08:12 PM
by Evi
|
1 |
214 |
|
|
Transactions and concurrency by
Michael Weber
Hi.
I was wondering how Access ( 2000 an onworth) are handling
concurrency issues when performing transactions.
( If I am in the wrong newsgroup please point...
|
|
2 |
106 |
|
|
color column in datasheet view by
freckles
I'm using Access 2007. I have a query that I print from datasheet view. I
need to draw attention to a specific column. When I try to change the
background...
|
May 3rd, 2008 04:54 PM
by Evi
|
8 |
215 |
|
|
Duplication of query by
AJRoad
I have two tables: Customer Orders: fields are Customer Number-autonumber,
First Name-text, Last Name-text, Price-currency, SKU-Number.
The other table is...
|
|
2 |
94 |
|
|
Update query Criteria help needed by
Dave
I have a field in my table that is text and has any of these combinations.
AM
PM
AM/PM
I want to run an update query dumping certain fields (Including the...
|
May 3rd, 2008 12:31 PM
by Evi
|
2 |
94 |
|
|
|
May 2nd, 2008 10:05 PM
by Evi
|
6 |
127 |
|
|
Duplicate data in query by
Beth Eadie
I am creating a database to compare about 5 different tables (we will name
them Table1, Table2, etc). I created a query to compare via Building Number
(Each...
|
May 2nd, 2008 10:05 PM
by Evi
|
9 |
113 |
|
|
Syntax Question for Multiple Joins by
GaryJ
Hi folks,
I'm using Access 2003. I have a table that includes foreign keys to several
other tables. I'm trying to write a query that will pull data from the...
|
|
6 |
104 |
|
|
default query result by
stickandrock
I have a query that counts on a field. There are no matches in my critera so
it results in a empty output. How do I show a 0 in the result if no records...
|
|
1 |
102 |
|
|
DSUM Error by
NeoFax
I am trying to create a query that appends records to a table based on
the remaining percent to 100%. I have records that have the percent
build complete on...
|
May 2nd, 2008 09:00 PM
by NeoFax
|
4 |
109 |
|
|
|
|
4 |
131 |
|
|
|
May 2nd, 2008 08:09 PM
by EllenM
|
0 |
113 |