This may be the wrong place, but I was thinking this could be done
with access.
I want to create an entry log that automatically time/date stamps each
entry to be used in an emergency response situation specifically for a

I have put a text box called [Count] with control source [=1] in the group
header with running sum set to group.   Then put text box called =[count] in
report footer.  
It counts the groups nicely in the group header but the value in the report

Private Sub VendorChqNum_AfterUpdate()
  Dim DateToUse As Variant
  If IsNull(Me.VendorChqDate) And Not IsNull(Me.VendorChqNum) Then
   DateToUse = DLookup("[VendorChqDate]", "tblInvoices", "[VendorChqNum]='"

How do I pull the date out of  a date/time field type.
I need to know when '02/08/07 8:05:24 AM' is equal to 02/08/07.
I'm looking at the extract date function and I must have the wrong syntax.
DatePart("mm/dd/yy",[punches].[Date_Time]) = #02/08/07#

How is it possible to read data from a serial port using baud-mode N2400
(inverted output) using VBA?
I wish to match the incoming decimal number  to an possible stock database,
reading the row and inputting it into a "in-stock" database i also wish to be

I am trying to import 2 different excel worksheet into a access table and
want to keep addign to that particular table.Is that possible

I'm trying to set a default value for a column in a table to be based
on values in another table. So far, I've discovered that DLookUp is
the way to go for this sort of thing. The text of my default value
looks like this:

I have an invoice table.  One field of the invoice table
is linked to a bills table.  The bills table is linked to
a suppliers table.
There are bills that match a pattern in the invoice

Currently we have an inventory system that allows us to scan all new incoming
material to inventory by scanning a barcode repeatedly to create multiple new
records. I know this is not an ideal table design. Any suggestions on how to
have a single record with a running count would ...

Since the tab control does not provide a "Back Color" property, I've been
looking for a another method to work around this problem.  I am familiar
with Stephen Lebans sample application showing how to this.  Unfortunately,
when I convert the sample database to Access 2003 format, ...

Hi,
My name is Rahima Mohammed;
I am a student of John Tyler community collage in VA. I am
doing a research project On Microsoft Access. For my

I have developed a new project utilizing Access 2007 and for a client that
wanted it based in one office and now wants 3 remote offices to have access.
After doing my research it looks as the only decent solution is windows
terminal server (I assume a new server and windows ...

How do I create one field(grade_field) that automatic load grade (A,B,C or D)
which "grade_Field" are lookup value from other field such as ("mark_field").
example: [(marks 80 - 100 grade A), (60 - 79 grade B), (40 - 59 grade C),
and (0 - 39 grade D)]

I just want to write the date/time to a text box.
dim thetime as string
thetime = Now
[Forms]![frmexample]![when changed] = thetime

I have several clients who's databases are still in Access 2000 and
several who are in Access 2003.  I have both on my development
computer.  I have had this setup for a long long time.  Recently
though, my 2000 MDE's are sometimes not runnable on the client