I have an intiger field "Priority".  I would like to write a simple loop that
updates all records when one records "Priority" is changed.  For example, if
I have a record that is currently listed as Priority 5 and I wish to change
it to Priority 2, I need all 2 to be come 3 and 4 ...

I need to do this to each record in the table, saving the Street# and
StreetName in two fields of each record.  From here, I can sort by
StreetName/Table

I keep hetting the error 2105 when using gotorecord acnext at the nd of a
dataset. I cannot seem to get a custom error handler to work. Is there any
way to avoid this such as checking if this is the last entry before trying to
go to the next?

I am working on a recordset inside of a subform.  I have a procedure that is
supposed to run whenever someone updates a date field in the subform.  80% of
the time it works fine, however, 20% of the time it crashes.  After the date
has been updated the procedure starts, the ...

Hi, I'm using Access XP.
I have a field called Follow-up which needs to store either 1 Hour, 3 Hours,
1 Day, 1 Week, 1 Month or 3 Months.  I will set up a combo box to give the
user these choices, but I can't figure out what data type to use - I see

I have been writing in Access for quite awhile now. My current client wishes
to take some data from one of my databases and move it to a mainframe on a
weekly basis. Does anybody have any ideas out there about how to accomplish
this or maybe can suggest a source of information? ...

  First let me start by saying I'm quite limited in my knowledge of VB, but
I'm trying.
I have a form with a field which has a default value of "=fOSUserName()"
which is a module created using Dev Ashish's "Get network user name" code

I coded the Form_Current event procedure so that when the user clicks on the
NewRecord button on the navigation bar, an information message is displayed.
Everything works fine so far.
My parent form contains a child subform that also displays a navigation bar.

I have 3 tables that are linked.
Category Table:
      Category ID (primary key) -autonumber
      Category Name

I have the following Dim statement in a module:
Dim fd As FileDialog
I have the library Microsoft Access10 Object Library referenced. However, my
program breaks on the Dim, with the error message "User type not defined."

I need to activate certain VB reference libraries within a VB6 project using
code (e.g. Microsoft Office 11.0 Object Library).
This will ensure all users applications have reference to the correct
Reference library!!!

I went through the filling a treeview recursively example and it worked. When
i try to apply the load event part of the code, it gives me an "user defined
type not defined message at the third line of the code.
Private Sub Form_Load()

If I have a query where two of the columns are as follows:
GroupID   Style
1876       S100
1876       S101

I am trying to find a way to detect the status of a scheduled task defined
under Windows Environment.  Is there some API available for Access (VBA) or
other programming language (C, Java, etc.)?
I could think of other means to workaround and solve my problem but I prefer

I have this code for a button that excutes based on the data in the box next
to it, what should I change to do this?  This data is www.domainname.com  I
want this button to be able to pull this up
http://whois.sc/www.domainname.com.  So when you click on the button, it will