i want my Next button to go next if there is a record next. However, if
reached last record and user clicked Next, it should not go next any further
but shows a msg "your viewing the last record!"
can someone tell me how to do so?

I have a single form supplied by a query based on an underlying table.
All I want to do is have someone input a lot of data and I'm trying to
make it as simple as possible. There are three fields to input.
The first field I made unbound, the next two I are bound to the table

I need to check before print my report that the result of a query is zero
records.
Something like:
if qry1.recordset.count = 0 then

All,
I have created a database that has a sort of console main menu.  This is
small and is reminiscent of a media player in skin mode.  I have an anchor
button on the form, where i wish to code the following.  When the user clicks

My form has the order by property set to "[Birth Date] DESC" so that the
youngest is first.
The initial load with out a filter displays the rows in the proper order.  
Via code using an unbound textbox in the header section, the filter is set

How do you strip out the hyphens in the following numbers?
23434-200234-234
23423-324244-234
23443-234313-343

I want to pass some values from one form to another. I have a form
custsvcissue that is filled out by customer service with fields item and
problem etc.  The quality department review this form and if necessary
selects a button which opens a new form (frmCar) for follow up ...

I have a form (Access 2000) with store info on the top half and area info on
the bottom - not necessarily related.
I need to use a DLookup on the bottom half to follow the top. I have the
code for finding numbers, but what changes do I need to make to it if I use

Hello. I am searching for a solution to a search form problem. I am not very
familiar with VBA coding, so please bear with me. I have an Access db with 2
tables...structures and images. They are joined (one to many) by StationID
with each StationID having multiple images ...

I have three text boxes, i.e. "text box C" that sums up "text box A"
and "text box B".
I have a text box at the bottom of the sub form that sums up the
values for "text box C"

I've got a command button on a form which clears all of the current entries
in a table, and then adds a default set of entries (from another table)...
Generally, it works fine, but sometimes (I haven't found a pattern yet) the
displayed data is a form full of records marked ...

This code works great in one of my databases and I am tring to change it up a
bit to work in another database. I am have trouble, can anyone help here is a
copy of the code.
Option Compare Database

Hi, all!
Have a A2003 database where each employee team is to be represented by a
different background color on forms and reports.  On the setup form, I want
to pop up a dialog containing the normal Access "color picker" box like

Howdy all.
Trying to research how you return the readable name, e.g. Joe Blow
instead of 8 from a field, e.g. claimspecialistID.
Have a large SQL statement where the recordset gets exported to Excel.

Hi, I have a function that reads in an excel file and does a process in the
Access database.  I  want to know is there a way to move that file to another
folder when the process is done.  Thanks in advance.