Recent content by jhein

Hello, A coleague of mine has asked me how to do this, so I told him I would look into it for him. Does anyone know how to convert an Access report into a Word document? Thanks in advance!

I have a client that wants to be able to access the data fields on a PDF form. They want to be able to add info to a form or select info from a form field...does anyone know how to go about this? I am new to the world of Adobe, so please be kind!

The way we are removing old labels on all our projects is as follows: Go to the file that has the label you want removed. Right click on it and select "Show History". Then go to the version that you want to remove the label from. Click on the "Details". All you do then...

Are you referring to simply removing the label?

Kathryn, I would be very interested in what you have done with regards to putting sp's into SourceSafe. The client I am currently working for has requested this, and we are just about to dig into this one. If you get this message, please feel free to contact me at jhein@slga.gov.sk.ca so we...

I should be a little more clear. The possible path they want to take is to have Office installed on a server, so that when they are out in the field, they can fill out word forms pertaining to their inspections. Once they get back into the office they want to hook up to the network and have a...

Hello, I have a client that is wondering if MS Office 2003 can be installed and run on a server (this product seems to have exactly what they need, only it needs be installed on a server). I know MS has discouraged this practice in the past with previous versions of Office, but I have heard...

Thanks for the tip. I did manage to do something that seems to be working. Instead of just using the following code: adoCloneRS.Filter = "descr = '" & Trim(Me.txtCls.Text) & "'" I have done the following, which is working now: Dim strClsDescr as String strClsDescr =...

I have a function that is trying to filter an ADO recordset. It works just fine until I try to filter the recordset on a value that contains an apostrophe. Is there anyway of getting around this? The code I am using looks like the following: adoCloneRS.Filter = "descr = '" &...

When I have a recordset come back from the database (LockType = adLockBatchOptimistic, CursorType = adOpenStatic and CursorLocation = adUseClient) I know it is probably good practice to do a recordset.MoveFirst on that recordset before performing any actions with it, but I am just curious as to...

I am new to web development and I am trying to set up a project in Interdev. I am having problems with my machine...everyone else seems to be getting along just fine and are not able to produce this error using the exact same steps. When I try to set up Interdev, I am getting the following...

Well, I have fixed the report, but I am still not sure why I had to do this. In order to fix it, I had to drop the stored procs from the report and then add them back to the report. This was the only report that I had to fix like this. I still don't understand why, but at least it's fixed...

One more quick thing to note...I created a dummy report with a few of the fields that are on the problem report and the information is displayed correctly...one more thing to make me scratch my head. I did try to verify the database and I got a message that the database was up to date.

We have a report that was working fine for the longest hitting our test database. Our DBA took a fresh copy of production data and put it onto our test database and now the report is not working correctly. I checked the stored procs, using Query Analyzer and they are working correctly and...

I have a formula set up that basically says: If COUNT(MyRecordsetName.Value) = 0 THEN 0 ELSE (MyRecordsetName.Value) This doesn't seem to be working. When the recordset does not return a recordset, I would like to have 0 displayed on the report, but when a recorset is returned I...