Replies

Thank you Charlotte.

Code below works like a beauty and now I’ll integrate it into my program. BTW, it won’t work if the SQL specifies a join between the header and detail records, but in the Relationships window they are joined with “Cascading Delete” turned ON, so if I delete the header records .. eh voila! the detail is gone too.

Sub test3()
Dim cmdDelete As ADODB.Command
Dim strSQL As String
Dim conn As ADODB.Connection

strSQL = “DELETE tblPurchaseHeader.* FROM tblPurchaseHeader”
Set conn = CurrentProject.Connection
Set cmdDelete = New ADODB.Command
Set cmdDelete.ActiveConnection = conn
cmdDelete.CommandText = strSQL
cmdDelete.Execute

End Sub

Charlotte-oh-blessed-guru-divine … I can learn from you in 2 seconds what it takes hours to figure out by books. Thank you … I will do as you suggest and let you know how it works out.

Wow! SO SIMPLE and just what I need. Thank you Andrew.

Thank you so much Howard, I have both the Developer Edition and VB 6.0. There’s just SO MUCH to know. I’m going to start with password protecting and read up about compiling into DLLs.
Gwenda

Hi Wendell,
Thank you for your help. What is ADP?
Gwenda

Charlotte, your brain ought to be enshrined. I’ll get them to apply SR-1 and let you know what happens,.
Thank you,
Gwenda

Thanks Wendell. Yep — its a real Autonumber field. I think Charlotte’s suggestion to apply SR-1 is going to fix it. I’ll let you know how it turns out.
Gwenda

Thanks Douglas. I tried Compact & Repair … I think Charlotte hit the nail on the head when she says its a problem fixed by SR-1. I didn’t realize that you can over-ride autonumbers thru’ importing or appending. Do you know of a good place to read up on this?
Thanks again,
Gwenda

Wow! Thanks Charlotte — I knew I had seen these icons somewhere and have been casually looking for them in my VBE for months! Thanks, Gwenda

You could do this very easily with a report … and then you could look at it in Preview mode and it would function just like your query.

This is from Ken Getz/Paul Litwin/Mike Gilbert’s “Access Developers Handbook:

“To create a row counter on a report, set a text box’s properties as follows –

Set the RunningSum property to Over Group (1) or Over All (2)
Set the ControllSource to =1

Eh voila!
Gwenda

He sent me a screen shot which I attached to my original post. The “annotations” look like pop-up formating descriptions and the text looks marked-up.

Thanks Dreamboat … I sent your response to my user. And yes, he insists that the annotations are printing.
Gwenda

Thanks for all of your help.

Great list but don’t forget
CUSTOM PROPERTIES!

Hi Andy,
I’m chicken … afraid of calling your DLL in my Access program. Don’t I have to register your DLL first?
Gwenda