Crosstab Date Range Problem
Fri, 4 Jul 2008 04:09:00 -0700
Hi hope someone can help with an annoying crosstab problem.
I have set up a crosstab query to show sales qty to each customer, by month,
over a consecutive period January 2006-July 2008. I use the DatePart function
to look at the sales date and get the month number. The problem is when I run
my query it sum ...
|
Back-up
Fri, 4 Jul 2008 11:57:27 +0200
Question A
Access 2003 has an option under File (Bestand): Back-up from the database.
(or some such translation from Dutch)
What would this be as MenuItem?
(As the following instruction for Save would be:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70)
Question B
Is there a list ...
|
Database template
Thu, 3 Jul 2008 22:41:00 -0700
hi
i menage acounts for an isp and i was wondering is there a simple template
that would allow me to see the users of the isp in a way that it would be
easier to menage payments from those users.
i am simply looking for payments made and over due payments highlighted ...
please help . ...
|
IF HELP
Thu, 3 Jul 2008 13:50:00 -0700
Thanks to all in advance for all the help you provide! :-)
I am "green" when it comes to any code so, once again, need real simple
instructions.
I have a "SearchLastName", which searches a list of names and then opens up
a person's information. Right now, if the person is not on the list, or if
the na ...
|
Auto-Fill a Form
Thu, 3 Jul 2008 09:53:01 -0700
I am new to Access and am setting up my first database to track several
breakout sessions for one large conference. So far, I have a 'presenters'
table and a 'sessions' table. I want to create a form that I can enter the
session info and then select the presenter(s) from a dropdown list and then
once I sel ...
|
Using form to enter data to a field
Thu, 3 Jul 2008 05:36:01 -0700
The end result I'm looking for is to have a report with a list of names going
down on the left side and sequential dates across the top. I want to be able
to put selectable data into the given "mailbox". I have tables with names and
I have tables with dates and I have a table with a "status code" that will go ...
|
not a dBASE IV file - after access query
Thu, 3 Jul 2008 03:08:07 -0700
A dBASE IV file was opened by ACCESS for a query (SQL select query ran);
which was fine until I returned to dBASE IV. Experimenting following a Access
book.
dBASE IV now gives the error "not a dBASE IV file" when I try to open the
database file I opened with Access. This occurs with & without index even
t ...
|
|
|
Archive a datasheet once finished with
Wed, 2 Jul 2008 21:17:00 -0700
Hi, Im building a database using Access2003 & Im very new at it. I can not
work out (after days of trying) how to archive a form datasheet once I have
finished with it. I want the users to be able to access the archived sheets
later if need be. ...
|
Compacting Question
Wed, 2 Jul 2008 18:20:00 -0700
I get an error when compacting any Access database templates, or apps I have
created. I use Access 2000 with XP Pro. "Microsoft Access can't delete
C:\Documents and Settings\...\Desktop\Euipment Tag.mdb after compacting it.
The compacted database has been named C:\Documents and
settings\...\Desktop\db1.mdb" ...
|
Autonumber for Report
Wed, 2 Jul 2008 11:32:20 -0700
Thanks in advance for any help someone may be able to offer.
I would like to create a three number field that increments by one digit but
is preceeded by the last two digits of the current year and a hyphen, such as
08-001, 08-002, 08-003. We would fill out individual reports throughout 2008
and then in 20 ...
|
