Recent content by JDubya

Many thanks for a really informative piece The_Doc_Man - it really helps to get a bit of background to help make sense of the topic. Cheers, John.

Thanks for the example Markk, yep so when I run the code I now have two workspaces, I just don't understand why it takes action in an object lower in the DAO hierarchy to create an object higher up in the food chain and if this is how to create a new workspace, then for what real world reason ?

Yes, true Tieval, but as is always the case, each answer raises another question. My understanding originally was that the Database engine resides in the MS Access Application itself and so that as a single user, if I had 3 separate databases open on my pc, that would equate to 1 database...

Hi Mark, thank you for your example showing how you can have more than 1 database open in a particular workspace. However, I wasn't saying that if 10 users are logged onto a database that will show as 10 databases in 1 workspace.... I was theorising that it would be seen as 10 separate...

Ok thanks Kevlray & Dave So, if I'm understanding this right.....if there is an Access Database that is being used by 10 users, then each one of those users will occupy one workspace each, so that if I type ?dbengine.workspaces.count, I should get a return value of 10. Each user will typically...

Thanks Dave, so from that I'm guessing that all 3 separate databases open on my pc would therefore be in their own workspace, but if I modify the expression to look at Workspace(1) or Workspace(2), I get an error?

Hi Everybody, I've just progressed onto the DAO chapter of my VBA text and am already confused by what is supposed to be one of the simplest aspects of the Database object, that being counting the number of databases open in a workspace. The text says " Normally, we will have only one database...

Thanks hth(stopher), Static and Dave (not Gemma) for your replies, it all makes sense to me now. I guess the confusion comes about from the Auto Quick Info prompts... I'd already learned (the hard way) that the square brackets meant the argument was optional, but I thought that if normal...

I have encountered an apparent inconsistency in the way VBA handles calls to functions from within a subroutine, as well as calls to a function from the Immediate window. In both cases how VBA responded seemed to be dependent on whether there was one or whether there was more than one argument...

Hi FrothingSlosh, Make123 and Grumm as per my reply to CJ turns out the error was in the original example supplied in the manual, but because of my own error in calling the wrong procedure I didn't pick up on the manual's code error until just now. Sorry for wasting your time guys and thanks...

Hi CJ, I take your point on the real world uses of the IsMissing function and that the example given in the book is probably not the best. And it's good to know that my very basic understanding of how a variable is supposed to behave during the execution of a procedure is sound. (I purposely...

BTW CJ, in the book example CocoaToBeAdded was originally Boolean, but then I was instructed to change it to Variant as this is the only variable type that works with the IsMissing function. So the only values that will passed in, if at all, will be True or False.

Hi CJ, I understand what you're saying and get that I can set the default value of an optional argument when declaring it, negating the need to use the IsMissing function in this example. However, this isn't a question of whether I need to use IsMissing but of what happens when i do, especially...

Hi Grumm, sure although in the original code there are two optional arguments, but here here goes:- Function MakeIceCream1(Optional CocoaToBeAdded As Variant, Optional VanillaToBeAdded As Variant) As String If IsMissing(CocoaToBeAdded) Then CocoaToBeAdded = True Else: ccoatobeadded = False...

Hi Folks, I'm working through an old manual that provides an introduction to VBA programming in Access and I'm stumped at their use of the IsMissing funtion. The code they provide is thus:- Function MakeIceCream (Optional CocoaToBeAdded As Variant) As String If IsMissing(CocoaToBeAdded) Then...