Given that most user access is via Citrix, we have Access licensees, a handy
SQL Server and a need to develop moderately active 10 - 100 concurrent user
databases, any +/- comments on using ADPs? We also have in place, the means
to distribute modified ADPs as the developers deem ...

i am trying to figure something out. the facts:
- i have an Access 2000 app that ive converted to Access 2007 (windows
Vista)
- it uses several external references, DLLs and an EXE.

Hi Folks
I wondered if someone could point me in the right direction before I
completely tear my hair out.
I have a user selection form where options can be selected for a report.

I'm new to Groups so apologies if I'm in the wrong one which I fear
could well be the case.
I run an event management company in Ireland. We have over 100 events
every year.

I designed an Access database for a project.
It consists of tables, queries, forms, reports and macros.
Just about all the bugs have been worked out except for a summary
page.

In AccessXP I have a form, it has a form header, detail and footer
sections. When done entering text in a txtbox(bxReqst) in the footer
the user wants to press the Tab key and have the focus move to a
control called bxQues in the Detail section.

I feel I should know this and I feel a forehead slapping moment approaching
but I don't believe I've ever had to do this before ...
I have a main form with a sub-form on a 1:M relationship.  My user wants to
be able to copy a main record with all of its children into a new record. ...

I'm trying to get geodata from Google or Yahoo's web service using an
Access (2000-2003) application. I have this working fine in vb.net but
have no idea how to do this in Access.
I'm looking for any example code from someone who has done this in

I have tables from 12 suppliers each of whom can supply the same part,
I need to be able to create a table or query containing a list of
suppliers who can supply at the lowest price for each item. I am
struggling with this, can anyone help.

I have a small bitmap graphic on a report.
I would like to set it's Visible property to True
whe the value of a certain field on the report
is True. Can I do that? I have tried in the

I can't delete a corrupted record because Access tells me a search key
was not found.  Any ideas?

I'm using MS Access 2000. I have a small database to keep track of my lighthouse
collection. Right now it's only two columns. I'd like to add a third. I'd like
the new column to be the third column, that is, to the right of the others.
Every time I try to insert a column, it ends up ...

I'm in Access 2002.
How do I change the format from all caps to title case.I've tried an
update query but can't seem to get the proper syntax.
I've tried in the "update to" line in an update query, the following:

Is there a way to log user actions?
What I would like is to be able to log user activities within the database.
The table “tblUserEvents” would contain two fields. Field one “EventTime”
would be a date/time stamp of when the action was performed. Field two

I wrote an access2000 database for a POS system.  In it is a sales
form with a a subform showing the items being purchased.  The main
form is unbound.  It uses a class to hold the main form data and to
read/write to the sales table.