Some time ago I posted a question about a database not working properly when
it was split, and Douglas J. Steele explained that it was because dbOpenTable
does not work in a split database, and he very kindly supplied revised code.
I had problems with getting the code working ...

I have the codes as following.
If (IsNull(Me.CLASS.Value)) Then
           lblPrompt.Visible = True
           Me![Subform].Visible = False

I'm using VB to attempt to autopopulate a tabular form I created to maintain
track of my company's open projects. A friend of mine provided the code that
allows me to pull my information from my query. The problem is, is that my
query has over 20 columns and every time I attempt to ...

Is there a way to set all checkboxes on a Continuous Form to true.
The code below only sets the first one to true
Me.Transfers1_subform.Controls("Completed") = -1
Thanks Mike

within in a vba program I am able to open a form object.
? oform.onopen  =  "[event procedure]"
My question is how do i find the actual text in the event procedure.  Any
suggestions would be greatly appreciated.

I have the following lookup in the 'After Update' event of a field (Order
Line Status)...
Dim TFlag As Variant
TFlag = DLookup("[OrderLineStatusClosed]", "tbl_OrderLineStatus",

What can make the saving of the form become too slow?
I wait about 1 minute to save a form.
Is it because it has many controls, subForms (subForm's SourceObject is set
on runtime), code module and images..

After years in software development/database programming mostly on
Unix/Oracle I'm tasked to change some Access forms to use redesigned
tables. I'm having trouble with the relationship between forms and VB.
For example I'm looking at some VB code that frequently references the

I have a customized toolbar and have the 'view queries' button included on
the toolbar. Can someone please advise when or how this button is activated.
Regards

I have a table which has index on id and Amount field (table 1). The table1
has more than 20,000 records and will keep increasing. There is another table
table2 which is related to table1 by id.
I have created a form based on the query which links table1 and table2 by id

CAn anyone tell me if an Access report can be saved as an HTML document?  If
so, can you advise on how to do it or point me to a resource?
Thanks,
Rich

I have several text boxes on a form, each that I would like for their
corresponding button to become the default, so the user can use the 'Enter'
key to click the button.
I can think of different ways, like the 'got_focus' method, but thought I'd

I have a form in Access XP(2002) that contains an unbound subform when it is
initially opened.  There are also 15 buttons on the form that will each load
a different subform when clicked.  All of the subforms are the same width but
each have a different height.  I would like to ...

I have a ComboBox1 which has two column and the first columns is
bounded. Simply like that:
Supplier-ID   Supplier Name
124556        Microsoft

Hello and thanks in advance
I'm trying to take a textfile that my company uses for Machine Programs and
convert it to a different Machine Format.  With one execption, this works
very well.