I have a form base on a Query, and I would like
to edit some data.  I have a Query the combines
PO# and Invoices, it sums and balance, etc.
I would like to have the form display two other

How can i show the result of this sql in a text box?
SELECT Sum(tbl_TempCalendarData.totalTime) AS SumOftotalTime
FROM tbl_TempCalendarData
HAVING (((tbl_TempCalendarData.meetingdate)>=fformdate() And

I was wondering if there was anyway to make a form change colours for
certain areas (background, text input boxes, etc) if you made the data
in one field equaled a certain value (it is set to 'standard' or
'urgent').  Any ideas?

Yet another form/subform problem. They're not talking to each other
properly.
Form info:
           name:   fmAEPtest

In my Access 2000 database, I have a form that uses VBA code to look up the
number of tracks on a CD and the total time of the CD.  Now, I was wondering
if there was a way to use VBA or API's to go out to the Internet and download
the Artist/Title/Track Song Titles/etc... of what ...

Is there a way to move the scroll bars to the opposite side of the window???
They are by default located on the right hand side...
Thanks
Brad

I have a from that uses two tables what I need is once you enter the employee
# in to the first column it should update the next 3 fields with the related
info from the main table...example
Table 1 has  and Table 2 has

After checking the form is loaded, I get an error trying to set the focus to
the open form. (Runtime error 438, object doesnlt support this property or
method.) Debug brings me to the setfocus line.
Private Sub Return_Click()

I'm having trouble with coding in VBA in Access 2007. Code that works in
Access 2003 doesn't work in 2007. It's simple code to check that there are
enough characters in a field, yet Access totally ignores it.
Help

HEY GUYS,
need some urgent help here....I am querying my database based on a
DueDate field...and want to send an automated email to anyone that
falls within two months PRIOR to this "DueDate", so far the Code is

Though this is a section to discuss forms, it is also about programming so
I'll post this question here.
Has been a lot of time that I've been hearing about the question of how VB
will evolve (or not!) in the near future and I have a few access databases

I have a function that searches a table and returns the ID number of the
record if found - The function is assigned to a text box so that it will
store this ID in another table in order to relate the former table record to
the latter's record.  When I send a call to the refresh ...

I'm am trying to trap people typing in a date without a time (appointment)
except the whole appointment has been deleted (Null)
Tried:
If (Start_Date = Int(Start_Date)) And Not IsNull(Start_Date) Then MsgBox

I added a clock to a form but it only appears when clicked.
I tried on open, on load, is there something I can add to the code to have
it appear when the form opens???
Private Sub Form_Load()

I've been fumbling around with this for entirely too long, and I need some
assistance.
What I'm trying to do is to set up a form where the user can select from a
particular set of fields (which obviously exist in one of my tables).