Search results for query: *

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...

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...

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 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...

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

Hi all, I'm in a serious spot of bother with this one. Line 2 of the following code returns the error... Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Line 3 runs fine. Can anyone explain to me what the problem is? I need to resolve this...

Hi all, When I do a select on my table, using certain criteria, I get an error message saying "Not a valid bookmark". When I open the table directly, it opens fine, but then if I scroll down the table, I get a brief look at rows where #Error# is printed across each row, in every cell...

Hi, I am running a piece of software which uses two scanners in two comports on my PC. When information arrives at the Scanners at the same time, I get an error saying the DB is locked, as it can't do the update at the same time. How can I prevent this from happening? Can I check the state of...

Hi, When I run the code beneath which is in a DLL, the last line gives me the following error message... "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" Dim oRs As Recordset Set oRs = New Recordset Dim strSQL As String strSQL =...

Hi, I'm reasonably new to ASP and I am trying to maintain somebody else's code. I was wondering if anybody had seen anything like the following before. I am about 70% certain this bit of code prevents certain users from accessing whichever page this is written on. It is at the top of all...

Hi, I am using a simple query... SELECT * FROM PerfectAttendance PerfectAttendance is a query I have saved. I run this query prior to selecting all from PerfectAttendance using the following... sSQL = "Exec PerfectAttendance #" & Format(dtFromDate, "yyyy/mm/dd") & "#...

Hi all, I need to return a list of pupils with my query. I have three tables.. 1. Lists all the dates for a given year and their descriptions, as in weekday or weekend Fields: DATE, DESC 2. Records all clock-ins. Fields: DATE, TIME, PUPIL_ID 3. Pupil Details. Fields: PUPIL_NAME, PUPIL_ID I...

Hi all, When I view my report in preview and then try to close it, it goes to the design view, instead of closing it completely. Same is happening when I try to close my preview window when I am viewing the report from my VB app. I need the report to close fully, not show the design view. This...

Hi, I have a field called Time on my report which I only want to print should the time on each record be greater than 9:00. How do I do this? Thanks for any help, Robin

Hi, I am trying to get a distinct count of the phone numbers in the two tables, tblImportCalls and tblCalls. When I use the statement beneath it returns a count of distinct numbers which appear in both tblCalls AND tblImportCalls. I need the count to reflect the fact that there might be...

Hi all, I am using the Crystal Report Viewer to view reports from my VB application. It is using an ODBC source. The report runs fine from the development PC and from the first 2 PC's I installed the app on. However, when I try to run the report on another machine I get an error message saying...

Hi all, When I try to run my program, it gives me this error. It used to run fine and I would have guessed that it is missing references, but it appears not to be. It hangs on the trim function, and if I remove that, on the comRTS of the comm control. Anyone any ideas what this is? Thanks for...

Hi all, I am using VB6 and connecting to a SQL 2000 db using SQL authentication. I am trying to run a Crystal Report for one of the tables. I have set up the report using the designer and an ODBC source with SQL authentication. The report runs fine from the designer but when I try to open it...