Search results

Thanks again -- the code works fine! My colleague helped me with a few modifications though: Public Function Duplicate(ByVal strKey As String, ByVal strTable As String, _ ByVal lngID As Long) As Long On Error GoTo Err_Duplicate Dim db As DAO.Database Dim rs As...

Well, it sure looks a bit shorter than the previous code. <g> I'll try it out straight away, thank you! Ute

Sorry to drag this old thread up again, but I tried to use ghudsons's code too -- and it doesn't work for me, for some reason. (WinNT 4.0, Access 2002) The Button does just nothing. No beep, no duplication, no error message, just plain nothing. I have 77 data fields, one of which ("ID", primary...

@Oldsoftboss: That one was precisely what I was looking for, thanks a bunch! :) Ute

Oh, thanks, I'll try that a.s.a.p. and let you know whether it works. :) Have a nice weekend! Ute

Same result as before, I'm afraid... Is this perhaps because I'm using a dialog box that comes straight from the system rather than Access itself?

I had already tried that but it doesn't make any difference whatsoever, I'm afraid. Are there any other things I could try? Thanks & regards, Ute

Hi all, sorry if this is a daft question - I come from the PERL and JavaScript corner originally and my boss has suddenly decided that I should do some Access stuff as well... :rolleyes: In a project of mine, I'm using the following function: Function LaunchCD(strform As Form) As String...