Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jhein
  • Order by date
  1. jhein

    Need help Converting Access Report to Word Document

    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!
  2. jhein

    Adobe Form Field Question

    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!
  3. jhein

    How to remove a label version

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

    How to remove a label version

    Are you referring to simply removing the label?
  5. jhein

    Does VSS support SQL Server

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

    Office 2003 and Server-Side Automation

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

    Office 2003 and Server-Side Automation

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

    Problem Filtering ADO Recordset

    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 =...
  9. jhein

    Problem Filtering ADO Recordset

    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 = '" &...
  10. jhein

    Default Cursor Position

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

    Problem Setting up Interdev Project

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

    Report is Not Functioning Correctly...Please Help

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

    Report is Not Functioning Correctly...Please Help

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

    Report is Not Functioning Correctly...Please Help

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

    Value Not Being Displayed on Report...Please Help

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

    Set Datasource Location???

    Is this as simple as going into each report and setting the location of the connection to our prod box or do I have to go through each individual stored proc and change it to the corresponding one on our prod box? For example I have an OLEDB connection called Justice that is pointing to our...
  17. jhein

    Record Count Question

    Thanks everyone. Right after I posted this thread, the answer came to me. I can't believe I didn't think of it sooner!
  18. jhein

    Record Count Question

    I have a report where I need to display a zero if the datasource does not return any records. Is there someway to perform a record count...and if it is equal to zero then I can display a zero on the report?
  19. jhein

    Problem with Displaying Text Vertically

    I just don't understand it. I did try publishing the report as a new report...I deleted the report off of the server and published it as a new one and the problem is still there. So far all Crystal Decisions has suggested is to make sure that all the hot fixes have been applied. They have and...

Part and Inventory Search

Back
Top