Search results for query: *

Below is my code. I am trying to select only the records meeting the two criteria and then clone the data to a datagrid. I need helo joining the two select statements. I have try "and"...but it does not work.. it says data mismatch. there are two text box for user input for the select"...

Dear experts: I have a program that I code and it worked fine. I need to make some changes to it. a year ago was when I last make changes. My computer crashed I re-install VB and now when I open the project back up and test run VB is having comile error "can't find project or library" on...

I am writing a time clock program. I don't want the user to be able to change the system date and time. Is there a way to restrict this? Also Can I compare the date and time to the last punch in. For expamle if time or date is less than last person punch in then system gives error. if so ...

I have problems with the following search criteria: it is giving me a type mismatch error when I run the program. Searchcriteria = "DATE=" & todaydate.Text And "socialsecno = " & txtpassword.Text I want only the record matching the above criteria to show. there is only one record per...

how do i code when user press enter key to act as return key when entering text into textbox? kay lo

how do i code when user press enter key to act as return key when entering text into textbox? kay lo

Can someone point me to the right place for information? I have a client that wants to export data to the Lynks API system. The problem is I don't really undeerstand want API does. How Can I be sure that what I am developing is compatible with the Lynk system. From some of my research API...

I need to have the record set to move to the records that match text1.text. the problem is proproductdescription is a description field. with mean that text1 has to match exactly to proproductdescription. I want the record to navigate to the first record that match the first letter that I...

I need help in joining two SQL select statement. it works if I don't add the and Etc.... But I need the sql to do both. Please edit the following for me. I need records only if the name and phone number is the same as my text field. Thanks, Kay stcnQL2 = "SELECT * FROM...

How do you go around trying to cancel an update when it is a dulpicating error? Below is detail of my problem: I have a table in my database that the primary key cannot be duplicate. When a user try to add arecord with the same product number it gives a long system error, the problem is in...

Hi, I need help to see if there is way around this problem or have anyone come across this before. I developed a program on my computer, running windows XP. I created a package usind the deployemnt wizard. When I try to install in on the user's computer without VB it gives me and error...

hI, pLEASE HELP!. I am working in data environment creating a report through datareport. I have the following code behind a print button. it is giving me an error message of invalid use of property stopping at: .rsGrandTotal1 strParam1 How do you get the report to show only records with...

Please help! how do I envoke the data grid to proform a set of cmmand after deleting or adding a row. I am adding up the rows in the grid. if I delete a row my total does not change. What event do I need to have my adding codes behind? Thanks Kay

Please help! I have a data grind bound to a ado database. When I add records to the grid display the right records. the problem is when I try to delete. if i add only 1 record and delete the same updated record the delete works fine. if I add more than two record and try to delete anyone...

Need Help! Is there a way to add a caculator to a form so the user can just click the calculator rather than using the key pad? Thanks Kay

Please help! Thank you in advance form1 ado to product table form2 ado to inventory table I have two forms. When I am on form1 I pull up a record. the record has a unique product number. When I click a command button to go to form 2 I want form 2 to pull up records matching the product...

Hi, Please help with the following: I am trying to use the db combo control to populate the combo list but when I try to set the row source it is giving me the following error: No compatible data source was found for this control. Pleas add an intrinsic control or a remote data control to...

I search most of the threads but found no solution. Pelase help if you can I have a data grid that only display certain records that match my criteria. I need to add up one of the columns. I did a loop and it sums up the entire tables. I just need to add the displayed records. Thanks in...

Dear experts out there, Please help!! I have 2 datagrids and a textbox. I want the datagrids to show only records matching the product number that I type into the textbox. I use a code from another thread below but it did not work. I put the code behind the productno change event: The...

I would like to have an auto number on the form so every time the form is load this number increases. I already have an auto number for each record I added. The number on the form needs to increment only when the form loads, diffrent than the auto number for record. Please show how you would...