Recent content by JONBOY74

Nigel I to get a "Compile error" when I try this, any thoughts

Hi All What I have is a table with a list of Function, what I'm trying to do is loop through the table an CALL each Function in turn if it is marked as "Active". My idea was instead of Function names, have Macro names, these macros would contain the Function I want to run. I could...

All I've built a little apps which has the MS calander on it, the problem is that when I run it on either NT or Office 2000 machines the Days don't appear in the calander. I have had some success by coping my mscal.ocx file in to the problem machines but this doesn't work all the time. Can...

All Thanks for all your help on this. I have now solved my problem. The answer is a bit weird. I had to replace an .OCX file called MScal.ocx on the users PC with the same file on my PC. I have seem this before with the dao60.dll Thanks again Jon

Thanks for the pointers, I'll have a dig around. One thing though....why would it work on some PC's & not on others??? Cheers Jon

Hi all I have a apps that is currently used by 14 users. I have just tried to roll it out to a further 4 users but I'm getting a "Runtime error #6#, Overflow" messege on startup. Has many one come across this error before? Would it be something to so with the different build of...

Morning All In Excel you can use the following to return a true or False statement if a number is EVEN or not: =IsEven(3) - this returns False How can I do the same thing in code. I'm trying to use it within a Select Case or If statement. For Example: Select case !VersionNo case isEven...

It's easy when you know where to look, I did try a number of Key word search's but with no luck!!!. @ first glance it's just what I'm after. Many thanks to all who posted help and guideness on this matter. Jon

"those who do not respond are just booted".............. this is where I'm being stupid As I'm using an Access db I can't just turn of the box, so how do I boot these bad bad people out of it???

Thanks again Good points, I will notify the users when if a "Boot " is required, but what do I do about those who either don't respond or are away from their desks (lunch's, meetings etc) Any pointers????? Jon

Thanks for the info, one last thing though, the main problem is that the users may have the apps up and running but are not at there desks (this happens alot). So I supose this request is about 'last resort' and not everyday usage Thanks

Maybe I'm missing some knowledge about Access etc, but I have found that if I need to repair a db and someone is in it, it won't let me. So I thought if there was a way of kicking out the users then....problem solved should I therefore be looking at a different solution?

Hi all I'm trying to build a frontend that connects to an Access db. The apps will receive data from the db as well as pass data to it, therefore I need the connection to be active all the time will the frontend is loaded. My question is : Is there a way dropping the users connection of...

I'm looking to store 2 to 3 list of data consisting of about 10 items within the code. When I click a button relating to the required list that data populates a combo box. If I click another button then the same combo box is populated by data from one of the other lists ( and the old info is...

Hi all Sorry if this is a stupid request.... I would like to store list of data from a recordset in an app I'm trying to build, and use it at a later date. I've been trying with arrays....is this the way forward? Any help would be use full PS I only want to open the rs once (on open)