When to use 'after update' and when to use OnChange events ??
Wed, 20 Aug 2008 03:41:03 -0700
Can anyone provide guidance please on when you would use 'onchange' (eg: to
set a date based on entry into a field) as opposed to 'after update'.
Thanks ...
|
Insert new column
Wed, 20 Aug 2008 02:32:16 -0700
Hi,
For example;
In a table i have 50 data. I need to insert a new column so that to keep
track the number of data I have. In that column, how do I key in the number
starting from 1 and up to the end of the data, which is 50. I can't possibly
manually key in those fields in the column up to 50 as time is c ...
|
hi
Wed, 20 Aug 2008 10:49:41 +0200
hi
...
|
Date criteria for a query
Wed, 20 Aug 2008 17:57:05 +1200
To include all records from 2 Months back, not 60 Days,Thanks for any
help..Bob
--
Thanks in advance for any help with this......Bob
WindowsXP..MS Access 2007
...
|
Using Date in SQL Statement
Wed, 20 Aug 2008 10:48:52 +0700
Dear all,
I'm using Ms SQL as back end and create linked table with ODBC connection.
I write SQL statement like below:
SELECT * FROM tblInvoiceMain WHERE InvoiceDate Between #" &
Format(dteBeginDate, "mm/dd/yyyy") & "# And #" & Format(dteEndDate,
"mm/dd/yyyy") & "#"
After I execute, the query returns w ...
|
column sizing in Access
Tue, 19 Aug 2008 18:43:00 -0700
is there a way to have the columns automatically size themselves to best fit
in Access 2007? Seems like such a simple thing shouldn't have been omitted.
Bob Janssen ...
|
I cannot open a Access 2000 database in Access 2007
Tue, 19 Aug 2008 18:40:01 -0700
I have an Access 2000 database running in Access 2003 using a WorkGroup with
a password. When I try to open this database in Access 2007 I get a message
that says: "You do not have the necessary permissions.... etc... contact your
administrator." I have a stand alone computer and I am the administrator as
...
|
|
|
In Hotmail S/R I get error message Ox800cccf4 Cannot get emails
Tue, 19 Aug 2008 16:34:02 -0700
...
|
EMAILS FROM ACCESS
Tue, 19 Aug 2008 16:07:01 -0700
I have a report that is emailed from Access through VBA if it 'qualifies' to
be sent. There are instances where another report needs to be sent seperately
from Access subject to what the 1st report was. I do not want to combine the
reports into 1 email. So, what happens is that the 1st email goes out with no
...
|
How can I specify two criterias in a column based in another colum
Tue, 19 Aug 2008 15:33:01 -0700
I have a query like this:
Base ID - PlannerCode - W-Date
12545 JAXM-06 8/12
12546 BAM-06 8/13
12547 DGM-05 8/12
12548 ATM-05 6/12
the [W-Date] shows all datas with want dates 30 days behind based in current
date
this is ...
|
