Recent content by Gaffer

Thanks for that. It's a lot of looking so I'll give it a try and see if I get any joy. At the moment, I've fudged it by leaving the subform continually bound, but it happily removes and resets the other objects. It's not the 100% solution I was looking for but at least it's sort of working...

I'm trying to change a database that consists of a sequence of subforms held individually within different tabs on a subform. There seems to be a bit too much going on, so I've decided to leave the subforms unbound, and set them when the appropriate tab is selected, and unset them when the tab...

I have an app that was originally developed on Access 97, and I've ported it over to Access XP with minimal problems, which I sorted out. Being nice, I thought I'd check if there were any problems using it on Access 2003. There were! The forms have quite a few text boxes which lookup and...

Sorted it! I isolated it to three text boxes containing formulae that Access XP didn't like. They all referenced text boxes that had the same name as the fields that the were bound to. Explicitly referring to the controls sorted this problem out and they work fine now. Just as an example if...

Hi I'm working on a database, which has been developed on Access 97 and is comprised of one form containing a multitab, and many subforms within that. There are also about 12 text boxes over the form which contain lookups and calculations of one sort of another. Now, all of this seems to work...

Hi - this isn't such a serious problem as it only happens every so often and I can sort it out easily. I'm more interested in know if anyone has seen this sort of behaviour before, and what causes it. I'm making some changes to a database written in Access 97. It is comprised of one main...

NNZ is a function I came across whilst looking for postings on similar problems to mine. It is: Function nnz(TestValue As Variant) As Variant 'Not Numeric return zero If Not (IsNumeric(TestValue)) Then nnz = 0 Else nnz = TestValue End If End Function However it didn't sort out the...

Hi I have an annoying problem with a subform on Access XP. The subform is bound to a table and the field totals are totalled in the form footer. This works fine when the form view is set to Single form. However I need to view the data in rows. But if I set the form view to Continuous Forms...

I have to keep it as automated as possible, and have to generate several different reports for emailing to different locations. Cut and paste just won't cut it (no pun intended!)

I have tried exporting a report to Excel for the purposes of emailing it, but it loses all of it's formatting and generally ends up looking pretty horrible. Can anybody suggest a better way of getting my data out of Access, and looking pretty..?

I am trying to convert a report based on Excel to Access. This is a list of records which spreads across 3 pages. However, the fields I need to show spread across a greater width than the 22 inch limit. Is there any way around this, or can anybody suggest a way that I might present the...