Search results

  1. A

    Import data from DAO recordset to local table

    how would i go about appending it to my local table. Sorry but very rusty when it comes to VB, so really need things spelled out im afraid when its not the real basics. Have not touched Access propperly in about 4-5 years. :o Thanks. Andy.
  2. A

    Writing a function and using it in a query.

    Public Function Total(ByVal amount As Integer) As String If (amount < 500) Then Total = "small order" ElseIf (amount < 1000) Then Total = "Normal order" Else Total = "Big Order" End If Return End Function hope the above helps. think you can just...
  3. A

    Help with combining fields

    you have not set your table Joins correctly in the query i think. best way to do this in access is find the linking fields that match in the tables and drag one onto the other in the query builder. Andy.
  4. A

    Help with combining fields

    SELECT [FIRSTNAME_FIELD] & " " & [SIRNAME_FIELD] AS FULLNAME FROM TABLE_NAME_HERE; You can use the & to concatinate fields, alter the above and save it as a query. Hope this helps and i answered your question. (too slow answering ans someone beat me to it :) )
  5. A

    Import data from DAO recordset to local table

    Hello all, first of all i will have to state that i am not really a VBA person :confused: i am a little confused by this simple matter. I have a MySQL server and am able to talk to it now via DAO. What i wanted to do is to be able to import a recordset from the MySQL server and store it in a...
Back
Top Bottom