Search results

  1. A

    Can multiple sub-forms be the cause of Error 3048?

    Judging by that post, having lazy loading of forms/subforms might help too. I think I have solved my problem using lazy loading of the sub-forms. I have left the sub-form controls unbound and assigned the Sub-Form's Source Object only when the tab containing the sub-form is opened. I have...
  2. A

    Can multiple sub-forms be the cause of Error 3048?

    Indeed, I have closed them and removed them from memory using the code you have put above. I dearly wish this was the answer to my problem but it doesn't seem to be....:(
  3. A

    Can multiple sub-forms be the cause of Error 3048?

    Hello all, I am using an Access 2007 front end linked to an Access 2007 back end. I have a Report that the user operates by selecting the information he/she wants to see on a pop-up form and clicking a button. The Report works perfectly unless another form, called Shows Form, in the database...
  4. A

    Sort order for ranking query

    Hi all, I have a query in which I am ranking artists who are assigned to shows. Here is the query: SELECT qryPS1TeamsFilter.ShowID, qryPS1TeamsFilter.ShowName, tblArtists.FirstName, tblArtists.LastName, (select count(*)+1 from [qryShowsArtists] as b WHERE [qryPS1TeamsFilter].ShowID =...
Back
Top Bottom