|
|
Query Performance - Linked Tables by
MDW
I've got Access 2000 linking to SQL Server 2000. I unfortunately don't have any control over the SQL Server tables in terms of indexes etc.
I've created some...
|
|
3 |
414 |
|
|
|
Append query fails but no error produced by
Dale Fye
Drew,
A couple of things you might try:
db.Execute strSQL, dbFailOnError
I cannot remember whether this kicks off an error that can be trapped or...
|
|
1 |
452 |
|
|
|
Creating a FAST updatable query by
Leif
I'm trying to create a query to supply a recordset for a
form. The fields are all from a single table, however I
only want records where one of the fields (an...
|
|
5 |
478 |
|
|
|
Using Start Date and End Date in Query by
ChuckW
Hi,
I have a form for inputting data which includes text
boxes for the StartDate, EndDate and CustomerName, number
of new customer and number of existing...
|
|
5 |
695 |
|
|
|
Efficient queries with SQL backend by
wheeel_o
I am using a Postgres backend and Access for my frontend.
When I run a query in access, does the entire table which i am querying get transferred over the...
|
|
1 |
734 |
|
|
Queries by
myheadache
In my table I have a field named Cause 1 and a field named
Cause 1 Hrs. I want the query to look at Cause 1 (which
is a Yes/No field) and if the answer is Yes...
|
|
4 |
146 |
|
|
|
|
July 19th, 2004 10:59 PM
by bazango 
|
6 |
517 |
|
|
|
SQL Insert SYntax by
Todd Huttenstine
Hey guys
Ive been struggling with the below code for an hour. I
keep getting the error:
Syntax error in INSERT INTO Statement.
Dim objConn As...
|
|
2 |
295 |
|
|
|
IIF by
Pete
Hello,
I would like to enter two criteria in a IIF statement. I
don't know if this is possible.
Example: IIF(=1 or 2, "YES", "NO")
I cannot get this to...
|
July 19th, 2004 08:12 PM
by Pete
|
2 |
106 |
|
|
|
query to count multiple records as one? by
Tom Ellison
Dear Linda:
You might try the query I suggested to see if it is a step along the
way. Adding multiple columns for the procedure codes would be
possible in a...
|
July 19th, 2004 07:38 PM
by Linda
|
3 |
225 |
|
|
|
Hours greater than 23 by
Claire
Hi:
I need my end user to be able to input total hours of more than 23.
My database keeps track of total hours authorized and then based on duration
of...
|
July 19th, 2004 07:30 PM
by Claire
|
2 |
105 |
|
|
|
update records by
Mjohnson
Say I have a table (with lots of records) and I need to
assign A, B, C, and D to a record going all the way down
the file, what is the easiest way to do it. I...
|
|
3 |
315 |
|
|
|
|
|
1 |
106 |
|
|
|
append query to a table with autonumber by
Rob Guest
Could someone tell me if there is a way to use an append
query to enter data into a table where there is a
autonumber field. The autonumber field is used as a...
|
|
2 |
96 |
|
|
|
|
|
2 |
82 |
|
|
|
Query Help by
Daniel
Hello, I have made a database for resource management. I am tracking
vacation requests by employee ID number (Social Security number). I have a
table setup...
|
July 19th, 2004 01:07 PM
by
|
1 |
99 |
|
|
|
crosstab query filtered by form by
mj
hi. i have a report that has a crosstab query as a source.
i was hoping to filter the report by form buy i'm getting
an error saying that i can't do so. is...
|
|
1 |
399 |
|
|
|
Has to be an easier way by
Ed Finley
I am trying to output the most recent date a pilot flew. I have a table of
flights for the company with, among other info, flight date, pilot, and
co-pilot. ...
|
|
2 |
91 |
|
|
|
# of days since Jan. 1 by
mate
i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. ...
|
|
1 |
121 |
|
|
|
'Update Query' Activation Problem by
Chip
Hi, I am just learning ACCESS so this may be an easy
fix.
I have built a FORM that has a button to activate two
2 "update queries" but what i need is the form...
|
July 18th, 2004 11:14 PM
by fredg
|
1 |
88 |
