Recent content by barlowr70

I'm in the process of upgrading a front end from Access 97 to Access 2002. I've got a form bound to a table. On the form I've got some text boxes bound to the fields in the table. The problem is that the data is not displaying in the text boxes. As a test I've created a new form and used the...

You can output multiple queries to a spreadsheet without a problem. Try it manually and then decide how best to code it (Maybe a For Loop and pass a new query name at each iteration). If you want a prompt for the file type and/or destination you can either use DoCmd.OutputTo acOutputReport...

I am looking for the connection string but using the ADO rather than DAO Regards

I am looking for the connection string but using the ADO rather than DAO Regards

Try this... Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentProject For Each obj In dbs.dbs.AllForms 'dbs.AllForms Debug.Print obj.Name 'DoCmd.DeleteObject acForm, obj.Name Next obj

I have an application with an Access 97 front end and an SQL server back end. In acces 97 I use the code below to determine a tables name and connection string. Dim tbl As TableDef For Each tbl In CurrentDb.TableDefs Debug.Print "TABLE... " & UCase(tbl.Name) & " ... " & tbl.Connect Next tbl...