Replies

Thanks for the replies. As usual immediately after posting my brain kicks into gear & I solve most of my problems. The delete after hotsync is now working, I had placed my code in the wrong place.

The editing has still got me stumped though. Definitely using PDBUpdateRecord.

Neville

Thanks for the replies. As usual immediately after posting my brain kicks into gear & I solve most of my problems. The delete after hotsync is now working, I had placed my code in the wrong place.

The editing has still got me stumped though. Definitely using PDBUpdateRecord.

Neville

Or you could try this

http://www.copernic.com/en/products/summarizer/index.html%5B/url%5D

Or you could try this

http://www.copernic.com/en/products/summarizer/index.html%5B/url%5D

This happens to me also but I don’t have 97 installed and haven’t figured out why.
Neville

That was simple, Thanks

Have you left any recordsets open, and then re-opened them? It also pays to set them to ‘Nothing’ after closing.

Failing to do the above will gobble up your memory.

I still need help. What has got me bluffed is that the same code works in my working database on the same PC.

I usually place the list/combo box on the main form to select whatever record I require, the subform data automatically displays provided the parent child fields are set correctly.
It seems to me you’re trying to work back to front, finding one record from many rather than many from one. It may be able to be done but I’ve never tried.

Thanks Charlotte, that’s what I regard as clever thinking.

In O2K under File menu there is a Send To option. However if the data for each recipient differs, this method will send the complete report to each recipient. The other alternative is to use automation.

It may be easier to filter the report for each recipient and then email.

The number of columns is set under page setup. If the parent report is set to one column the all subreports are also set to one column.

I know of no way around this, as I attempted to do the same recently.

Public Function f1(args) As Boolean

if args=whatever then
f1=true
else
f1=false
endif

End Function
===========================
This function is triggered by the onclick event of a control on a form like this
======================
Private Sub Command472_Click()
DoCmd.OpenReport “R1”, acViewPreview
End Sub
============================

Public Function beepit()
DoCmd.Beep
End Function
==========================

Private Sub Report_Open(Cancel As Integer)
If F1(args) Then
Beepit
End If
End Sub
==========================

If you don’t want the user to change an existing record, you could use the NewRecord property to check for an existing record, display a message box to infrom the user, and then use the OldValue property to reset to original value in the OnChange Event.
There’s probably better ways of doing this, but its the first thing that came to my mind.
Neville

Actually Charlotte mentioned using the sub-forms ‘on exit’ event, but was unable to find it on the forms property sheet. Well I have now, tried it, but apparently it isn’t activated if the subform isn’t entered.
Kevin mentioned a ‘query close’ event, where do I find that? I’ve never heard of it.
Anyway, I decided to do some deep thinking (God it hurts), and explore using the main forms ‘on current’ event to solve the problem, as this is the only event I found to be activated if the navigations controls are used to move to another record.
Thanks again.
Neville