All,
 I would like to create a professional looking cover sheet with
information loaded from an MS Access Report.  I created the cover sheet
in MS Word that includes my company logo, etc.

When using DAO user newpassword function how do you get old password
with out prompting the user? Or how can you retreive it without
prompting user?
user.NewPassword oldPWD, newPWD

I downloaded Steve Leban's RTF2 control and it works as advertised.
Good news!
After reading reference material on the RTF standard codes, I have been
able to write update queries to universally change the font or font

I am building a shipping and receiving database.  I have a receipts
table and a movements out table.  I have it set up so that when I
receive and item in it auto generates a Tag ID#.  When I create a
delivery of that item, the next time I have a delivery, I do not want

Can anyone think of a way of doing this?
I have a readonly subform with no active controls but I want to activate the
control box rather than have a field in the next subform activate.
Thanks in advance,

Done a lot of forum checking, tried several possibilities.
Still not getting it to work.
Please show me my error!
form has several combo boxes storing an integer or nothing (were not

Please help.... I have a form that I successfully add records to that I
want to copy and turn into a form for editing records from that same
table (It is imperitive that it be done this way, rather than just one
form) ... I need in the textbox for the new edit form to have the user

Dear reader,
The following functions gives me some problems: Mid([FieldName],3,2) and
Left() and Date(). On one pc it works perfect and on the other one an error
message pop's up "Not a valid instruction". After a disconnecting and than

Hi: There are two textboxs in my main form. One is bound and another is
unbound. There is no entry in the unbound textbox as values come into
automatically after entering some information in the subform. My
question is how to i pass values from unbound textbox to bound textbox

I am able to add records to my SQL 2005 database using bound forms in my
Access application, but if I try to edit any records (not only the new
records I create) using the same bound forms, I receive a write conflict.
For the record, I am currently the only user of this ...

I'm converting from 97 to 03, and I'm having trouble with the forms.
Although I can see individual forms on their own, I cannot use command
buttons to jump from one form to the other.  When I click on the
command button to open another form, I receive the debugger window in

vb6,ado,mdb,win2k
i pass the sql string to the .Execute method on the open connection to
Table_Name(const) db table
fwiw

What I'd like to do display a form that consists of subforms, and
allow a user to resize the sections of a form at will.
For example, if a form has three subforms, each placed vertically and
using a 1/3 of the width, I'd like the user to be able to grab and

i need to enable my client to enter data into an Access database that i
have developed using a hand held Palm Computer or PDA (whatever you
call it!).
what is the best way to do this .....

I was just wondering, is there a way to create a macro everytime a
certain database is created? I mean, on its own.
I'm writing a VB.Net program that requires me to delete the database
everytime, before executing the code. The code then creates another