Thanks for the answer, but the problem is when user swipe the card, it's read in keypress event of the textbox, therefore, you can actually see the moving text. My problem is while it's reading, user can type on the keyboard, creating extra text, and that would cause error in parsing credit card info. I'm looking for a way to temporary disable (lock) keyboard until the reading credit card is done. If anyone has any other solution, I appriciate it. Thanks.

Hello Everyone, I have a vb.net application deployed the query the db using a card swipe(mag stripe/card reader) using a textbox. My problem is they want to restrict typing in the card number they want the to force the user to swipe the card for security purposes. Can I disable the keyboard (and mouse, if possible) when my app is running or can I disabled the keyboard keys. How can I resolved this issue. Also, I cound not set the properties readOnly to true because when I swipe the card it reacts on the keydown event. Is there any other way to restrict the user from typing the values to the textbox? Any suggestions will be greatly appeciated. Thanks

I got Application Error Msg when I close the software: "The exception unknown software (0xc0020001) occured in the application at location 0x7c81eb33." Anyone has encountered this before? Please help me. Thanks.

Could anyone please help me with this....Is there a way to change hashtable key base on its index? Thanks a bunch John

Hi All, Is there a way to add (or map) directly from dataset to combobox? I tried to use **ComboBox.DataSource = ADataSet**, but it doesn't seem to work. The reason that i'm using dataset to map direct to combobox because the data in the database is huge. It's about 20,000 records; and I don't want to use for loop or while loop to loop through and add one by one. If anyone know a way to do it, please help me. Thank you for helping. John

it really does help. and I just found another way of doing that: select isnull(first_name,'')+isnull(last_name,'')+isnull(middle_name,'') from contacts

In my table, I have three columns: first_name, last_name, middle_name . I tried to merge them into one column, and this is what I did: select first_name + ' ' + last_name + ' ' + middle_name as Full_Name from contacts However, when I do a query on that one, only the ones that have data in all three columns show and if one of the column is missing data wouldn't show. for example, orginal table -------------------------------------- |first_name | last_name | Middle_name| -------------------------------------- test | test | null | -------------------------------------- when merges: ------------------------- | Full_Name | ------------------------- | null | ------------------------- if column middle_name is empty, then Full_name would return null, eventhough first_name and last_name have data, why is that happening? Could someone help me how to make that work? Thanks a bunch. John

Here is my problem: I have a store procedure name stEmployees, with Code is the attribute. In the formula editor of crystal report, I tried to declare a variable string such as: stringVar string := {stEmployees;1.Code}; ReplicateString (string,10 - Length (string) ) & string However, when I run a check syntax on this, it returns error "A string is required" on the first line of the code. Could anyone help me with this problem. Thanks a bunch. John

Thank you. It really helps.

Could somebody help me to format a field in crystal report. I have a field named "Code" with value is 9393. However, I want to add 0000 in front of it, then it would become: 00009393. I know that in crystal report that have a string function called length and ReplicateString, so that we can use to add 0000 in front of a number. I know the way to do it, but I don't know how to write it in "Format Formula Editor". Could anyone help me on this? thanks. John

Is there anyway we can design crystal report at VB.NET runtime? I've been doing research about it but couldn't find anyone doing it. If you know a website where I can buy it, please help. Thanks John

Could someone please help me on how to disable database login in crystal report 9.0? Here's how I did: I created a customer.rpt file then I wrote this code to call customer.rpt to make the report: ------------------------------------------------------------------------- Private Sub CustomersPrintForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim CRYRpt As New Customers Dim rst As MICControlLibrary.RecordSet = MICControlLibrary.DBContacts.DBSelectPrint(_contact_id) Dim dtview As DataView = New DataView(rst.DataTable) CRYRpt.SetDataSource(dtview) Dim ParameterFields As CrystalDecisions.Shared.ParameterFields Dim ParameterField As CrystalDecisions.Shared.ParameterField Dim ParameterRangeValue As CrystalDecisions.Shared.ParameterDiscreteValue 'ParameterRangeValue ParameterFields = New CrystalDecisions.Shared.ParameterFields ParameterField = New CrystalDecisions.Shared.ParameterField ParameterField.ParameterFieldName = "@contact_id" ParameterRangeValue = New CrystalDecisions.Shared.ParameterDiscreteValue 'ParameterRangeValue() ParameterRangeValue.Value = _contact_id ParameterField.CurrentValues.Add(ParameterRangeValue) ParameterFields.Add(ParameterField) CrystalReportViewer1.ParameterFieldInfo = ParameterFields CrystalReportViewer1.ReportSource = CRYRpt CrystalReportViewer1.Refresh() End Sub ---------------------------------------------- am I missing something? because when I run it, it prompt a database login asking me to login before view the report? Thanks for helping.

thank you..it works.

Hi, i'm doing a project and I need to add 0 to the front of a number. Is there a way to format a number? for example: 898 become 000898 If anyone could help me, I would appriciate. Thank you.

I'm working on a note control. I have some pop up windows by doing .showdialog. Is there anyway I can do if I close the parent form, all the popup(child forms) will close as well? Thank

I really need help on DoubleClick Event of ListView. I know that double click event is only for selected listview item in listview. ie.: Private Sub lstvNote_DoubleClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstvNoteBACKGROUND.DoubleClick if lstvNote.SelectedItem.Count > 0 then 'do something end if End Sub ------------------------------------------------- However, is it possible that I could have a double click event on outside of listview items ??

I know that in listview or other control, we can do right click event using MouseUp. However, menuItem of Mainmenu doesn't have that. Could somebody please show me how to implement right click event on MenuItem of Mainmenu in vb.net? Thanks a bunch for helping.

How do I resize the first column of datagrid control to be zero, so that it can work as ListViewItem.tag in listview control? Is there a way to hide the first column and set the with to 0? Please help . Thanks.

I found some software that can get the computer id. I'm doing a project that needs to get the computer id for security. Could somebody help me and show me how to get computer id in vb.net? Thanks a bunch. John

Basically, the string is an if statement. For example: if Cost = 20 * Quantity / Discount and Cost = 49 then.... This is an input from user. And i'm trying to parse the string and check the "if" part only. John