i have a national database on terminal server and i need to be able to
calculate the current time in a specific region. WA for instande is 2 hours
behind QLD.
this is the formula i have thus far but i cant get it to show the current

how can i prevent my form to open when there is no value
on the underlying query? i have a form where the user
input values w/c will be the basis for the form to open,
but the form keeps on opening even the value entered does

I have a form called Schedule that outlines the details of the clients
activites.  Within this form, I created a command button "Open Invoice".  I
am having difficulties figuring out how to connect the fields in the Invoice
to the Schedule so the records automatically populate.

When I've eventually finished tinkering with my Coins database, I'm going to
want to click on a desktop icon to run it and not see the data window any
more. The trouble is, I can't find anywhere in the Help that explains how to
do this. It's just my own little hobby database for my ...

I am a complete novice, but need to create a database, which will eventually
be used with a sales web site. I will be selling consumable items, that will
need to be added to:
Main Categories

I have a form which is used to generate a string.
This string is an SQL query which is the record source for a second form.
Is there a way that I can pass this string from the first form to the second
form when the second form is opened within the first form. At the moment I

Thanks in advance!
I trying to save some control ( "size" and "height") data
from a "Form A" to another "Table B" that is not the
underlying table for the "Form A". For the moment I

Hi,
I'm very new to access and I am trying to create a very simple room booking
database that lets the user, wait for it...... book a room! At the moment it
is very basic and I only have three tables:

I want to highlight the contents of a combo box when the user clicks in it,
so they can easily replace what's there with new text.  I want to mimic the
behavior of tabbing into the combo box.   It looks like I should use
something like this in the click event

I have a window with search fields at the top and a tab control with a
number of tabpages at the bottom.  Is there a way to use the keyboard to get
from a tabpage back up to the search fields?

However I set the width of a form, it always fills the screen when I run it.
Is that a default of Access, or can I have it only as wide as it needs to
be?
Regards,

I have Office 2003 with Business Contact Manager, and apparently I have a
version of SQL Server as a result. I think it's just the database engine as I
do not have tools like enterprise manager. I have 2 questions: 1) How do I
know it's up to date, and how do I get it to work ...

I want to set up a database to store demographic data about event attendees.
I am working from home and don't have access to the office SQL server and as
the database will only be used by 2-3 people in the company I think it will
be easier to store it on a network drive as a .mdb ...

Access 2000.  Are there any pros and cons to naming objects with long descriptive names vs abbreviated names?  How about the fields?
Example
tblEmployeeDemographics or tblEmpDem
If I call the table EmployeeDemographics, can I call the fields

Can someone please direct me to the right news group for a "case statement"
question?
Thanks