|
|
Trouble with control reference by
Slez via AccessMonster.com
I have a control named "cboProjectMatl" on a form called "frmMainScreen" that
I am trying to reference as criteria in a query, but I get no results. I...
|
|
5 |
141 |
|
|
Conditional Find Duplicates Query Help by
Dave Allen
Hello, I'm trying to build a query that will do 3 things:
1. Find matching names within a database
2. Find matching dates within a database
3. Exclude an...
|
|
1 |
141 |
|
|
Access & Vista by
bethanyperkins via AccessMonster.com
We recently upgraded to Vista and queries that used to run without a hitch
are throwing an error message. The error is Not enough space on temporary
disk. The...
|
|
3 |
108 |
|
|
|
|
2 |
134 |
|
|
add a value to a date by
P Lally
I have a table linked to an ODBC 2005 SQL database. One of the values in the
table is a date stored in the table as "Date/Time". When I try to create a...
|
September 28th, 2009 05:44 PM
by plally
|
8 |
172 |
|
|
MS Access 2007 & SharePoint Performance by
Glynn
Access 2007 does fine connecting as a client to SharePoint linked lists
(WSS3) remotely in certain situations but perhaps someone could help improve
my...
|
|
3 |
122 |
|
|
Uppercase and * in search query by
Wind54Surfer
Hi all,
I am using the following:
If Me.txtDescription "" Then
varWhere = varWhere & " LIKE """ & Me.txtDescription &
"*"" AND "
to search but...
|
|
5 |
100 |
|
|
Slow query by
PayeDoc
Hello All
Why is the query below so slow - it normally takes 30-45 seconds. There are
~4000 records on table and ~100,000 records in table :
surely these...
( 1 2)
|
|
13 |
258 |
|
|
|
|
1 |
114 |
|
|
Extracting Records by
naja
I have a table that contains multiple accounts. each month I have filter
those accounts that I did not received and invoice. Is there a way on a query
that I...
|
|
1 |
90 |
|
|
sircular effect by
Karen
I have to use number 1 -14 in a Column . When reaching 14, numbering must
start at 1 again. Can you please help me with this?
|
|
1 |
91 |
|
|
Boolean data type mismatch by
Brian
I have a public function that does Luhn validation (verifying whether a
credit card number is of valid format). It looks something like this:
Public Function...
|
|
6 |
200 |
|
|
Email distribution list from Access - JCW by
JohnW
Hello all, me again. I have email addresses listed in my database that I
want to be able to click on a button and have this create an email
distribution...
|
|
1 |
92 |
|
|
find orders 90 days past due by
eddieK
Want to create query showing orders 30 60 90 days overdue. would like to
calculate these dates without vba....tku 2003 or 2007
|
September 27th, 2009 10:15 PM
by eddieK
|
9 |
177 |
|
|
sum based on criteria by
Jeri
Using Access 2007, I'm having fits designing a query that seems like it
should be fairly simple. I'm trying to count the number of plant species in
different...
|
|
1 |
93 |
|
|
|
|
4 |
236 |
|
|
|
|
1 |
92 |
|
|
Subject: Need help on Iff Statement by
Aamer
I want to use IFF statement in a querry but so far am unable to figure out
how to do it.
If someone could guide me I will be greatful.
following are the...
|
|
1 |
97 |
|
|
Increment field by 1 on insert Query by
Dale
I want to be able to insert a whole bunch of records from one table into
another table using a query. I need to be able to set/increase the value of a
field...
|
September 26th, 2009 07:42 PM
by Dale
|
2 |
96 |
|
|
|
September 26th, 2009 06:57 PM
by Doctor
|
7 |
177 |