I have a MS Access 2000 db that uses the command
call shell to launch a program that will clean up a text file.
My question is: is there a way to use the sell without it showing that blank
screen?

I have a field that is formatted as follows
Brown, John : Consumer Manger Manchester
I want to copy and keep everything to the right of the " : " to a new field.
Could somebody let me know if this is possible if so how?

How can I print the screen I see when viewing - database objects - queies
(detail view)?
I have been using Print-screen but that gives me a bitmap. I want a real
printout or list to export.

What would the proper way be to enter a sale, then be able to enter 1 or
more sales persons, their "costs" to the sale, and their commission on the
sale?

I have been working on a new database for some time. After taking a break for
two days, I resumed entering data in my inventory index.
For some reason, the autonumber function has restarted at 29...after I have
already entered 107 items. Every time I enter a new item, the ...

I am trying to merge a cell within a table thru XP.  I know you used to be
able to do that on Microsoft Word by clicking Table, then Merge cell.  Thanx!

I have followed the example called "Filtering the results of a query using a
Drop-Down combo box" on
http://www.microsoft-accesssolutions.co.uk/query_filter.htm. This gives me a
combo box which enables me to select the parameter for a query. It works

I am sure this is a really stupid question but I have to ask it anyway  :-)
When I build a simple query and run it the result is always in datasheet
view. Is it possible to view the results in form view (I have created a form
for the underlying table) - rather like when you use the ...

Is their a limit to the number of columns you can have in a query? I have 21
and have more fields I would like to add?
Thanks so much
GRCC

i want to make it so if a check box is checked then a certain amount is
automatically added in another field, and if not checked the amount will be
0.  How do i link the two fields together so the check box (yes/no) will
determine the answer in the other field?

Any suggestions appreciated
I have a field in a document management database
that will show countries and towns refered to in various
single documents.  I am therefore, intending to put

I lost the Junk Mail protection in Tools.  How do I get it back?

I have an unbound combo box with drop down list that can
identify a record from a table. My primary key of my
table appears in my drop down list of the combo box. When
my form is filled with the required info, I want to take

ANS: Round([data],1)
we found that the above function in Access does not always give a correct
rounded figure, where we suppose 0.4 is dropped and 0.5 is rounded up. The
problem is that it sometimes works but sometimes not, and we do not know why,

I'm an Access newkid, but a seasoned application programmer (over 25
years with Basic, C, C++, C#).  I'm designing a simple Access
application that will track the membership info for my local shooting
range.  The app requires one 'primary' table (contain member info) and