I'm trying to copy a range of cells from one spreadsheet to another.  How do
I specify the range such as "A1:C5" if I only know the ending column number -
How do I find out the column index - whether it is column C or D, etc.  
Please scroll down to where I've   'now to find #of ...

I was using adox 2.7 to create a new .mdb. Just recently, I've upgraded
Office to Service Pack 3. When I tried to run the code, I got an error about
module not found. I opened References and I got a message stating that one of
them was not loading correctly and that the reference ...

I have two tables. The tbl1 has [lastName], [firstName], [studNum]. The tbl2
has [lastName], [studNum]. I would like to write codes or make a query that
compares tbl2 to tbl1 by [lastName]. If there is a match, update
tbl2.[studNum] to tbl1.[studNum]

I have a transferspreadhseet method which is uploading a worksheet into a
data table. How do I change the data type of the fields? Maybe with an Update
query. At the moment all data are imported as text, which creates problems
when trying to do calculations.

I need help with this statement. It is looking at two text boxes and I want a
message to appear in a currently blank text box when conditions are met.
Private Sub Unit_Click()
If Me!TypeUnit = 1 Or 2 And Me!Totals > 15 Then

I am trying to get access to unzip files and allow me to import the text
document within.
I have read Douglas Steeles response on the 01/10/2006 and
I have tried Eduardos code however cant get it to work ... I have imported

This is the code I extracted from one of the subforms which works correcly.
   lngResult = Me.Parent.UpdateDASubform()
    Me.Parent![DASub].Requery
What is the correct syntax to call this function from the update module?

Hello - Is there a way i can change the color of the command buttons. I need
something else than grey.
Thanks for your help.

I am building a new database (mdb) and I am not sure if I should use DAO or
ADO?
Thanks

I have a button that I want to use to open a form that contains a tabbed
control.  When I click the button, it should open the form AND set the focus
to a specific tab.  I've tried the DoCmd.OpenForm method but I'm not having
any luck opening the specific tab.  

After switching from XP to Vista, I'm having problems with some code that
makes use of cdo (I'm using my ISP email account to send mail via smtp).
Initially I got back an error:
The 'SendUsing' configuration value is invalid.

I have the following code below, which works if I do the following
Call No1
'Call No2
Exit Sub

I have placed a subreport in the header section of the main report. The
subreport control has a caption, whcih displays OK, and the rows of teh
subreport display OK, but, the subreport header (which contains the subreport
column names) does not display.

Hi, I am looking to distribute a database that I created to a few users, but
I would like to send it as an executable rather than database to protect the
database and allow non-Access users to use the database.  Is this possible?  
Pleases excuse my ignorance.  I am still very new ...

Is there a way to recall a procedure name from a variable?
I am developing an app that has a table of clients, with different code to
be run, depending on the client. I loop through the Client table, and
depending on the client, run a different procedure because the things that