Can anybody pls help me out.
I am creating a table with a field that has about 50,000 randomly
generated
values(RandomID). Everytime I enter a new record with new RecordID,

I have to run some web pages on a laptop with xp professional with IIS.
These web pages interact with access mdb database but I HAVE NO ACCESS
INSTALLED.
I'll use this laptop in public.

I have a a parent form with a subform.  The parent form has two command
buttons to change the subform view to single form view and datasheet view
respectively.  I can't seem to get this to work.  There is a menu item to
switch to datasheet view, but it won't go back to form view.  ...

Can someonw pls tell me how to reference the Where clause made by the
VBA statement
DoCmd.OPENREPORT "Report",acviewpreview,,where
as a control within the Report itself?

I have a form with a listbox on it which displays the result of a
query.
I need to be able to change the sort field (DwgNo or Title)on which
the sort is performed by selecting either a DwgNo button or a Title

I have a table like below and I want to find all customerid's that have a
Yes for both optinid 1 and 3 so I tried this but it doesn't work:
SELECT customerid
FROM optinsxcustomers

I am trying to combine the data from two similar tables into one
query, but I need for all of the records from both tables to show up
and I want the ones that have matching 'emplid' to be combined into
one record showing both the 'empstatus' and 'strole' fields.

We have a Microsoft Access 2000 database consisting of 20 tables
covering 20 different events.  In each table, there are 3 Team
members, a date of the event and several unique fields for the event,
which vary from table to table.  There is also another table that

Is it possible to programatically save a certain image from a certain web
page?
I  want to automatically get a specific graphic from a specific web page
programatically so I can automate the task. I know I can NAVIGATE to the

For the Past few days I have been trying to create Query, and
everyone I have asked have been obtuse with the help. I am a new to
access and still learning, so it is probably that stops me from
understanding.

I have an Access 2003 database that has a text field which contains a
path to a photo. Each new page of the report links to and displays the
photo.
I use the following code:

is there a way to call my own VB Procedure from a .NET Application
using ODBC ? I tried different ways like:
SELECT myProc() FROM...
SELECT { fn myProc()} FROM...

ve built various web apps using Frontpage and/or ASP and Access, but
now I'm trying to figure a way to do the following:
My friend gets parts lists in invoices (they are in an excel
spreadsheet) that he has to classify as a certain type:  eg. part

I have a list box where the user might need to select two items which builds
up an sql string. Another part of the function only requires the first item.
here is the code :
For Each varItems In Me.ListDOS.ItemsSelected

I've received this error several times, and have only been able to get
around it by deleting the offending form(s) and importing them from backup -
Here's the sequence:
1. I'm editing a form or code in a form module in MSAccess2000 on Win2k