Search results for query: *

I would try Steveblum's 'A tip on debugging SQL problems'; I program against Access databases and often find I need to get Access to help me out when debugging my SQL strings.

Is CatName alphanumeric? If it is then you should provide quotes around your SStr as follows:<br>&quot;Select * from&nbsp;&nbsp;jobs where catname&nbsp;&nbsp;= '&quot; & SStr & &quot;'&quot;<br>Note that the variable SStr needs to be appended to the string rather than contained within it...

Presumably your initial problem is solved?

Try this:<br>Public Function NumPages(Records As Long) As Long<br>&nbsp;&nbsp;&nbsp;&nbsp;NumPages = Round(Records / 10)<br>&nbsp;&nbsp;&nbsp;&nbsp;If (Records Mod 10) &gt; 0 Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NumPages = NumPages + 1<br>&nbsp;&nbsp;&nbsp;&nbsp;End If<br>End...

I've used the Outlook Object Library in VB and it's pretty easy to invoke, but whether it's up to rapidly sending large quantities of e-mails, I couldn't guess. My app is a background job waiting for files to appear to be e-mailed.

It really depends on where you are coming from and where you expect to be going. <br>If your requirements are database-centric then Access gives you lots easy to use features with VBA supplying any additional bells and whistles. <br>However, if you are looking for a powerful programming language...

I'm afraid that I had problems using Webclasses in the way that you are doing. I ended up incorporating all the html into my code rather than keeping it in external .htm files.<br>However, one thing that you might note is the comment in the VB Help (& also in the VB6 readme files):<br><font...

Sorry, I can't help you. If I correctly name my Excel 2000 spreadsheet file, the code works; if I spell it incorrectly, it doesn't (with Error 1004 as you got). I'm also using the Excel Object Library 9.0<br><br>I also should have said that you need to close the appexcel object and remove...

Sorry - my typo....<br><br>It should read :<br>aryExcel(i, j - 52) = appExcel.Range(Chr(i + 64) & j).Value<br><br>The Chr converts the digit i to its equivalent letter (1 becomes a, 2 becomes b, etc) so the Range is acting on a Cell reference (a1, b2, etc). When i is 1 and j is 53 you have...

Create a reference to the Excel Object Library (use Project:References on the VB menu bar) and then in your code:&nbsp;&nbsp;&nbsp;&nbsp;<br><FONT FACE=monospace><br>Dim i As Integer, j As Integer<br>Dim aryExcel()<br>Dim appExcel As Excel.Application<br>Set appExcel = New...