Recent content by lios1984

Amazing how easy it was!!!! I was about to get into VBA code thinking I couldn't do it any other way. Thank you very much stopher!!!

Hello everyone. I desperately need your help. Suppose I have a mother table with 600 records and 4-5 child tables that have a subsum of the 600 records of the mother table. For example, I have 600 books as mother table and another child table Bought that contains 80 of the 600 books. What I...

I checked it out at home where I have Access 2007. It is exactly as you said it Mr. B. Access 2002 doesn't offer the same options.

Access 2002. (I know...I'm too far behind but this isn't my PC. It's the one where I am emplyed.)

I tried that but my only choices in Display when Property are YES and NO. Nothing about Screen Only.

Hi to everyone. I have a report and I have added in it an image that I am going to use as a control (an exit button to be more accurate). I'll use it that way so that the report is more user friendly during the navigation. My problem is that, although I want it to be visible in the report, I...

Thank you very much for your help. It worked!!!

Option Compare Database Option Explicit Public Sub random_assignment() Dim dbase As DAO.Database Dim rsTemp_status As DAO.Recordset Dim rsEvaluators As DAO.Recordset Dim rsProject As DAO.Recordset Dim rs As DAO.Recordset Dim sSQL As String Dim rando As Variant...

Hi to everyone!! Ia have trouble with my code. It gives me "runtime error 3251: This operation is not supported by this type of object" about my Requery. I requery a DAO.recordset. What could it be??