What is the recommended way to copy a single record from a query or from a
table into a table?
Is this the only way to use recordset: rs![Field1] = rs2![Field1], or is
there a rs.record.copy method or some other way? I know that I can also do

Hi you all!
This is tooooo weird! When I'm trying to insert a new variable to my module
(dim i as integer) or a new sub or a new function, I get an error:
"Out of memory"

I am getting an error No value given for one or more required parameters
If I replace the managerID with a number code works. I have tried putting a
textbox
on userform to hold the value of Column(2) on cboStoreIP Change event but

Hi,  VBA newbie needs rescuing.  I am trying to export the same query with a
changing parameter (manager name) to the same destination and then run a
macro to do some formatting in excel for each sequence.
I have progressed to the following but its not picking up the Manager

i have a db and i want to send emails. but in the sendobject function i want
in the body text enters how does i give that, i can only write text without
enters.
I hope someone can help me

Hi,  
I have Access 2003 database that prints a report to to PDF and then mails it
out. That is working  just fine.  
Now what I need is to be able to delete the once the email has been sent.

I am successfully able to perform some tasks and open Access using the
scheduler.
Is there anyway I can bypass the database password ( which is prompted while
opening the database), Cancel or Open button and Autoexc macro?

Dear Sir,
I have one access database secured by Access03 User level sytem. The users
have to login and use the forms to enter or change the data. All is perfect
except that some of the access familiar users are accessing the table from

hi,
i have a piece of code which i want to automatically use to change a value
of a field once the button has pressed.  the code goes to the necxt record
and is supposed to automatically fill an entry with a number.

The sample code at the very bottom works, but I have to list each Org Code
using "Or".  Is there a way to change the first line of the If statement to
use "Between" or "In"?  Such as:
If myRs![Org Code]  Between 109011 and 109051 Then...

Hello, I'm new to access so please bare with me. I have created a
database which records information about cases, in this form is a lab
number column that i want to increment to the next unused number, with
the click of a command button on the form. The format that I want to

Can someone look at this and tell what could be wrong Please
Private Sub cmdPreview_Click()
On Error GoTo Err_cmdPreview_Click
Dim objConn As ADODB.Connection

I am fairly new to Access VBA programming so please bear with me.
I am working on a form which has 2 combo boxes.  The first cbo will display
1 of 2 possible company names which are selected from a lookup table.  Each
company has a number of departments associated with it.  This ...

I am using Access 2002 (at least I will if I can do this) with Office 2003.
I have an application that I need help with.  It starts with the program
retrieving a text file from an FTP site.  The program then reads the comma
sperated text until the end of the line and uses the text ...

When I have used a sub form within a form, I have usually used a query or
table and that has enabled me to bound objects together, this time I am using
a table or query from another database. All my objects are now unbound and
from the Open_Form() I load in the query or table ...