Problem:
When moving between records, I need to control which combo/text boxes
are displayed on the current form, dependent upon data in the current
record.

Hi all you Experts,
I need to scroll a listbox horizontally.
For the life of me I cannot get it to move.  I can successfully scroll
it vertically.

hey all.. is there a better way to do this:
If IsNull(Forms!formquerybuilder.Controls!cboxupsource) = False Then
           Me!Text342.Visible = False
           Me!Text352.Visible = False

Hello Access Gurus,
I have Access 2000.  I created a Form with a Sub-report and that
Subreport has a Sub-form.  When I expand the Sub-report to show the
Sub-form scroll bars appear on the Sub-report so one can view the whole

I've got a screen that has a subform containing an indeterminate number of
records.
When the user clicks "Change", I put the screen into Edit mode by unlocking all
the subform's fields, setting the subform's.AllowEdits = True, .AllowDeletions =

I have the following code but it does not work correctly.
DoCmd.GoToRecord , , acGoTo, MySubForm.Form.CurrentRecord
When the code executes it does not bring me to the correct record.  If
MySubForm.Form.CurrentRecord is 1 it brings me to the 4 record not the

When a customer has made a down payment I would like to be able to have
check box that when checked opens another text box that displays
today's date and lock it in.
Where would I go about telling a text box to only be available if

Does anyone know of a way in MS Access to have the ControlTip Text that
can be set with a message to pop up with the date/time that the field
on the form was last updated along with the username of the person who
updated the record?  I'm using the fOSUserName() function from Dev

I've searched this goup for an answer to this, there are many
discussions that come close but non that I can find that actually
addresses this particular problem.
I'm exporting queries to Excel. These queries have memo fields in them

I have a problem I'm trying to figure out how to resolve in Access.  I
have a volunteer database for a project which occurs each year.  Currently
I have to go in and wipe out the data each year to start new.  I want to
somehow be able to incorporate the year's info into the database ...

does any1 know where i could find a video rental database?
thanx
dev

I often have recursives queries in my applications, like in this
simplified example :
req1 :
SELECT EmployeNo, EmployeName, EmployePhone

I am running an external application script through hyperlink on a
command button. When that happens, a windows warning pops up saying
"Some files may contain viruses, do you want to continue? "
How do I override that? I have tried Set Warnings False, but it doesn;t

I am trying to figure out the best way to get an alert in my Access 2002
Database when an invoice that is for an active vendor has not been received.
Ex.  I receive invoices on a daily bases.  If an invoice was received last
month, it is assumed that if the account number from that ...

I've searched this topic extensively, but no clear answer as how to
accomplish the following task in a proper manner has been found. I wish
to input pictures from a table that contains their path onto a form.
The number of pictures per record differs, thus the number of pictures.