I am trying to create a database program so that I can keep a record
of the stock adjustments I do here at work.
How should it work?
I often have to do adjustments for 3-4 products at a time. I would

How can I calculate number of rows in different queries?
I have one query for each day, and there is 365 days. Each query have a
different number of rows:
1st of January have 30 rows, 2nd of January have 59 rows, etc.

In another thread, somebody ventured the idea that this was possible
under A2k's ADP but they did not sound sure of it.
Anybody done it?
My agenda is to use DAO for work tables bound to forms.

[Field1] is a TEXT field in a table
[Box2] is an unbounded TEXT field (with combo box of list of things)
Private Sub Box2_Change()
   [Field1] = [Field1] & ", " & [Box2]

I'm trying to restrict my data in queries using the criteria:
<=Now()+30    - I'm trying to find the records that equal now to 30
days from now.
[C4:ECD] is a  field and I'm trying to count all of the records that

 i'm trying to start a service wich has to interact with thedesktop, the
problem is that my database is in another machine in my domain.
If i start my service as a "System Service" i have the problem of being not
logged in but if i start as a "user service" i can?t interact with ...

I have a list or percentages in a query (listed below) and I would
like to rank these values from highest to lowest so that they will be
presented in a report right next to its values.  Is there a way I can
do this?  If so, how?

hello...
i am a 'user' of access, meaning, i import excel files, join, and
merge....that's about the extent of my expertise with ms-access.  my
boss wants me to create an access application that will replace our

How do I remove the limitation in Access that deny me from exporting 24000
rows and 17 columns (in a query) into Excel?
Kenneth

Is there anyway of colour coding values in a report for given criteria
and then exporting this formating into an Excel spreadsheet.
What I have is a table full of details that are being changed daily.
I have  a report to list these changes to give to a customer on a

I'm using A97.
I've got a table which represents choices a user can select. Now, what I
want is to create a form that show these choices and give the possibility to
the user to choose one or more in the list and then do a certain work on

I use MS ACCESS front end back end design. Multiple computers. There
is a form that uses a table for calculation purposes. When ever the
table is open on one computer, the form does not work anywhere else(MS
access freezes). When the table is closed, MS Access unfreezes and the

This probably is a basic question for most of you, but I am setting up an very
simple database  - person, date traveled, location and milage - using ACCESS
2000 and I want to add up the milage in one field so when I do a query on each
person I can print out a report giving their ...

When I do this, programmatically, and then view the report design the
recordsource is empty.   I have to manually set the recordsource using the
report's properties.
I also had the same problem when trying to use VBA to assign some SQL as the

I have a really weird problem and any assistance would be welcome.
I have developed an app in Access 2002. The app runs  perfectly on the
development machine. I have packaged the app
using the Microsoft XP Developer Packaging Wizard (Service Pack 1). The 1st