What I'm trying to do is, in a date field, on "has focus", if related "check
box" is positive (yes) then insert current date + (plus) 45 days. (to present
a future date).
Is there any help out there?

I want to set the focus in the one textbox even if I press <enter> or <tab>
key until I use the mouse to point to another textbox. How can I do ?
Thank you
Jason.

My company currently uses an access database to run queries, reports, etc.
from our accounting system CODA because CODA is not user friendly.  My first
question is "Is it possible?"
We are a management company that pays for our clients vendor invoices and

I've building a form with a subform. The subform is based on a query that
draws info from several tables. Each of these tables relates to the others
using foreign keys.
For ease of reading the fields in the query, I didn't use the numeric values

I'd like to replicate the way the Northwind sample database list products on
a sub form (Product List) on the Categories form.  In the Northwind sample, a
user can select one of the categories (beverages, condiments, etc.), and the
Product List subform displays data on the ...

I posted the following (see below) a number of months ago. The response
I got back then was to make sure that the reference to Microsoft DAO 3.6
Object Library was selected and set above the Microsoft Active X data
Objects 2.5 Library. I did this and it solved the issue.

How do I add a column to an exsiting Access form (ie. order form) but then
get it to be part of a calculation?  My order form currently has "order Id,
order no, product id, quantity, rate, discount & extended price".  Need to
add length into there, and have formulae

I want to permanently display the previous record in a subform. But whenever
I go to add a new record on the main form the subform data goes! I have had a
response for this but the websit page does not load. Any help would be
appreciated.

How do I make lcase("A") = ucase("A") return false. I can perform the
oposite in DOS/CMD (if /i A==a returns true, if A==a returns fasle ) but how
is it done in Access?
Thanks,

Good Afternoon,
I am creating a report based on input in a table that calculates ticket
revenue from athletic events.  I have the report completed and a total for
each line.  The report is based on a query so I can select only specific

Forms will not sort by Order by. I have to use the select statement
including the ordering for the forms sdata source.
Thanks,
J.

Is there anyway to have a secure database where a person can't access the
passwords that are stored expect to change their own password?
Thnaks,
J.

I would like to copy commands for navigation from my main form to other forms
in the database.
Any suggestions on how to do this?
Thanks!

Thank you all for looking.  I am having my startup screen open maximized and
I would like to acknowledge that not everyone uses the same screen
resolution.  I would like to have the content of the form centered on the
form so that it looks aesthetically pleasing regardless of ...

I have posted this query again, because I still can't get this to work.....
I have read much of the resource that has been suggested to me in this forum,
but am still having problems.
Amongst other tables I have the following:-