How can I tell via VBA how big is  a form I open and how it is
situated?
Hannu

I am trying to develope a database that tracks scorecard used for Quality
Assurance purposes.  I have no problems with the creation on a single
scorecard.  My problem is that each scorecard contains a different number of
questions and I would like to have each of the scorecards ...

I have a continuous form.
In the form header there is an unbound field called filterfield.
in the onload event of the form i placed
  filterfield.setfocus

I have a form that I added a combo box to based off of a table.  After going
through the wizard I then entered the query of the row source and did group
by Invoice.InvDate in totals row of query.  If I view the query that is
displayed everything works out, the invoice dates are ...

I designed some forms for a customer on my laptop which has a screen
resolution higher than the target customer's pc.  As a result, the forms are
HUGE on the customer's pc.  
Is there a way, short or redesigning the forms (menues, reports, inpout

My form has txtFirstName, txtSurname, and cboCategoryID;
cboCategoryID rowsource is:
SELECT lkupProcedureCat.ProcedureCatID, lkupProcedureCat.ProcedureCat,
lkupProcedureCat.Use FROM lkupProcedureCat WHERE

How can I kick out everybody from the database. I waste so much time running
around to close the database.
Also is there a way to compact the database while its open?
Thanks

I'm working on an Access application and since it will run on a touch screen
system I need to have lots of buttons to let user to access all of the
functionality of the application itself. Button command doesn't look so great
and they are very little customizable so I would ...

My combo box is based on a table that allows duplicate entries, is there a
way to filter the combo box so that it doesn't display the duplicate entries ?
Thanks

I'm a bit of an Access novice, so I apologise if questions like this have
been done to detah. I have tried several forums and have, so far, been unable
to find a solution.
In Excel I have been able to create an IF statement to display text in a new

I would like to calculate the date diffrence of admission date - start date
but I can't seem to get it to work. Here is the expression I am using.
=DateDiff("y",[Start Date],[Patient Information]![Admin Date])
I put it in the defalut value under the properties of the variable I am ...

Hope someone can help on this.
I have a form that where I  want the picture background to change on the
afterupdate event of a field, eg where if the case status is - closed, live,
or pending, the backgrounds will change to blue, red or green for example.

I have a form with several tabs.  Two tables are linked to supply the data
for the main form and the subforms.  I have several subforms linked to the
main form, and other subforms linked to the other tabs. When entering data to
two of the subforms, it forces new lines on the ...

When you click on the text box and place it into your document, two boxes
appear.
1. A box with "text 56" in it.........(the numbers vary, which I assume has
something to do with the amount of info on the page?) In this box, I can

I need to design a "switchboard" or some kind of interim form which would
allow the user to design his/her own query to pull up records from a table.
The user could pull by date (date should be displayed) alone or in
combination with up to 4 or 5 other criteria.