I use the following code (behind a command button on the FE) to relink
from a user's local copy of the BE to the file-server's BE on our LAN.
I use this, for example, when a person brings in their laptop and
connects to our LAN.

I've used the following code to recreate the record count on a form,
where it says Record 1 of 200 or whatever.
Why would this work normal on most forms, but on a few it shows Record
1 of 1 when first opened. After you go to the next record it shows the

Problem is that there are lots and lots of fields in an employee record.  I
specify a form control as the criterion for one of those fields which is the
value of the primary key for that record.  The idea is to copy the current
record I am viewing in the form, to another table.

I'm using access 2000 and want to enter a value in a bound text box
using vba.
The problem is that when I step through my code, everything goes well,
but when my code is run the text box doesn't do anything.

Can someone help? I need to execute
strSQL = "SELECT * FROM qry_viewFDOExport" when a button is pressed and
the results displayed in a list box.
I want to do something like

This is a kindergarden question, but I have somehow got an internet (web) tool bar at the
top of my Access window, and i want to get rid of it! I just cannot find out how to. Can
soimeone tell me?
Thanks

I was reading on the mvps.org site not to use the lookup wizard in the
table design, but rather use a query.  I'm confused by this, given that
the lookup wizard basically creates a query and uses it as the data
source - you can see it in the "Lookup" tab in the table design window.

Seems ctrl-g is the hotkey combo to open
debug window. W/O using sendkeys, can
I open the debug window from VBA?

I am getting the 'User defined type not defined' on the line;
Dim fso As Scripting.FileSystemObject.
What am I doing wrong? What reference do I need to add? Do I need to
install/enable scripting on the win xp sp2 machine?

Where am I going wrong?
I have a form which has a record for each date on which I teach.  It
has a subform which shows the classes that I teach that day.  So I want
to be able to click on a calendar and jump to the selected day, so that

I need to include a picture / photograph in a Db then from a query
export to Excel - picture included - I just can't find a way through
this - can anyone please help? TIA JOhn

How can i break my access 2000 VBA project password ? it has been
locked and i forget the password. Pls help. Thanks.
Daniel

Dependent on the value entered in one field in my subform I would like to
display  a particular value in a neighbouring bound combo box, in the
subform,  called EventCode.
I've got in a mess with the syntax when setting the ListIndex.  The

I'm thinking this is simple and I'm just not understanding how to do it but
I have to ask because I'm  stumped.
I have a query (which is used to create a report) and three of the columns
in this query are Date, Charge by Hour, and Charge by Day.  In my report all

I have a subform control on a mainform. Each time I do anything
experimentally with it - like even change its Width property, A97
takes the liberty of setting values in the link child field and link
master field to a common field value. This is happening, I suppose,