Search results

My concern is not just for the code but we are accessing the HR database in this particular program and managing time sheets - so there is personal info on the back tables that really even I shouldn't be privy to - but as the designer needed.

Bob - Duh - I have never attached a file. OK - I attached one. What is the difference releasing with an accdr extension?

I am running Access 2010 I don't think the img is going to copy - it shows File Home Add-Ins Home has limited functionality but more than I'd like. and because the ribbon is on so is the ability to right click a form and have that functionality.

I am using the following code to turn off the Ribbon and hide the Nav Bar in an Access DB. 'turn off ribbon DoCmd.ShowToolbar "Ribbon", acToolbarNo 'turrn off nav pane strTableName = DLookup("Name", "mSysObjects", "[Type] = 1 AND [Flags] = 0") DoCmd.SelectObject acTable...

OMG - I got it - it's all about placement. I threw the code strTableName = DLookup("Name", "mSysObjects", "[Type] = 1 AND [Flags] = 0") DoCmd.SelectObject acTable, strTableName, True DoCmd.RunCommand acCmdWindowHide at the end of my switchboard load and that keeps it off. Thank you...

OMG! Well - ya - I SelectObject all over the place. Throwing forms here and there - Switchboard especially. OK - So can I remove all of the objects from the Nav Pane for end users but keep them for me?

It was a ribbon issue - I took the acPreview off and switch to acNormal so now the report goes directly to the printer. Bob - I am screaming over here in hot west Texas.... My last thing to lock this puppy down is turning off the nav pane. I have unchecked the Nav Pane display in Current...

HELP! LOL! I have always wanted to start a problem with that. In Access 2010, I have a report that comes up appropriately but does not allow a right-click menu or close from the X. I do have the acToolBar set to no - do I need to set it to yes when opening reports and back to no on close...

I have some script that adds people into groups based on their supervisors choices. We do, however, have supervisors that choose over and over... they forget their requsts.... Based on this code and adding a check where I have marked - does anyone know a surefire piece of code to check group...

The answer - thanks to my boss who had 15 min - quad quotes For Each var In Me.lbStaff.ItemsSelected strFilter = strFilter & """" & Me.lbStaff.Column(0, var) & """" & "," Next var Me.tbFilter = Mid(strFilter, 1, Len(strFilter) - 1)

Nope changing the "!" to a "." doesn't work.

I am trying to reference a Form Control for an IN() Criteria in a Query. In the VBA - I wrapped txt quotes around the items in the list and saved to a form control tb.Filter - seperated by no space comma - trimming last comma. strFilter = "" 'get all StaffIDS For Each var In...

Got IT CHOOSE() Choose(1, "Tech", "on", "the", "Net")would return "Tech"Choose(2, "Tech", "on", "the", "Net")would return "on"Choose(3, "Tech", "on", "the", "Net")would return "the"Choose(4, "Tech", "on", "the", "Net")would return "Net"Choose(5, "Tech", "on", "the", "Net")would return...

I am not sure if VBA has this capability - something like A = PICKONE(InCode, "String 1", "String 2", "String 3", "String 4") so that if InCode = 2 it would choose String 2 :confused:

Thank you so much - I see two Treeviews I am interested in replicating. And it looks like with the data I am linking to that it just might be possible.

We have 7 macros in play in Excel across several programs. Those written in 2007 all had to be re-written for 2010. The only issue I still have in 2010 from the 2003 migration is that the Personal workbook wants to have to be open to run macros. My SEUs start putting data in the cells and...

We have had minor issues in 2003 to 2010 compatiblity and had one developing machine in 2007 which had a lot of issues in 2007-2010 compatibility. Our Recordsets had issues - we had to modify the reference library. Also, we had to code around automatic emails. I still have 4 DBs to "play"...

I know - and you and I both know they are hard at work on Office 2012 and don't care much about "fixing" issues not taken care of for 2010. I can say that we are bound to Microsoft for most in-house DB projects (about 65%) and therefore I wish Microsoft would A) slow down on releases every...

Yes - it worked. :D I wouldn't post an answer that doesn't work - no one should have to look through the "answers" I got. I had to look through 2 hours worth of c r a p online to get to this one thing. Suppose to be a well documented "BUG" - maybe they will put the fix in an SP release.

The answer is so ridiculous - I have to post! http://www.anysitesupport.com/access-the-database-has-been-placed-opened-or-locked/ When you open a 2010 DB, as you know if you set security, you have to click Design Tools to place the login screen in design mode so you can get to the back...