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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. Kate17

    DSN Problem

    I am logged in on the system with an NT account which has full permission to the database. The System DSN is set to use the sa account, which naturally has full permission to the database. When I change the System DSN to NT authentication, the program works fine. Kate [reading]
  2. Kate17

    DSN Problem

    Hi, I have an application that sits on our server and generates pdf reports from various crystal reports from a SQL server. This worked fine on the machine I created the program on, but when I installed it onto the server (which has the SQL Server on it that the data comes from), when I try to...
  3. Kate17

    Before/After snapshot of database

    I would prefer to try using the triggers, but I don't know how to set this up - I know where to set them up, but I don't know the code to put in there - could you help me please? Thanks Kate [reading]
  4. Kate17

    Before/After snapshot of database

    Hi, We have a web-based program that has a SQL server back end database. I want to be able to see what tables get updated when we add calls via the web-based front end. We are trying to customise this program but we need to see exactly what happens when you do anything in the front end. I am...
  5. Kate17

    using command line parameters

    Thanks for that - didn't do it quite how you said, but I did get there from your pointers. Because the command line parameters will always be the same length, I used Left$ Mid$ and Right$ to split the string up and then use them with my crystal report exporting code. Thanks again! Kate [reading]
  6. Kate17

    using command line parameters

    Just to add a quick note - I would like to pass the parameters through the command line like this: vb.exe reportID startdate enddate Kate [reading]
  7. Kate17

    using command line parameters

    Hi, I have a program that generates a pdf file from a crystal report, among other things. This report has date parameters passed to it via text boxes on a form, which the defaults are 1st and last day of previous month. I would like to carry out this function by passing command line parameters...
  8. Kate17

    Use VB to enable/disable device

    Hi, I want a real simple program that allows me to enable/disable a device in device manager. I installed a friend's PC with XP and their digital camera will only work if the scanner is disabled and vice versa (good old XP!), they have kids so they want a program that will do this for them...
  9. Kate17

    Disable/Enable device with batch file

    Hi, I just installed a friend's PC with XP, everything was fine (well, as fine as it could be with XP!) except having installed the scanner, we went on to install the digital camera which stopped the scanner from working. Anyway, to cut a long story short, if the scanner is disabled through...
  10. Kate17

    Update field in recordset from SQL

    Sunaj, Thanks for that - got it working (almost - just a couple of tweaks to pickup the right recordset!!) Really appreciate your help with this! Kate [reading]
  11. Kate17

    Update field in recordset from SQL

    Hi Sunaj, I have edited your code as follows: objConn.Execute "UPDATE Reports SET ReportNumber=fileName WHERE ReportID=ReportID" Where fileName and ReportID are variables. When I run the code, it says invalid column name "fileName" Do you have any ideas? Kate [reading]
  12. Kate17

    Update field in recordset from SQL

    Hi, I have a program that generates Crystal reports. I want to keep track of the reports and when they were generated so I have a reports table and a reports history table (in SQL). My code adds a new record to the history table for every report, but what I also need is for a field in the...
  13. Kate17

    Crystal Reports will not run from VB6 Urgent!

    Hi, Thanks Joe, I managed to sort it out - I had to change the permission on SQL so that it picked up NT logins - now it works fine! Thanks for your help, Kate [reading]
  14. Kate17

    Crystal Reports will not run from VB6 Urgent!

    Hi, Thanks Joe, I managed to sort it out - I had to change the permission on SQL so that it picked up NT logins - now it works fine! Thanks for you help, Kate [reading]
  15. Kate17

    Crystal Reports will not run from VB6 Urgent!

    David, I don't suppose you found a solution to this? I have just created the simplest of forms with a completely straightforward report (no parameters) - and when I run the report, the viewer just flashes and then disappears. Thanks for any help you can give, Kate [reading]
  16. Kate17

    Select Record from combo box

    Thanks for all your help - I think I will spend some time reading the books I have as I am sure what I am trying to do is really unecessary and there will be a really simple way to do it! I will go and have a lie down and start again tomorrow! Thanks again for all your help and the time you...
  17. Kate17

    Select Record from combo box

    I have deleted my projects so far - I try something new each time, so I am starting from scratch. I will explain why I am doing this and you may be able to suggest a much better way to do it... I am really writing a small add-on - the SQL database was designed for a helpdesk and has a web...
  18. Kate17

    Select Record from combo box

    Hi Sunaj, I used the data form wizard but the 2 main problems with that are - I can't use a view from sql, only tables, and there doesn't seem to be an option where I can choose the UserID and view the other details? This seems to be alot more complicated than I thought!!! Kate [reading]
  19. Kate17

    Select Record from combo box

    Thanks Joe, tried that - but it comes up with error message "Object required", then when I debug, it shows the line rs.source = "Select * etc.... - any ideas? Kate [reading]
  20. Kate17

    Select Record from combo box

    Thanks for all your messages - I am so sorry I am getting confused - I will explain myself a little better. I have 10 records and 3 fields (there's a lot more, but doing it for this will get me well on the way!!) - UserID is different for each, and they each have Surname and Forename. On my...

Part and Inventory Search

Back
Top