I have an Access 2000 application using Acrobat 5, that prints a report to
PDF using VBA code, that works great.  I am able to change my printers in my
registry to the Acrobat PDFWriter printer and set the destination PDF file
name, so that there is no interaction with the user ...

I have a simple table with two fields, DocID (text) and Doc (OLE data type)
in table tblDocuments.  I inserted a pdf file type using the access drop down
menus and gave it a DocID of "Codes".  In the table view when I double click
the Adobe Acrobat 7.0 Document in the Doc field ...

I am teaching myself VB and it is not going well. I thought I found what I
needed on another web site and I altered the code to reflect my database and
it is not working. I keep getting a data type mismatch.
My form has 5 list boxes. Each of the boxes is based on another table ...

How would I create a next button that jumps from week to week. I have a form
that lists records for the entire year. When I press teh Next button, instead
of scrolling record by record, I wish to scroll week by week. The form has
already the week number (1-52) for all records

Why does this code for updating a single existing record in a linked table
not work please?
I see the updates in the recordset, but they don't get written back to the
table.

I'm a novice with VBA but I try to explain my problem.
I have a masterform in which I select a record out of a listbox.
This show me the details of the record.
On the form I have a button that leads to an "Update"form.

On a form I have textboxes linked to a query (giving one record). Clicking a
button, I go to the emty record. Filling this in I create a new record.
When I push a button <cancel>, all has to be as before. I work this way: I
go to the first record to delete possible changes ...

Hi - Does anyone know if I can use VBA to place a subform on a form and if
so, what the syntax is. eg on form 1, I might want form 2 as the subform or I
might want want form 3 as the subform. Thanks - Jenny

How can I check if a form is open, I would like to run some code only if
another form is open. How can this be done? Any help would be great.

I have the below code that I am using, it has no problem connecting to the
table in Access, however when it goes to write the data to the table, I am
getting a Syntax error that says, Syntax error in INSERT INTO statement.  
anyone got any ideas of how to fix this?

I posted this several months back,  PLEASE, someone knowledgeable give me
some help.
I am learning about Visual Basic.Net.  The exercise currently is to
programaticically open an OLEconnection to an existent database.  I have

I was using msrichtx32.ocx with access02-we upgraded to access03 and the sky
fell in.  I need selprint, sellength and selstrikethru.  Didn't find these
properties in RTF2. Does anyone have any info on other ActiveX Rich Text
objects that could help me? Thanks!

I recently starting creating MS Acess projects and have run in to a problem.  
I create the project and then import my forms and code from an Access .mdb.  
When I debug my code, I noticed that my variable does not accept the result
of an addition of fields.  I am adding the values ...

I am new to the Access Object Model and I am trying to move some macros that
I have to VBA code.  Can anyone please help me out by indicating how can I
access the value of a field from several tables.  I think I can preatty much
figure out how to calculate those values but I am ...

I am rewording my question as I may not have made it clear
last night.
My problem is when exiting a database in 2002 the .ldb
file is not being deleted therefore making the database