Search results for query: *

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

Hello Vb5prgrmr, Many Thanks that worked a treat.

Hello Andrezejek, Can you tell me if it is also possible to use a blanket command to put the ALL command button colors back to default. I have used the command above and it works well but I also have a clear button which clears all of my listbox but I have a lot of command buttons that...

Hello guitarzan Many Thanks for that, I missed the colon as it was not included in jges reply. I knew that it needed a colon in the front but did not realise that it needed another to join two statements. My Keyboard Test program now work a treat. Many Thanks to you, jges and Andrezejek

Hello jges and Andrzejek, Many Thanks for the posts, firstly yes my cmd buttons are set to graphical and for most of the buttons i have no problem. I only encounter a problem when I want to reference 2 cmd buttons at the same time. i.e. L Shift, R Shift, L Control and R Control. I have tried...

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

Hello AndyGroom, Many Thanks for the post, I have set the command button state to 1-Graphical and then tried to use the following command but I don't know if I am doing this correctly set cmdEsc.Backcolor =vbgreen but I get a comile error but I am trying to put it after the relevant...

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

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

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

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

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

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

Hi LBass, I thought that I was supposed to remove the Record Selection and put in a Group Selection. I think i miss read what you told me to do and removed the record selection and only had the Group selection. I have now added the record selection without the Date Range in it and it appears...

Hi LBass, Sorry for the that but I was using the first details as a clarification of the criteria that I wanted the report to show me. On my original report that I have on my desk it shows ALL of the workorders for Call Reference PF30772 because they are ALL Completed within the date Range...

Hi Lbass, I presume that you want to see Sample date of What I actually want the report to show. If I enter a Date Range of 01/12/06 00:00:01 and 31/12/06 23.59.59 I would expect to only see All the Workorders where the Last WorkOrder Number was Completed within this range. LoggedCalls.GBR_No...

Hi Lbass, It now shows me all of the records that I said but on the Next call on the report it only shows the the 2nd Workorder which was Completed on 01/12/06. The 1st WorkOrder was Completed on 30/11/06 16:00. How can I get the report to only show All the WorkOrders when the Last...

Hi LBass, I have tried what you suggested but I now get only the last WorkOrder and nothing before it. here is how I entered the coding you gave maximum({WorkOrders.TimeCompleted},{LoggedCalls.GBR_No}) in {?StartDateTime}to {?EndDateTime}and {LoggedCalls.CallComplete}=true and...

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

Hi AngelB, It is easy when you know how. Many Thanks Thermalman