I ask this question a week ago but no one answer me with the answer.
How to close a form opened on other computer through network?
Let say i am the admin. When i press a close command button, Forms opened on
other computer through network will close.

I have an Access 97 database developed by someone else that I'm trying to
modify.  What I need is to get 2 recordsets from 2 different (but identical)
oracle systems.  Then I need to create 1 "union" recordset of the results.  
sngSStart and sngSEnd are unit numbers being passed ...

I have a FE/BE database setup, with several tables linked between the two.  
In addition, I have 5 CSV files that are linked into the FE.
I am trying to create a relink sequence to cover cases where the database is
moved from one location to another.  I can relink the tables ...

I'm trying to alternately highlight rows in a report by the Date field.  I'm
using the following code in the Group Header:
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
m_RowCount = Format([tblwodDate] + 1, "General Number")

I'm trying to use a module to allow a user to retreive a Visio file (.vsd) by
inputting the file name.  I keep getting an error but the filename has a dash
(-) character.
i.e. AA-173, or LL-454

Although I used the following for format and input mask, time still shows up
when I click on the date field:
Format: :Short Date
Input Mask: 00/00/0000;

When I was working with Java I had some nice methods and properties
available to me for determining font metrics. One of the calls was even so
nice as to accept a string and return the displayed length.
Is there a slick way to do this in VBA in Access 2000?

Is there a way to get a list of queries using a particular
table?  I have to make a fairly significant change to one
of my tables and I need to modify all the queries that use
this table.  I remember seeing code that did something

Hi.  I have a form and then a subform in it, whose values are based off the
information in the form (somehow, which the wizard did).  
I have a button to delete a record from the subform, which works fine.
However, I want to have a button to delete a record from the form.  The

How can i count the records of an access table with ado?
Is it something like this? I know i'm missing something.
Dim rst As ADODB.Recordset
Dim strSQL As String

I am using Access 2k. I am trying to search for a % in a field.
This is my code that is not working:
Dim strTbl As String, strFld As String
strTbl = "Table_1"

The code below is placed on the Got Focus property of a form with a
datasheet sub.  If the underlying form is open, it will go to the
record that has the focus of the popup datasheet.  It works.  But the
problem is that it filters the underlying form.  I don't want it to

I'm often asked to create reports containing a "random" selection of
records.  I've got several different functions for doing this
depending on the report requirements.
What I'm finding out is that when people say they want a "random"

I have a report to print labels based off of a query, which could have one
record or 500 records. The problem is that I would like each record to print
out a diffrent quantity. For Example, Lets say record 1 has equals one box
and record 2 equals 5 boxes and record 3 equals 4 ...

Can anyone please tell me the correct syntax for a where clause. I am using
execute to delete records from a table. It worked ok when I wanted all
records deleting but now I want to add a where clause and I get error 424
Object Required.