OK, how do I get rid of the security warning whenever I open a
database??
Thanks!
Laura

Hi Everbody
I am trying to trap the error that SHOULD occur when there is no
internet connection.
Private Sub CmdPayHere_Click()

Is there any speed/resource advantage/disadvantage in using
Select Case x
Case 1
Case 2

With a little help from my friends (that's you) I succeeded to write a
little program.
To access a field in the current record, I simply write its name, for
example:

Is the database password something that can be used to
unsecure all database objects? tbl, qry, frm, rpt, mac, mod?
Even in A97?

My code, visual basic 6.3 for access 2002 SP3, returns a large
recordset
   strSQL = "SELECT * FROM tblMobileCalls WHERE Client = '" &
strClient & "'"

I have 2 queries one is called totalDues(derived from table
AccontRecieveable) and other is totalPaymentsmade(derived from
tblPaymentsMade).
 totalDues have (CustomerID, TotalDues) and totalPaymentsMade has

Can ADO be used to insert data into a new table in a new MDB file?
I have tried several things and so far no luck.
Will something like the code below work?
Private Sub Command7_Click()

I'm trying to link a remote client Access app (through the internet) to
an mdb in a web folder on my web server.  The idea is to give users
readOnly access to the web folder mdb, which itself links to SQL Server
2000.  Users are not permitted to connect directly to SQL Server

I have tried the following in the immediate window.
It yields an error...
?"Hello"&vbCrLf&"there"&vbCrLf&"next"&vbCrLf&"line."
'Type declaration character does not match declared data type.

SELECT Products.Manufacturere, Products.ProductDescription,
Products.SerialNumber, Products.QtyOnHand, Products.Location
FROM Products
WHERE

How can the label for a checkbox and the labels for the options in an option
group be addressed? When a checkbox gets the focus, Access draws a dotted
box around the label. When an option group gets the focus, Access draws a
dotted box around the label of the first option or the ...

  For example, if I have one of the numbers 6.4, 6.3, 6.2, 6.1 I want
the number to be 6 and if the number is 6.6, 6.7, 6.8, 6.9 I want the
number to be 7 but I want the number 6.5 without any changes. I need
the format to be used in a field in A FORM section. Thank you I need

Dear Access 2003 Users,
Is there any way to launch Terminal Server from Access and pass along
the user name that is in a text box?  I believe mstsc.exe can be
passed an IP address (/v), but can you also pass along a username or

This code doesn't work.  Every posting I can find suggests that it
should.
If TypeOf controlname Is DTPicker then
do something here