Recent content by robinsql

Thanks for the help Mike. I actually removed the collate from my code and it seems to work now. Thanks, Robin

Hi folks, Am stuck in work until I can solve this one. I am printing off delivery dockets. 2 of each one. I need these to collate and print as one job so they can be stapled. At the moment they are printing as two separate jobs. I have selected the collation as crptCollated and CopiesToPrinter...

Thanks for the help guys. Just got back to work now. I got it to work but am not quite sure how! Something to do with logons and pwds. Thanks again.

Hi, In a fairly serious spot of bother here. I am trying to configure a machine so that I can use SQL Mail. The error I keep getting whenever I try to use xp_sendmail, is the following... Server: Msg 18025, Level 16, State 1, Line 0 xp_sendmail: failed with mail error 0x80040111 On the PC I...

Hi, I'm trying to debug my dll, but am for some reason unable to step through the code. I managed to do this last week by having the vbp and the dll open at the same time. I ran the dll first and then the vbp. I was able to step through the code without problem, going into the dll whenever a...

The app only runs on a server as a scheduled task. It is not use by any other workstations, so that should not be a problem. Thanks anyway.

Thanks, will do. Sorry about double post - just thought this was a better forum to post in and had previously posted in the other.

Hi, I have an application which runs fine on my development PC which is running Win 2K, but when I try and run the same app on an NT machine, it fails and returns the above error. I have searched the web for an answer and have done the recommended steps such as registering scrrun.dll. The...

Hi, I have all the references. I have created an msi which includes the dll I wrote. It should be ok really. It's incredibly frustrating.

Hi, I have migrated a VB/Access app to VB/SQL 2000. The DB and the app reside on an NT server. When I test the code on my local PC, it runs fine. When I try and use the NT server, I receive the run-time error message '429'. I have registered the DLL using regsvr32 from the command line. This...

Sweet, thanks for the help!

Hi, I keep getting the following error when I get to the second line of the code beneath... Item cannot be found in the collection corresponding to the requested name or ordinal. sSQL = "EXEC sp_SaveCapex " params listed. Set rsProposalNo = g_Conn.Execute(sSQL) g_iProposalNo =...

Hi, Can somebody please explain why this returns -1 as the recordcount when there are in fact, two records? rs.Open sSQL, m_Conn, adOpenKeyset, adLockOptimistic lNoOfCartons = rs.RecordCount Thanks, Robin

Hey CClint, Thanks for your help. Couldn't get back to you yesterday as we had an internet problem. Unfortunately I have not found a reason for the error, so I have just decided to use oConn.execute instead. I don't suppose this will harm the program. The reason I was reluctant to change it, is...

Same error