Search results

  1. I

    Enter Parameter Value?

    Need some help, in the following code i want a input box to pop up and request the user enter a valuee that will replace a previous one (amending). Currently after a press "ok" on the inputbox it askes me for the parameter value of the value i typed into the inputbox (not the variable). i dotn...
  2. I

    HElp Debugging

    What is wrong with this code Private Sub Command161_Click() On Error GoTo Err_Command161_Click Dim num As Integer Dim Test As String Dim MainVal As String Dim varInfoID As String Dim varAppealID As String Dim varAppeal As String Dim strSQL As String varAppeal = Me.Combo4.Value varAppealID =...
  3. I

    Deleting and Item from a listbox.

    I am seriously stuck on how to delete an item form a list box, Basically i want on the click of a button for selected item to be deleted from the list box. My first thought just simply do .removeitem then .itemselected but obviously that didnt, what was i thinking, Can anyone help me out here?
  4. I

    Counting rows

    How do you count the amount of rows in a specific table using VBA ofcourse.
  5. I

    Using SQL

    Hi Im trying to create some dynamics into my database, ive been trying to get to grips with most of the VBA functions. Can you guys explain how i could execute swql queries using vba or link me to any tutorials.
  6. I

    Using VBA how to manipulate tables.

    Jus ta quick one. Can you tell me the functions to add records to table and such. Im not 100% how to use the recordset functions at the moment.
  7. I

    Search Populating a list box.

    Im totally confused on how to do this, therefore i am here to seek help and advice. Bascially i want to search a table, get the results from the search to populate a list box. And also to select aresult from a list box and then get results to populate another list box. My VB skills are...
Back
Top Bottom