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 Wanet Telecoms Ltd 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. mrmotocross

    Inserting a record into a table

    My problem is i am only getting the first character into the first field. So if a try to insert "12345" only "1" is put into the field. The field is called "Fixture". here is my code: Set InsComm = New ADODB.Command Set InsConn = New ADODB.Connection Text100 = Mid(CompareText, 1...
  2. mrmotocross

    i want to take data from a combobox and write to access

    hello everyone, i have a small problem that i'm sure most of you can help me with. I have a combobox that the user can enter new data in the text area. I know how to add the new entry to the combobox but how do i take the new data and write it to the file that populates the combobox so that next...
  3. mrmotocross

    How Can I figure out why a 'where' clause isn't working?

    Hello again. I am going crazy. I am trying to selectively, using an sql statement, retrieve certain records. I have the correct syntax, i have tried it as a query in access and it works. Does there exist any error that can tell me why i can't selectively retrieve records?. The way i have the...
  4. mrmotocross

    Problem with a selective sql statement

    hello, I am having a problem with an sql statement. Below is the code i'm using: Query6 = "SELECT * FROM EmpDetail where Activity = '" & HoldActivity & "' ORDER by Activity, Date;" Select Case ReportNumber Case 0 SQL = Query1 Case 1 SQL = Query2 Case 2...

Part and Inventory Search

Back
Top