|
|
Error 3061 by
.Len B
The following is in the OnOpen event of a form. It is designed to
populate an ocx control in the form.
Dim rst As Recordset, stSelCrit As String
stSelCrit =...
|
November 18th, 2009 12:41 PM
by .Len B
|
3 |
177 |
|
|
Using IsNULL/IsError with IIF funtion. by
Hemi
I've built an expression query to calculate two fields as:
% NCOTH_NEW ORDER RATE: IIf(IsNull(/),0,/)
The issue here is if I replace 0 with text "N/A" the...
|
|
1 |
145 |
|
|
two null fields by
Access WannaBe[_2_]
I have a query that has two fields, and . I want to exclude
records if both these fields are null. what is the best way?
I did create a field
filter:...
|
|
4 |
135 |
|
|
counting totals, but not using "like" by
Scuda[_2_]
Morning all,
i have a pretty simple query totaling up the Incidents for a year. The
field I am looking up is a text field, that has a lookup to another...
|
|
6 |
198 |
|
|
|
|
1 |
144 |
|
|
Check Box Option in joined query by
MattB
Does anyone know how to get check boxes to work in a query where there are
two tables joined? For some reason the check boxes don’t work when there is a...
|
November 17th, 2009 06:22 PM
by MattB
|
3 |
195 |
|
|
Union Query with division by
Silvio
Hello, it would like to join two tables, Table1 and Table2, however when
joining table2 the items listed in that table need to be divided by 2. I
normally do...
|
|
2 |
129 |
|
|
|
|
5 |
290 |
|
|
Creating queries on the fly by
dcrqueens
Hello All,
I am using using Martin Green's creating queries on the fly but I am having
some trouble. Below is the code I am using for the On Click even for...
|
|
6 |
182 |
|
|
Can't insert record by
Mark A. Sam[_3_]
Hello,
I'm trying to Insert a record from a table into itself. The problem is
field which is a Primary Key, autonumber field. If I leave it in
the...
|
|
3 |
167 |
|
|
Append Query by
RedHeadedMonster via AccessMonster.com
I have an append query that is being used to populate a table. I have two
fields that are being pulled from data on the Form that initiates the append
they...
|
|
7 |
240 |
|
|
|
|
6 |
151 |
|
|
|
November 17th, 2009 03:29 PM
by sonofroy
|
8 |
302 |
|
|
|
|
1 |
200 |
|
|
SQL Error Help by
RayToddJr
I have the following SQL:
strSQL = "INSERT INTO taDEFENDANTS(TrusteeDefendantID)" & _
"VALUES(lngTrusteeDefendantID)" & _
"WHERE...
|
|
2 |
120 |
|
|
Count IF by
Tdahlman
I have 2 tables that are related by the field . The database is
fantasy football related, just to keep practicing and learning new Access
stuff.
I have a...
|
|
1 |
122 |
|
|
COUNTIF by
Tdahlman
For an excuse to play with Access 2007, I have created a database with all of
my Fantasy Football league information. I have 2 Tables that are as...
|
|
1 |
122 |
|
|
Make a change to an Update Query by
JLUTHER
I need to make changes to an update query but when I open the desing view it
only shows the field that being updated. How do I view the hidden fields?
|
|
1 |
116 |
|
|
Change an update query by
JLUTHER
I have an update query I need to make changes to but when I open the design
view it onlt shows the field that is updating. Can anyone tell me how view
the...
|
|
1 |
121 |
|
|
|
November 17th, 2009 06:15 AM
by JohnW
|
4 |
146 |