I have a database that contains a field having duplicate data. I have created
another column and I want to insert numbers in the other column that will
start at 1 and increment up to the count of the data. For example if "ABC"
occurs 3 times in the first column then in the second ...

I have 6 different comboboxes on sheet1 all of which reference the same range
on sheet2. I would like to set them up so that if only the fourth choice
(john) is selected then the other 5 will not allow the user to select "john".
Right now I have it set up like this for each of the ...

Hello,
I hope somone can help me solve this problem!
I need to fill an array with Data from a Report!
For i = 1 To Report_UpdateReport.Count

I have a form with several tab controls.  I also have a subform on the
main form.
I have placed a command button on the main form that calls a macro that
print-previews a report for the individual record that is currently

Have a Macro to send a report in RTF.
Is there any way to password protect the report being sent?
I don't need it protected in Access, just the RTF that is being sent.
It is confidential client information and it is required that the file be

Using a macro, how can I copy and paste a command button from one form to
another ?  There is a copy object action, but it does not seem to allow the
object type of control ?
Thanks

I'm desigining a macro so that it will open and print the same report
multiple times.  Basically, I want each report to return data with different
date ranges.  I'm running into a problem with the "Where Condition" under the
OpenReport Macro Action.  The Where Condition I have is ...

Is there a way to write a macro that will run a query and then save it to a
server file and name it the date it was ran?    Thanks,  
I tried to send this once before but it looked like this question did not go
through and the my PC locked up.  If it shows up, I'm sorry.

In the Access application I had put together, I wrote a
macro linked to a command button to go an import a text
file from a pre-defined directory path and add the file to
a database table.

I've been looking for a startup switch to run access in a stealth mode where
you don't see the application running.  Is there such a swithc or is there a
technique using the application object visible property?

I am using Office 2003 on Windows XP (ADO 2.8).
I am automating Access from Excel and I would like to retrieve the field
names from a DB using SQL. Right now, I am returning a single row in a
recordset (using TOP), then obtaining the field names.

When a user checks a box on a form, I want to change another control not
updatable.  
More specifically, it is giving the user to specifically limit (or identify
criteria or range of data) or check a box to "select all".  If the box is

I am new to access. I have a table that has a field of data type text. The
data in this field has spaces embedded and I want to take out the spaces. For
example, the data shows up as "4F- 16B -K- 12" and I want it to look like
"4F-16B-K-12". Can anyone help me? Thanks in advance.

Can you write code to place custom toolbars above an
application.
Right now I use macros to do this, but when using Access
2003 you get a message warning that macros can harm your

I have a table with a number of records including values 'X' and 'U'. I want
to replace these with '99' and '98' respectively, however the table is a
lookup table and won't let me do this directly due to referencial integrity.
So i need to add the new values, update the second ...