Search results

  1. S

    Recordser type mismatch

    Hello there - why do I get a type mismatch error with the set recs statment in this code?! Sub manipulateRecords() Dim recs As Recordset Dim record As String Set recs = CurrentDb.OpenRecordset("tableMainData") While Not recs.EOF If recs("productType") =...
  2. S

    Function to check if a table exists?

    Hello There Is there a function to check whether or not a table exists before I try and create one in VBA? Thanks suzie
  3. S

    Copying the values of a field that contains a function

    Hello there I have a field in a query that that contains a function to calculate the cumulative value of another field. How do I copy the actual calculated values to another table as opposed to the function? Thanks Suzie
  4. S

    Make a linked table uneditable

    Hello Again! I have some tables in my db to an external source. How do I make the tables in my db uneditable so that I can only read form the external source? Thanks Suzie
  5. S

    Query a remote access DB and store results

    Hello There I need to query another Access DB and store the results in the DB that initiates the query using VBA. Any ideas what method I need? Thanks
  6. S

    Querying a remote access DB

    Hello There I am new to the world of Access / VBA / ASP. I need to query a remote access db over the net and add the results to another local access db all automatically. Could anyone give me a few pointers about where to start? Would I be able to do this just using VBA or would I need to use...
Back
Top Bottom