I must have been away too long or my memory is kaput.
I have a flat-file (Excel) I import in Access 2003.
Some of the fields of each record go into a master table, while the other
fields go into a related table.

Anybody has done or put a File Browse button on a MS Access Form ?
I was trying to use the MSDialogbox, but seems not working
I am using MS Office 2003 on Win 2K
Thanks

I have a combo box and when i trigger a check box, i want the to run a
different query to populate the combo box. i am doing somethign wrong in this
code not sure what as i get a syntax error
Private Sub chkAllData_Click()

Is it possible to use the column function when defining an expression within
a query?
I typed
Labor1:Val([Labor].Column(1))

How do I create a search button or field or both that request users to input
data (for example SSN) and uses the user input to pull up a record and all
other information related to that record?

There are several posts that have discussed ranking within a query, but I'm
not too sharp at SQL and I'm having a difficult time. My query is below. I'm
trying to create a table that would show a ranking for employees by company
seniority date, without displaying the actual date.

I have a guery with 6 tables in it.
Table 6 is a linked table.
When I run the query, it gives me 566 records but will not allow me to
change data in Table 4.

My database is ODBC linked to an SQL database the DSN is QMSPRD.
I use Option Explicit, then in my code I add "QMS.addQMSPRD"
The error message tells me I need to "Explicitly declare the variable"
How do I do that????

Does anyone know, is there any datagrid control in MS access 2003 ?
If yes, then which activex or ocx to rigister ?

Hi could somebody help me out adapting the following query.....
I currently have a statement report that has a subreport of all linked to the
main report by account name....
The subreport has a detail line for each Invoice sent through the month...as

I have a a table in access that a column has the data :2006-03-03
00:45:09.000, it is a time stamp that just keeps changing. My question
is how would I query just on the hour. So I could query on 00:45 and
00:46.  

I need to shorten an SQL statement from a mdb query that is to long to be
accepted as a SELECT statement in a Data Access class in VB.net. "SELECT *
FROM tblXXXXX" won't work because I also need to fill combo boxes as well as
text boxes on a form.

I am trying to run a query where I can determine when an employee gets more
than 2 complaints within a certain date range.
The fields in my query are:
    IncidentDate

What query can I run to determine if a table is empty?  I have a
placeholder table where whatever values it contains will be copied into
another table.  I want to make sure that the table is not empty before
proceeding.

Hi friends
Maybe this question is already somewhere answered, but as English is not my
mother language, maybe I have not found it. The problem:
I have a table with sales contracts. the relevant fields are: