Is there anyway to programatically confirm that specific field names
exist in the first row of a given Excel spreadsheet from code within
Access?  I have code set up to import data from our spreadsheets from
HQ into our Access database for further use, using the first row as

Ich bin absoluter Access Anfänger und würde gerne ein Startformular
in Access erstellen. In diesem Startformular soll der Benutzer seinen
Namen und sein Passwort (zuvor gepflegt in der Tabelle Benutzer)
eingeben und je nach dem welchen Benutzernamen er eingibt kommt

A client has about 15 workstations, all running an Access 2000
application we wrote for him. Three WinXP workstations have a problem
you can see here:
http://members.cox.net/tvstiphout/FunkyScreen.gif

How can I limit the number of records a Query retrieves or at least
limit the number of records returned on a report.
I only want to print the top 5 or 10 returns of a query into a weekly
reort.

I am using Access 2003.
I wanted to know if it is possible to avoid the switch board main menu.
Instead, I wanted to create a Multiple Document Interface where there
is a main across the top, ( like Excel or Microsoft Word ) and the user

I have a table with the following structure:
user_id
transaction_type
revenue_amt

I run the following code
Application.ImportXML _
   DataSource:="C:\TEMP\Audit\BatchData\BatchHeader.xml", _
    ImportOptions:=acAppendData

I have a form that I need loaded and visible prior to another form
being loaded (hidden.)  I am opening the main form, then using the
OnTimer event (with a timer interval of 2000) to open the second form.
How can I run this event only once, instead of per the value of the

I am trying to edit hard-coded VBA links in Access and Excel
applications.  Is this possible using the .NET object model?  If so,
have you guys got any good material/references you could point me
towards?

Does anyone remember the user or website that has code for
automatically eamiling the US Senate members? Thanks!!!!
Brian

I have to generate a checklist form as an input form in Access. A paper
form is taken out in the field and checked yes, no, OR n/a for each
item inspected. The problem I am having is this, the form should have a
main heading with the date, report no, and inspector. This information

I have a text string A as "3/9/2006 1:21:00 PM". I want to compare A
wich Now(). Is there any function to transfer A to date and time
format? Thanks.
Mindy

Hey, Guys,
I have a question regarding data type. I use the function (   Expr3:
DateDiff("n",[order_date],[ship_date]) to get Expr3, which is the
difference between order_date and ship_date.  I want to use Expr3>

I have a table listing accounts with a closed date - our Trial balance drops
the account after 7 days but our database keeps the record forever - How do I
calculate the end of month less 7 days so that I can get an actual count of
the accounts that were closed during the month.  I ...

In VBA I would like to test if an OptionButton is chiled of an OptionGroup.
I wrote this test
   OptionButton.Parent.ControlType = acOptionGroup
It's all OK if this test is executed on an OptionButton which IS CHILD of