Search results

All - looking for some insight here, any help would be appreciated. I have two pivot table sub-sub-forms that stopped displaying data in the pivot table, but the other pivot table areas (filter, row, column) remain populated correctly. Where the data should be displayed I get the following...

Yes - i agree on the emulation bit, this however, is just one piece of the project, which while done more cleanly in excel is not acceptable from the customer's PoV, they are looking for an all in one system and access is the commonly available tool. Aside: ================ There are other...

Hi all, I'm looking for a pointer on what to read/search for as I'm not sure what it would be called in an access form or if it even exists. I'm looking for a form functionality that would be similar to the freeze frame concept of excel. This could be static where once laid out in design...

As an update, I've figured out a means around this by forcing the user to click another button on UpdatingFormB. This allows the click event on form A to complete, allowing for a clean close and unlock. Still thought there ought to be a means to allow one click changing of forms to update...

So DoEvents is doing exactly what it is supposed to then, and waiting for the form to close. The catch, I think, however is that it seems as if the ButtonClick event doesnt need to be completely finished in order for the form to close (i.e. the form close event can finish before all code is...

I think I need a bit more explanation on DoEvents, it sounds like its for VB only and not VBA (access). Here's the snippet of code I'm refering to and how I've attempted to use DoEvents. DoEvents returns a value of 0 when i use it in the immeadiate debug window, when I've been testing what it...

Hello all - I have what I hope is a simple question. I'm looking for advice on switching between forms, specifically in access 2007 (though I suspect that the answer may be similar in 2003). Overview: I have summaryFormA and UpdatingFormB. On summaryFormA there is an Updatingbutton that...

All - I've been searching for a couple days now, but have not had any luck finding an answer (hope I've been searching the correct forum). Here's my question/issue. Background I have several queries that generate 2 tables (i.e. tblA and tblB) of normalized data. In a form the user needs to...