Does VBA offer compound loop conditions?
Example:
       For k = 1 to n While( kn < km)
       blah blah blah

I am a new to programming in VB environment for Access forms.  I am trying
to write code on the AfterUpdate event of a combo box on a form.  I saved
the code and after closing VB I go back to the form design and in the
properties box for the combo box, I select code builder for the ...

Hi there,
I have a db of documents (tblDocuments), that have many revisions
(tblRevisions).
I need the previous field [Current_Status] on the Revisions form to update

I have a form which as the subject suggests I have configured as a
continuous form.
I was just wondering if it is possible to achieve conditional formatting on
this form based on the data for a particular row. For example, if in a row,

I am storing MOT as a date field in a table. .... unfortunately when user
types  04.05 ( meaning april 2005 - in Germany ) access creates stuff like
04.05.2005 .....-  4th of may :(
I am struggeling around on this date stuff already the whole morning ....

I use msinet.ocx to transfer a file from a local machine to the internet.
On my machine it works OK, but when I try to copy files to another machine,
it does not work.The message is
Run time 429, ActiveXcomponent can't vreate object.

How do I transmiited data fromExcel to Acces to match the name,date and
record id. The useres spreadsheet is all in columnn A, The spreadsheet file
will be named the same as the fileds entered on the Access table.
Example Requestor Name:  Charles Right.tblTapeTracking

Hi I have a drop down list on a form the has two options Min or Max.
the table the form is based on is using a look up wizard for the minmax
field.
I want this field to be filled in before the user can move on. I donot want

Is possible to use the Windows image list for icon display in my treeview
control? By this, I mean the source of all default application icons that
Windows displays in WindowsExplorer.
Would appreciate it you could point me towards a code sample or Key phrase

In the AfterUpdate event of the first of two subforms, linked to a main form,
I would likd to put in code that appends a record to the table in the 2nd
subform.  Then requery, if necessary, the 2nd subform so the new record will
show. How can I do this from one subform to ...

I have a listbox that lists a series of items that is requeried after a
combobox is changed (employee evaluations--the list of evaluation items is
requeried when you select a different employee).  When the user hits 'S' or
'U', the item is marked either satisfactory or ...

Help:::
  Here is what I have:
  I have a tblorders that I use for all my orders and tracking. I use this
table when I request new orders to be shipped from my factory. I can have

I have a main form with a combo and a subform that displays record
according to the selection in the combo.  I need to do something lik
If Team Leader ID = 4 in combo display in subform the selected field
from all records where Team Leader ID 1 or 2 or 3.  Form and subfor

I created a frame with 3 options buttons in it. I used the access forms
wizard to create the 3 option buttons within the frame.
I am trying to write some code to determine which
if an option button is selected.

Is there a way to update a single field or row within a listbox without
requerying the entire list?
Thanks,
Joe