If you have a corrupt record somewhere in a data table, how do you
find/eliminate it?
My tables have relationships on key fields that are autonumbers. I believe
that this will make creating new tables a nightmare as auto numbers would

I have a form with a list box which gets its values from a lookup table.
Upon submit, the form provides input to an append query.
Column1 is bound and works fine.
However, I also need Column2 in the query. How do I reference Column2 in the

Hi;
Using A2K.
Have this code in the "On Dbl Click" Event of an "OLE Object" type Control:
   RunCommand acCmdInsertObject  ' Opens "Insert Picture From File" Dialog

db.Execute "ALTER TABLE [" & vTableName & "] ALTER COLUMN [" & vFieldName &
"] TEXT (" & vParameters & ")"  'change field size
where vParameters = 10
Gives Run-time error '3293'

I've tried to use this as the source for the 2nd field but the field shows
#error
Thanks,
J

Ive displayed the parameters of a query on a report before, simply by
entering the name of the parameter in the control source of a textbox.
However, that approach does not seem to work if i want to display the query
parameters on a form.

Currently I am trying to create a form that after I enter like an employee ID
number the rest of the employees information would fill in.  If the employee
has not yet been entered into this database it would leave everything blank
to be filled in by the user.  Is it possible to ...

Hi all..
Is there a way to assign the source of an image object to a www
location? What I'm looking to do is to have an image object that I can
freely change on a website, that will be loaded each time a user opens

Hi and Help
How do you find and eliminate corruption from tables

Access 2000, Win XP
I have a form with a Listbox control which shows a list of files in a
particular folder on the Server PC (via a network). I want to be able
to click a button on the form and open a window on the same folder so

GlacierHi -
I'm just starting to learn access and need some assistance with my project.
I'm trying to design a db to track the login and logout times of users.  My
concept is to have a form linked to a table that contains the member#, Name,

       I asked how to do this some time back, and got a response from Allen
Browne, explaining (in part):
If the subform is name Sub1, and the procedure is named Text0_AfterUpdate,
you can then call it like this:

thanks for your response to my earlier post:
http://www.accessmonster.com/Uwe/Forum.aspx/access/102015/help-dirk-goldgar-or-s
omeone-familiar-with-Dev-Ashish-search#8337047de6654uwe
I am still not able to use the export option command on this dev-ashish
search form..

Simple question, just a few tablles. The database is normalized, 2NF I
believe, but I can't get more than one relationship to show on a form.
Table1:
CustomerNumber

I have a form that will post the daily expenses. This form takes the records
from the query.
In the query I have set the citeria for date range. During the citeria filter,
there are dates without expenses records. When there is totally no records on