Search results

Hi Aziz In 2007 and 2010 the toolbars have been replaced by ribbons (apart from the quick access toolbar) take a look at: http://www.databasedev.co.uk/access2007ribbon.html or http://www.accessribbon.de/en/ or see the attched image if that's what you mean SmallTime (indeed a book of truth)

Using 2010 (accdb format) on windows 7 I'm trying to convert a memo field's format from Plain Text to Rich text. The problem is that every time I try to select the Rich Text format option the field immediately changes back to Plain Text. Just as a test a created a new memo field in the same...

Did you find a solution to this? I'm having the exact same problem.

and I suppose they all have access to guns. I suspect many of your beasts would become puppies without the shooter.

I'm afraid that's the world we live in, and to a degree each one of us takes a small part in creating it that way. Large organisations are in their very nature greedy, shareholders who's only interest is increasing their bottom line pressurise senior managers to increase profits which...

Hi Galaxiom, How you keeping? I think the overwhelming answer is 'don't be silly stay with what you got'. Heeded. Many thanks to all SmallTime

Well, In Pakistan there's very weak gun laws, in fact there's very weak laws full stop. In remote areas even children carry firearms twice their own body size, and I can tell you that everyone knows someone or of someone who's been shot. So yes, absolutely and without question strict gun...

It's fantastic watching a robot blast rocks with a laser. But what happened to Obama's promise that they were going back to the moon? Did NASA put him off, can't have been the cost if they're shooting glorified vacuum cleaners at Mars, so why the backtrack?

Sorry forgot to acknowledge vbaInet's very good point about speed. I was wondering how much I'd be sacrificing by creating new queries at runtime and I don't have the answer. Could it really take much longer or is the extra overhead measured in milliseconds?

You're all absolutely correct in that the end product is no better than before, except perhaps that since accdb's\accde's are no longer secure, (not that mdb's\mde's were very secure before) but an mde was a degree or two harder for the casual user to mess with than and accde. Anyone can import...

The testing, which at the time I thought was reasonable was a number of variations on Dim mydate As Date mydate = DLookup("[Received]", "[All Referrals]", "[ReferralID] = 98") MsgBox Format(mydate, "dd mmm yyyy") (ReferralID 98 is shown in 'All Referrals' as 08/07/2012) Just reading through...

Sorry for the lack of info, thought I'd make it clear but reading back maybe not. Rather than have 180 or so static queries (queries that have been previously created) For example, let's say this is one of many a queries in my Db and permanently exists as QryUserLogOns SELECT...

Hmmm, I say Hmmm as I scratch my head. Now why did VBA return the correct date following Isskint's suggestion when I tested for dd/mm against mm/dd. However, your suggestion does the trick. formatting in mm/dd/yyyy returned the correct count of 19, yet formatting in dd/mm/yyyy doesn't. Just...

Just looking for some reassurance here. I’ve been brushing out cobwebs in an old database which was getting quite full with queries, so I’m rebuilding building many of them on the fly as and when needed with QueryDefs, I recon I could replace many of the 180 or so queries with about 5 temp...

Good thought, Just tested 08/07/2012 and got 08 July 2012 which is what it should be (no american day\month mix-up). Worth a shot but still a little baffled. Cheers

Hi, I can't seem to understand what's amiss here and would be grateful if someone could cast an eye over this and perhaps see what I can't. I'm getting two different results when using a select query with totals and DCount in vba when I thought I should get the same result. The query returns...

Hi Gina, Been a while now, do you know if Ms ever managed to produce a fix for this Regards SmallTime Hope the soles of your shoes are still fine. :)

Thanks Yes the FE (2010 accdb) doesn't support the feature. However, because it's connected to the 2000 (mdb) BE which does support the User Level Security I noted that, so long as the CurrentUser 'Admin' is blocked (If CurrentUser = "Admin" docmd.Quit") then users are still required when...

Hi DJkarl, Yes your right in 2010 accdb no longer uses workgroup security and that's why I've left the BE in 2K format. It works pretty well. However to change passwords or to add new users I have to log onto the BE. So, rather then dropping a new shortcut on users desktops I was hoping to...

I’m using a secured 2K mdb as a backend and 2010 (accdb) as frontend and have a problem in that the FE doesn't recognise DoCmd.RunCommand acCmdUserAndGroupAccounts so users can’t change\reset their passwords or add new users to the workgroup. I thought about giving users another shortcut to...