Hello, everyone. does anybody can help me out? I want to locate and write
data into the empty field which I konw is on 101 row. there are 5 rows need
be writen.
After debug the row number moved to 283 for some unkown reason.

I have a crosstab query that run allright, but exporting result fails each
week as new column is added. I have excel template and finalising the report
happens in Excel.
I use this command to export:

I hve finalised my an application using Access 2007.
It was working fine.  Then suddenly it came up with an error message
on Append Queries.where I sum and ave data
"Reserved Error (-3087)"

Hello Group,
I'm extremely rusty with my coding and trying to do something that I THINK
should be simple.  I'm trying to write a string, WholeFile, from Access 2000
vba to Word.  I don't need to format it just get it over there.  I've set my

I would like to populate an array from a form event, and use the array from
other procedures of the same form.  I can't declare the array as public at
the module level, however.  Can I make an array accessible to all procedures
in a module?

I have a database to track project results built on two tables: One linked
(and read-only), the second read-write. Both tables include a field called
"SessionID," which is foreign in the second table. This field is linked via
relationships: Display all fields in linked table, and ...

I have been noticing that when I write a line such as 'Me.Trim()', the
editer converts the 'Trim()' function to lowercase when I move to another
line. For 'Me.SetFocus()', it converts 'SetFocus()' to 'setFocus()'. However,
the 'Me' keyword is converted correctly if I use all ...

I have a large sub that I need to break down, so I am trying to pass an open
record to a function and get the record back... with the contents altered by
the funtion.  I am getting a Invalid Use of Property error.  Is it possible
to do what I am trying???  Here is a stripped down ...

I just installed the new Service Pack 3 for Office 2003.
This has caused a strange display problem in Access 2003 with combo boxes on
tables that have a formatted text field.
To see this problem, create a table named TableX with a single key field

If I call a function, how do I get the values gathered before making a call
to the function if I call the function in the middle of script?  I have run
into this several times, as I don't want to have to keep asking for the same
values that may be used inside the function.  Exp:

I'm just looking for a clever way to pass a WHERE clause to a report that I
am sending via SendObject.
Real-world: I want to e-mail statements. I have already written the
recordset loop that goes through all the customers that have e-mail addresses

Hello folks, I am wondering of anyone could help me out here.
I have a database I am building for a project with two tables . One table is
read-only, and linked to another database. The other table's data is
generated from data added to a form based on the data on the read-only ...

Hello,
I'm using the Microsoft Scheduler to schedule 6 access application.
Each application is scheduled on a different time starting at 03:00 am
and the last one is scheduled 07:30 am.

I have some report information that is being generated using dao recordsets.  
The reports read the info, output to a file, and finally emailed to the
recipients.  I have completed all the above in vba code with one possible
problem that may exist.

I have created a routine for appending two tables (in an Access Project) to
create a third one, but I think it could be improved.
   DoCmd.CopyObject , txtTableNew, acTable, txtTable1
   strSQL = "INSERT INTO [" & txtTableNew & "] " _