Recent content by rkinrade

Oh, I feel so dumb... There is nothing wrong with the code. The Access Report was made up of labels and textboxes. All I had to do was place an imagebox for the jpeg to fill. I keep looking for the complicated whilst tripping over the simple. Yeesh!

I have a VB application that prints a report from an Access Database. The only trouble I'm having is printing the CustSign field which is an OLE Object (a jpeg image of the Customer's signature). The report prints out beautifully, just without the signature. Here's the code. Thanks in advance...

I'm trying to print a report from an access database using an interface created in VB. Here's the code: Private Sub cmdPrintTest_Click() 'testing the printer Dim SelDir As String Dim AA As Access.Application Set AA = New Access.Application AA.OpenCurrentDatabase DBLocation...

Thank you.

Hi, I would like to develop an interface that will allow upto five users, but no more than five to have access the the SQL 7 database. How can I do this. Thanks in advance.

Hi, I'd like to develop an interface that is licensed to only five users. I'd like help with ensuring that only these five users have access to the SQL7 database. Thanks in advance.

I'm assuming you only want to process numbers? Dim ctrl as Control For Each ctrl in Controls If TypeOf ctrl is TextBox then If IsNumeric(ctrl.text) Then 'process the information in the Textbox End If ' if it's not a number it's ignored End If Next ctrl

Dim NumString, MyString as String NumString = "123456789" MyString = Left(NumString,5) The variable MyString will equal "12345"

Thanks James

Thanks, actually the code is being run from VB and looks something like this: insert into stores(name) values ('" & txtCustInfo(1).Text & "'). The value of txtCustInfo(1).Text being "John's Store". I guess what I need is VB code to replace the apostrophe before sql gets it.

When wanting to insert info from a textbox such as "John's Store", how would I include the apostrophe in John's without the SQL statement crashing?

How's your budget? If you own Photoshop 7 you can download a filter called iconbuilderXP from the iconfactory. http://www.iconfactory.com/ib_home.asp enjoy the journey

To find what methods are available for Visio, click on the Object Browser Icon in the Visual Basic Editor and find Visio in the library drop down. If it's not there then you need to create a reference to it. All Libraries is the default. In the list box below you can find all the methods for...

The file name to reference Visual Basic for Applications is MSVBVM60.DLL.

rem out rs!ID = IngID and see if it runs correctly