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 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: *

  • Users: thermalman
  • Content: Threads
  • Order by date
  1. thermalman

    Changing a CommandButtons Color back to default by clicking another bu

    Hi,I have a program that checks whether a Keyboard key is pressed and reports that it has been pressed in a listbox and also changes a Command button's backcolor when each key is pressed. When I have tested the whole keyboard i have a Clear button that resets the backcolor back to default. The...
  2. thermalman

    Changing the color of two cmd buttons when a certain key is pressed

    Hi, I have a keyboard test program that has a listbox and when you press any keyboard key it's hex value is converted to a VK code and shows in the listbox. I have now added a lot of command buttons to represent the different keys on the keyboard but when i try to link say the 2 shift keys i...
  3. thermalman

    Changing the color of a Command Button based on a key pressed

    Hi, I have an keyboard Test application written using VB 6.0 that has a listbox that currently shows the VK Code of any key that is pressed. I want to include a Keyboard layout built with Command Buttons that depicts a standard Keyboard and I want the Back Color of each Command Button to...
  4. thermalman

    How to execute a Setup.exe from a Button

    Hi, I am fairly new to using Visual Basic.net. I have created a form with 7 buttons on it that indicate 7 Drivers that a Customer can load when they need to. I thought of creating the program as an .exe and putting it on to a CD along with a main folder named drivers and then sub folders for...
  5. thermalman

    LINKING PICTURES FROM EXCEL TO WORD

    Hello, I have a spreadsheet that has a link to a different PDF Map File based on the value of another cell. I also have a Mail Merge Word Document that has links to the Customer data on the Excel spreadsheet and I want to add the PDF Map link to the bottom of the word document and get it...
  6. thermalman

    Getting Error when trying to login to Sourcesafe

    Hi Our Administrator left some months ago and somebody else has been using his machine to get into Sourcesafe to retrieve his projects but all of a sudden he cannot log in anymore. When he tries to log in he gets the following message "Unable to open user login file\\My Server\Development\My...
  7. thermalman

    CRYSTAL REPORTS XI WEBPAGE DIALOG PROBLEM

    Hi, I am using Crystal Reports Server XI I remember setting up the .Net Viewer when loading Crystal Reports Server. When I log into Infoview to view my reports it works fine.If I ask it to print I get the Crystal Reports Webpage Dialog box up and that works okay also. The problem that I have...
  8. thermalman

    Pulling Data from 2 different DSN

    Hi,I am currently using Crystal Reports XI pulling data from a SQL Server 2000 Database. I have 2 reports virtually the same but pulling the data from 2 different SQL Server Databases.one on our site and the other is pulling data from a remote site SQL View. Is is possible to combine the 2...
  9. thermalman

    [b]Help with Record Selection[/b]

    Hi I am using CR XI and an SQL BackEnd. I have a report that shows All Completed Service Calls within a given Date range, which most of the time gives me the results that I want.However just recently i have noticed that if the Last WorkOrders TimeCompleted is outside of the date Range that I...
  10. thermalman

    DISTINCT COUNT

    Hi, I am using CR XI I am trying to create a formula for the report footer that does a Distinct Count of the WorkOrder.CallNumber but I need it to only count the records where the Status "Followup" =False. i.e I only want it to count actual closed Calls. Is a formula the best way to do...
  11. thermalman

    Finding All Calls completed within 30 minutes of SLA

    Hi, I am using Crystel Reports XI with a SQL Server 2000 backend. I want to show All records that are Completed within 30 minutes of the Time Out (SLA) I have tried using a Formula from FAQ but it keeps coming up with a error that the rest of the text is not part of the beginning text...
  12. thermalman

    How to Find if a Call is a Repeat based on a Serial Number

    Hi, I am using Crystal Reports XI with a SQL Server 2000 BackEnd. I have a problem with trying to get a report to show me only the records where the SerialNo is the Same and the DateTime Logged is less than 30 days. We perform between 2000 - 3000 Service Visits on Printers and I want to...
  13. thermalman

    Database Login Problem from Crystal Reports Server XI

    Hi,I am using Crystal Reports Server XI,using a SQL Server 2000 Database and I am running Crystal Reports XI on a Windows XP PC. I can log on to the repository and save my Reports but when a User logs on view Infoview and tries to schedule a report unless you actually add the database Username...
  14. thermalman

    Problem with Calculation

    Hi, I am using Crystal Reports XI and I am pulling data from a remote SQL Server. I have a report that reports on the Calls that my Company performs, I also have some calculations at the report footer that calculate the total No of Calls, The Total Number of Calls Missed Response &...
  15. thermalman

    Formula Not working with a Time after 00.00

    Hi I am running Crystal Reports XI and I am trying to caluclate a Missed Response Figure that shows all calls where we have not responded on a first Work Order within a Given TimeOut. It appears that my formula is working right up to the point where a call is Completed after 00.00, As soon as a...
  16. thermalman

    Printing Report based on current record on a form

    I have a Form that uses a Query to show only the data where a PartNumber is part of a Van Kit,The PartNumber used,Description,Date Used,Bin Location,Which Engineer Used it, Quantity. I need to be able to print a report using a command Button but I only want to print the current record. upon...
  17. thermalman

    PROBLEM LOGGING IN TO CR SERVER XI

    Hi, I am a newbie to Crystal Reports Server XI, I have installed Crystal Reports Server XI on to Windows Server 2003 Database Server that also runs SQL Server. All of the Servers in the CMS are Enabled and Running I can log into the this Server as Administrator and Administor the CMS.I have...
  18. thermalman

    Help with Coding to find Count & pass Result to Report

    Hi, I am trying to write some coding behind a command Button that will Count a number of WorkOrders that meet a criteria from TxtBoxes and Combo Boxes on a Form. I am accessing a SQLView that has all of the Data and when I enter the search Criteria within SQL it works but upon running the code...
  19. thermalman

    Unable to Read Emails formatted in Lotus Notes in MS Outlook XP

    Hi, We have a Customer who uses Lotus Notes 5 and when they send us emails we cannot read them in MS Outlook 2002 and then when we send them emails they only the original Note and the wording winmail.dat at the bottom. Does anybody know of a fix or add-in for this? Regards Thermalman
  20. thermalman

    SELECTING RECORDS BASED ON 2 CONDITIONS

    Hi,I am using Crystal 10 with SQL backend. I want to select all of the records from my Database between a StartDate and an EndDate based on when a calls TimeCompleted field being greater that 17:30.00. The field is a DateTime field but I also want to include ALL of the records that are...

Part and Inventory Search

Back
Top