I have a pop up form that grabs some parameters and then opens a report.  
When I open the report I hide the form (me.visible = false) and make a call
to a module that sets a property for the form being hidden (all this happens
before the report is actually opened).  That works ...

i am pasting in here my code. my question is can i do a recordcount on a
recordset that is based on a command (query) ? for some reason it doesn't
work. i can do things with the field names i can work with the recordset, but
i can't get the recordcount to work. i tried changing ...

I have a serious problem with my database. I remove the user name "admin"
from the usergroup "admins". I remove all permissions from the user admin to
open the database. I cleared the password for the user admin in error, so
when i close the database i dont get the option to ...

In a ASP.NET 2.0 web page, I have the following code to connect to a Excel
2007 XLSX file (stored in the temp directory of the Windows account running
the application pool), in order to open it and retrieve some colums and rows.
const string excel2007connectionString =

How do I get an ODBC driver for Access 2007? Is it something I have to
download.
Thanks
Suzanne

I can't get my code to work for importing textfile.
================
Function ImportWebData()
On Error Resume Next

I have several global variables that are of type INTEGER with simular names
and would like to reference them in code.  for example intPHOpen,
intPHDAOpen, intPHTROpen
my code loopes through records and I want the RecordType and Category (PH,

I have a requirement for my database to trim all data within all columns of
all leading and trailing spaces. My issue is that my code takes a long time
to process. I have 45 columns and there is alot of data within the table
itself.

Hi, All:
I am debugging a program, there is always runtime errors. I spent a lot of
time to debug them. I check the err object, e.g. err.description, they do not
provide which line of code generating the error.

I've created a Training database and right now we have over 800 employees in
it.  I have created a Quality Alert form so when an "alert" is entered, the
supervisor would like to show all the employees that are trained on this
alert.  I have a multi-select list box so the user can ...

I have a variable which contains a comma delimited list contained in a
database variable  e.g. "5,6,9,10,55,42" - I want to hand this list to
an array function to get it to populate an array, such as follows
(where rst!Q10ACode is the database variable):

Hi..I want some help with this VBA please. I have a searchform with 4 unbound
fields and an unbound Listfield. The user inputs data into one or more of the
fields and matching results are displayed in the Listbox. But, I am having
some problems.

I have used outlook for 15 years but would like to change the menus I setup.
Instead of using the standard switchboard I always create a form with Menu
Selection buttons. If there were 5 available reports - there would be 5
buttons.

I have an Access database with a table with sequentially numbered
fields (e.g., Q10_1, Q10_2, Q10_3, etc.
What I want to do is cycle through the variables to set them to
values. What I want to do is

I've spoken to a few people on this and no one seems to know how to do this.
I'm sure someone in this forum will be able to solve this puzzle.
We have network problems and we have 2 users that need to enter data into an
access database through table linking. Response times are ...