Recent content by mattscott

Thanks Chris, In checking what you said I found out that a) You're right, but b) it can be activated very easily (in VB Editor, Tools>References and tick 'Microsoft DAO 3.6 Object Library'). Still not fully working, but at least this part of it is sorted now. The new problem is it won't...

Hi, [Preface: I'm using Access 2002 and have relatively limited knowledge of the whole thing, have been learning as I've pieced together this project] I've been having major speed issues with a form loading records and have been led to believe that opening a persistent connection to the...

I'm requerying with: Forms![outer_form].[subform1].Requery Forms![outer_form].[subform2].Requery Forms![outer_form].[subform3].Requery Only subforms 1 and 2 go noticably slowly, but then there's only one record being pulled for subform3 as opposed to an average of about 30 for subform1 and 10...

Afraid not, this is for my job so I wouldn't be allowed to, but on top of that it's based on links to a large number of different tables across the company network so recreating in any sense would be very difficult. I know that's not very helpful :(

Just tried this but it brings exactly the same result, thanks anyhow. The 'Go' button that's meant to be pressed once you've entered the account number is set to requery the subform so we can check accounts one after the other. I don't know if requerying is is the best way to do it? Either...

I currently have a subform which is based on a query where a unique account number (input on the outer form) is used to bring up a number of rows of data relating to that account number. Normally this loads very slowly, row by row, sometimes multiple times over and if I scroll at all it makes...

Good spot, afraid that was just me mislabelling things when making the post, it's correct in the actual formula itself. Problem solved anyhow I think! Just needed to use a toggle button instead of a check box. I guess check boxes just don't quite work that way. Thanks guys.

One other potential solution to this would be if it's possible for the dlookup to be performed in TEXTBOX if the box is checked, but if not checked let me manually enter text in that same box. This seemed less possible when I looked into it but I'd be happily proven wrong.

Hi people, Working with very limited Access knowledge from years ago combined with a lot of googling. I have a text box on a form, currently it performs a dlookup for me. I want to change it so that it only performs the Dlookup if a checkbox is checked, but otherwise will display the text...