Hello and thank you in advance to anyone who may assist me.
This will be the first of a few posts I will be making.
I am  trying to query data between 4 tables (Line, Load, Fuse, Recloser).
The fields I'm attempting to join are:

Morning Experts,
I'm using wondering how i can switch on Cascade delete within a database im
creating programmatically.  I have it all working created all the tables
e.t.c. However I want to know how to implement Cascade delete throught SQL

I'm having some troubles using a string array in a module in VBA.  I can
dimension the string array but am unable to set the variables equal to a
constant within the module (Really needs to be in the module).  Actual code
(all two lines of it) is near the end.

What code can I use to change hide an existing table (dbhidden attribute),
and what attribute reverses dbHidden to make the table visible again?

Is there a way through code to remove (not change or modify) a custom
database property.  I don't want to go in and manually do it.

Can anyone help me with a string function that splits a name field into 2
seperate fields. In the column name every name is entered with LastName
FirstName and I ned to move the LastName and the FirstName into seperate
fields.

I need to edit sql code of exsisting query, from vba. Does anybody have some
expirience with that? Thanks

I was wondering how i could trigger a event if one chooses an item in a
customized menu.
For example, i have a menuitem called mailings. In that menuitem there are 3
subitems to choose from. The items are text based.

Hi everyone, I coded some VB for a report that used to work fine. Now I
changed from Access 2000 to 2003 (and different computer) and now the output
results into #name?
The code: (shorted due to repeating simular actions)

Please help!  This is incredibly frustrating. :)
I have this code:
If IsNull(varGenSN) Then
   Response = MsgBox("Generator does not exist.  Would you like to add it

I have two issues with this code that I am running.
1st, Once I click the button I expect the “DoCmd.Hourglass True” to turn on
as soon as I hit the button, but it does not.  It takes up to 5 to 10 seconds
for it to come on, even though it’s the first line in my code.  Is there a

Group:
I have a Help menu, and the first menu item on it is labeled:  Program
Help...    F1. I have created a help file named DCHelp.chm that I want to be
opened when the user selects Program Help... from the Help menu. I have set

I am trying to populate an unbound continuous form but it does not seem to
work. I have setup a generic form to test this and have set up an unbound
field named child. I have set the form to continuous view and inserted this
code on open

Dear Alex
I raised a query some days ago and u satisfied me. In continuation of that
Still a problem.
Problem is that I'm getting the message or error " #Name" in the textbox

I am upgrading an Access2000 database and need to be able to print barcode on
the reports.  The same numbers would be printed in barcode format in a couple
of places on the reports.  Any help to do this would be greatly appreciated.
Thanks ..