Hi Bill, this page might be helpful: Ribbon XML / Controls by Gunter Avenius http://www.accessribbon.de/en/index.php?Access_-_Ribbons:Ribbon_XML___Controls ...
Hi guys, I know that this is going to be a pathetic question, but I do not usually handle anything to do with my works Access 2000 Database. My boss wants a...
Hi Lucao, The correct way to handle this is to detect the fact the the item is booked out before any changes are made to the data, and issue a warning message...
Thanks Crystal, I had found this site but I had not found this page. I will update my code to the 2010 version. It looks like in 2010 the PRIVACY OPTIONS...
Thank you very much Mr. Viescas. The code works great. What caused confusion was, after the report was loaded on the screen, I used the navigating button to...
Phucon- There's only one copy of the variable intG50, so once it is set to True after finding a value >50, it will stay that way. It should work just fine if...
Hi Bill, you're welcome, Bill ... I am curious to see what others have to say about this I don't usually hide things because I most often am building an...
Bill I haven't worked much with Access 2010, but some of my clients have it so I need to take the extra step to hide the Ribbon. I use this code: Private Sub...
Bill, Interesting. I am wondering, since the FILE tab is not part of the Ribbon in 2010, will it hide the FILE tab? Either way I will take the code home and...
Hi Crystal, Hope you're having a great day! Since putting the db online would mean it would take a chunk of time to alter the data for confidentiality, I've...
Bill The File tab is part of the Ribbon. It's just not hidden when you hide teh other tabs as it is meant to be the way to get to the Backstage. When I use my...
Connie - MsgBoxes are always modal. You can't do anything when they are open and your code pauses until the user responds. Therefore, you can't test to see if...
Hi Connie, thanks -- my backyard isn't a jungle anymore and my roses are popping out everywhere! ... and it looks like it might rain so I won't water my garden...
Connie - I think you figured it out. When an Access db is being backed up the backer-upper has to stop and start over if something changes in the database. I...
Bill, I have once again encountered that when I use the Close button on the Sold form (when the control was last in a subform), if the subform's AfterUpdate...
Connie- You should be doing any validation checking in the BeforeUpdate event, not AfterUpdate. If information is missing, you can set Cancel = True to halt...
Hi Lucao, Did you fix the problem? Did you understand my previous reply? We need more information to be able to suggest a fix. If you can upload a copy of your...
I tried writing my first bit of code without help and went down if flames. I have a form that the user will select a value from a Combo box and then press a...
Hi Bill, first: NAME the command button something logical before you assign code, like cmd_OpenQueryName Null is not a value, it is the absence of a value, so...
I have 2 tables. Table A is in a SQL DB (Linked to Access). Table B is in Access 2010. I have a query that inserts an ID number from table A into table B....
Troy- DELETE * FROM TableB WHERE TableB.IDNumber NOT IN (SELECT TableA.IDNumber FROM TableA) John Viescas, author Microsoft Office Access 2010 Inside Out ...
John, Thanks for the reply. Should I have any performance concerns? TableB has about 3,500 records, and tableA has about 300 records. The query you gave me...
Troy- Alternative syntax that's probably faster: DELETE TableB.* FROM TableB LEFT JOIN TableA ON TableB.IDNumber = TableA.IDNumber WHERE TableA.IDNumber IS...
you're welcome, Bill ;) happy to help Warm Regards, Crystal * (: have an awesome day :) * ________________________________ From: Bill Singer Crystal, ...
Crystal, One more question if you do not mind. I have three combo boxes to check and then open a form. I have successfully finished the code and it runs...
