I have a launcher program that creates the shortcut to open my application
using the Shell command.  On the form I have a decompile checkbox that I can
conveniently use to decompile my program.  I follow the  protocol described
by Allen Browne.

I am looking for code that will check if a field (fieldname) exists in a
certain table (tablename), then to add it if it does not.  Can anyone guide
me in the right direction.  I think I can add the field, but I need to know
how to find if the field is already there.

I have 4 fields in my table Field1, Field2, Field3 and Amount. A unique
record in this table is defined by the combination of Field1, Field2
and Field3. I have a query that rolls up by Field1. The other 2 fields
- Field2 and Field3 are not used in the aggregate query - hence are

I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.

I have been asked to keep track of our companies work orders.  I have
run a query to show which ones have been completed and which ones are
not finished.  What I would like to do is beable to run this query but
add a start and stop date. i.e. July 1, 2006 - July 31,2006.  In my

I have a combo box in which a user can select a number of "1" or "0".
if the user selects "1" it changes the visible property on other
controls that were initial set to "Flase" to "True" .
the code works until i added the set focus.

My front-end code manually links to the backend file.
I was wondering what stops Access from linking to the system tables in the
backend file.  Is it just by virtue that they are hidden?
This has recently come up because I've been playing around with converting my

quick question, how do I make my form to not show the record navigation
at the botton/left of the form. I just want to use my form for input
data, but i dont want to see that navigation bar.
Thank you

In my application vehicles arrive and depart from a workshop.  The
ArrivalDate and the HandoverDate are each entered.  Sometimes the
person who should enter the arrival date forgets to do so.
When the vehicle is handed over to the customer and the HandoverDate is

I am having difficulty filtering a form as the user types in a onchange
event
here is my code
       strFilter = cboCriteria.Value & " LIKE '" & Me!txtCriteria.text

I notice in http://homepage.mac.com/bradster/iarchitect/controls.htm 
that in the comments on the "Click & Print Certificates" dialog (less
than a quarter way down the page) that "instructions in the title bar"
are frowned upon.

I have a a fairly large Excel sheet that I linked to from Access.
Everything seems to work fine except for one field.
The priority field is a text field and can have values such as
1,2,3,3a,3b,3c, however, when viewed in access the values 3a, 3b, 3c

I have a Report and subreport where the rows in the Report are selected
on a three part primary key. ID,YEAR,PERIOD.
The subreport has a data select statement on a second table related to
the first with the same

I have this scenario:
group   |   id    |   value
---------------------------------
x        |   location |  QLD

Whenever I execute a sql command (using docmd.runsql), it always gives
a popup when executed asking if I want to confirm deleting 3 rows, or
updating 1 row, or whatever.  Is there a way to prevent this popup from
appearing?