I want to delete a file in the rootdirectory  (c:\) of my computer. How do I
do that?
I tried
htask = Shell("del c:\example.mdb")

I need the code to refresh linked tables please.
The location may change so we need to call the linked table manager.
Thanks
Chris

If have this code in the BeforeUpdate event:
   If Me.Dirty Then
       If IsNull(text_switch) Then
           MsgBox ("My Message!!!!")

Does anyone have a lead on a definitive reference for the sequence of events
in moving from a form to a subform and back to the main form?
Specifically, I have multiple subforms for entering a variety of data.  My
main form has a subform control whose recordsource is set depending ...

I have three fields I would like to require:
[County] a text box
[PCompany] a combo box that gets its data from another table
[MList] a yes/no radio group

Is it possible to code the margins maybe in on open event? The secretary's
access reports seem to change to my larger margins (because i have an
inkjet) and after I modify our database. she has a laser and needs the
default smaller margins.

I developed a form for a user in Access 2003 works like a charm.  He only
has 2000, told me after the fact!  Upgrade is not option.  Have to change my
forms to work.
The form has 4 command buttons on it that with a coresponding text box

New again to Access programming and not to familiar with VB.   Would like to
use the DoCmd.RunSQL to excute a SQL command to select a value from a table.
Finaly got the SQL statement correct, I.E. copied form SQL builder, and it
runs with no problem.  However when runing with the ...

I am looking for a template for Access 2003 that will help me keep am
inventory of items in my home.  I see one out there for Access 2000 but not
2003.  Is there any newer version or does anyone know how I can use the 2000
version?  Thanks in advance.....

I have an Access 2002 application that's been running for years. One feature
is a button on a form that copies the string contents of a control to the
clipboard. This morning it stopped working and gives this instead:
Run-time error '2046' - The command or action 'Copy' isn't ...

Hello Anyone?
Why doesn't Example A work but Example B work?
Example A
   If Me.txtLength > 0 And Me.txtCoilListGauge > 0 And Not

Can anyopne help? I have a system with lots of VBA coding, and I want to be
able to switch working currency from Sterling to US Dollar and back. How do
I do this? Any ideas gratefully received !!
Thanks