I need to go over the hurdle of the connectivity syntax of ADO vs DAO.
I want to loop thru each record of table "A" in the current
database "X"
If condition is true in field "Y"

I am trying to position opened forms so that they are cascaded on the
screen.  I have discovered the movesize action (for the DoCmd) and Move
property of a form (for Acc 2002/2003).  However, if the application is
opened up on different monitors (e.g.; 17" or 19"), the relative

I have the following query in my form's code:
Private Function Get_Data(fieldNum As Integer)
   Dim strSQL As String
   Dim db As DAO.Database

I'm helping out a non-profit school with their database.  They would like to
know the last gift made by each donor, the donor name, and the gift amount.
I built a query based on two tables.  The donor name is from the first table
[Gen_info].  The gift [Date] and [Gift] are in the ...

What is the code for a recordset in error handling code when the error may
or may not occur before the recordset was created? I tried the code below
but get the message:
Compile Error

Hi i'm trying to import an Excel Spreadsheet into Access2000 but the data
types for two of the fields in my imported table are being identified
incorrectly.  Is there a way of using some VB code in Access to change the
data types for the fields from text to a number field or an ...

I have a text file that contains the following:
********************
__StartCustomerID_41
Name: Fred Smith

I'm developping a new application (btw: I'm not a real specialist but
more or less a newbie). Now I have the following problem:
Each time I leave the main form of the application Access shows the
tables collection in the database window (I don't know why). How can I

Anyone interested in using an Access database in an internet environment
might be interested in reading the summary of my journey in this
direction.  I tried several web development environments, web site
generators and even Access' Data Access Pages.

I have a field 100 with character lenght.
How can i saw and edit data in the5th place in the field
Themis

I'd like to make a valuation of database records. Suppose you have a
table:
Name         Must have
Address      Should have

Dear reader,
By append a new record to a table I always expect the next higher value in
the range of the autonumber field.
But sometimes if I have deleted same records from a table the behaviour of

I want to make a parameter query where i can select the parameter out of a
drop down box instead of typing the parameter in a text box.
For example: if i have customers and want to run a query that gives me all
the custormers from a chosen state, that i can choose the state in a ...

The following query runs just fine in the Access 2003 interface.
strSQL = "SELECT tblCASES.CID, tblCASES.[File Number] AS [DACS FN],
tblCONTACTS.FirstName, tblCONTACTS.MiddleInitial, " & _
            "tblCONTACTS.LastName, tblCASES.[Firm Name],

I just made a .NET Windows Application which uses MS Access as a
backend. Is there a way to deploy the mdb file so that it does not
appear as an Access db to the end user and still be accessable to the
Application? Better still is it possible to deploy this database so