Recent content by AndyP

I had the same problem with XP and it was to do with the references. The ones i have are: Visual Basic For Applications Microsoft Access 10.0 Object Library Microsoft DAO 3.6 Object Library The declaration statements are dim db as Database dim rs as Recordset Set db =...

Access has a control to email reports. You could create a report based on your query and select the command button from the object toolbox. Under "Report Operations" there is the option "Mail Report". I use this in an application, it gives you the option to email the report as an Excel...

Could be because of the rst.MoveNext command you have after the loop starts. In effect you start at the first record with your initial statement With rst .MoveFirst .Edit End With but you then tell it immediately to go to the next record by using the rst.MoveNext statement before testing...

Seems to have done the trick. I ditched a couple of references and it appears to be working! Cheers mate.:D

Gidday, I'm trying to create a database variable and a recordset as per the following code. Dim db As Database Dim rs As Recordset Set db = DBEngine.Workspaces(0).Databases(0) Set rs = db.OpenRecordset("Sale", dbopentable) When i run the code it stops at the "set rs = ..." line and returns...

Thanks Sean. I'll give it a whirl and see how it goes. Cheers, AndyP

Gidday, I am developing a database in XP and transferring it to 2000. I have a problem with some of the reports defaulting to portrait page setting even after i have changed them on the 2000 system. Does anyone know how i can set the page setup settings in VBA code. I want to specify...