Search results

No luck Thanks for the tip Ricky... Still get the same error though... It gives me runtime error 13 which is a type mismatch... it's definately a problem with the following line of code: Set recs = CurrentDb.OpenRecordset("tableMainData") The table tableMainData definately exists so I have no...

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") =...

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

Col Hooray! The createtable query worked! Thanks for the help Suzie

Hi Col I need to use the calculated cumulative values to create a chart... The chart wizard does not like the fact that the field contains a function... If I can create a new table and put the actual values in then my problems are over! I'll try the update and append queries now. thanks suzie

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

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

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

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...