|
|
Lookup field abilities by
Rich
Tell me if I have this straight.
Setting up a Lookup Column in a field to view the real value versus a record
ID is really best suited for the developer...
|
|
5 |
137 |
|
|
|
select records on yes/no fields by
Bob Brannon
Hello,
I am using Access 2000. Can anyone tell me how to specify a criteria in =
a query that selects records from a "Yes/No" field that have an answer =
of...
|
|
3 |
127 |
|
|
|
Union Query by
Don S.
I have a database for budget purposes in each record has a "Notes" field for
explanation. The data is accepted into the form and table without any
problems...
|
|
2 |
123 |
|
|
Using Unbound Form to Enter Query Criteria by
cainentm
Using Access2000, I am trying to use an unbound form to specify the criteria
for my query. In the unbound form, I have multiple fields, where any of them
may...
|
|
3 |
201 |
|
|
|
|
|
3 |
179 |
|
|
|
Delete Query by
neeraj
I have two queries which I have joined through a field. I am trying to delete
records from one query based on a criteria. I had accomplished this using
joined...
|
|
4 |
137 |
|
|
|
Calculation for tiered discounting by
Carlee
Hi there,
I have a bit of a problem. In MS Excel, I can easily compute a tiered
discount using the mininum and maximum functions. In Access however,...
|
|
3 |
135 |
|
|
|
error -7711 by
TTL
can anyone tell me what this error means and how to fix it?
Thanks
|
|
1 |
154 |
|
|
|
Expressions by
Pompey_Boy
Hi can anyone help with this:
I'm trying to use an IIf Between and And statement to work out
curriculum levels ie if between 1 and 4 then show '3c' if...
|
|
2 |
101 |
|
|
|
Striping a common word from a field by
JohnB
Hi.
Im working on an A2000/XP mdb which has a field containing entries like
"Maths Mentor", "English Mentor", "Music Mentor" etc. The second word is
always...
|
September 13th, 2005 01:03 PM
by JohnB 
|
2 |
115 |
|
|
|
DISTINCT vs GROUPBY ? by
Stef
DISTINCT vs GROUPBY ?
Hello all,
I'm trying to figure out if there is any difference of performance using
either
GROUPBY or DISTINCT in the following...
|
|
5 |
180 |
|
|
|
|
|
2 |
235 |
|
|
|
Problems with Delete Query by
MarkS
I am confused with the following Query. I would like to delete all records
where the ITNO, PO, Line, and Vendor fields are the same in two tables.
DELETE...
|
|
4 |
164 |
|
|
|
Albert D. Kallal -WordMerge20 by
Stephanie
Albert,
Thanks for making your WordMerge20 sample db available- it's very slick! I
have a question about chosing a query. All of the queries that I'd like...
( 1 2)
|
|
11 |
243 |
|
|
|
executeUpdate method does not load data by
Naveen
Hello
I am using the JDBC-ODBC bridge from Sun to load data into an Access
database by calling on the executeUpdate method of the PreparedStatement
object.
I...
|
|
1 |
93 |
|
|
|
Microsoft Access has encountered a problem by
tCannon
When attempting to run a query, I keep getting the error message Microsoft
Access has encountered a problem & needs to close. Sorry for the
inconvenience" when...
|
September 13th, 2005 04:31 PM
by tCannon
|
0 |
154 |
|
|
|
too few parameters - Sub Query by
Dianna
Hi,
I am running a query which references a subquery. the criteria in the
subquery is set to a value in the form (Forms!Results!cboSeason)
I am receiving...
|
|
4 |
155 |
|
|
|
Form based on Query by
RTimberlake
I have a form that is based on a Query. Since I have based the form on the
query I can no longer enter information on my form. I am stumped. How can I
base a...
( 1 2)
|
|
10 |
274 |
|
|
|
Subtract days from Left(Date(),5) by
consjoe
I need a spreadsheet to generate 5 days before the anniversary date of when
the contract was issued.
Example
I have an Issue_Date of 10/10/2002 and I want to...
|
September 13th, 2005 06:35 PM
by consjoe
|
6 |
144 |
|
|
|
|
|
2 |
177 |
