I am TRYING to insert into a table os a database that I have successfully
opened.
I use a ADODB.Connection object and the Execute method.
The table has only two columns: an autonumber item and a string item.

I would like to avoid letting users choose the path.  I would rather deliver
the path in code from a list with a for each statement.  Maybe do a check if
path exists=true then refresh the link.
Realy all i need is a refresh table link method which I can't seem to find.

I have a refresh data button in my form header. I'd like it to refresh
everything including the subforms, however, the subforms aren't refreshing.
What can I add to the following code in order to achieve this?
Thanks in advance!

Some days ago 'Brian' gave me a good solution to having the back style of an
Image control conditional on content/no content of field
txtImagePathAndFile. Brians solution is the following:
Private Form_Current()

I'm looking for a way to refresh table links in code.  I have A front end
that is distributed to different offices with different back end files which
have unique names.
I would like to link or refresh the table links in code when the database

I need to accomplish to things with a switchboard form and I need to know if
it is possible.
1.  Dynamically set the list of switchboard items based on the user that logs
in.  I created a t_user table that will keep information such as what report

I am trying to create a new field in the backend .mdb via code. Being
unexperienced at this I have been using various portions of code I have
found in books and at web sites. The code below I understand creates a new
table and then puts the field NewField in that table.  I tried ...

Reiterating the question:
Why would a (ADO Recordset) bound ComboBox control not allow me to edit
contents?  I don't know if it helps to say that the recordset comes from a
called to a SYBASE stored procedure.

A2K
I have a subform based on a query (which takes data from two tables)
that runs some calculations on that data which then puts the final
product into a new table.  I do this by opening a recordset using the

Hi, all
   I'm trying to automate an Access Application. I can access the "Forms"
and "Reports", but I do not have a good and efficient way to access the
controls.

I'm working with a DVD library I'm making and I decide to change a listbox to
a TreeView control. as I'm writting a little code to pull up a record when I
click on a TreeView node, my form slowly starts acting wierd. 1st I can no
longer programmatically change the selected status of ...

Hello;
My project is almost done but there is one little behavior that I don't want
my subforms to do that is driving me mad.  I have tried different things to
no avail.  Here is the setup:

I have a form that is bound to a recordset during the form's OnOpen event
(see code below).  This seems to work correctly in most cases.  When I try
to open the form to add a record, it doesn't behave as i would expect.  From
another form, I use:

I need to insert a row in a subform and I thougth right clicking on the
record selector would be the easiest way... on form view when I right click
the only options are copy and cut and once selected, paste. I've tried to
create a custom form menu and that is not working either. ...

Here's the scenerio -
Example for Alaska -
If the f/c institute date is before or equal to 08/31/2005, it needs to be 7
If the f/c institute date is equal to or greater than 09/01/2005, it needs