Greying out controls Hi Guys, I'm trying to grey out a control on a form when a check is put in a checkbox. I know there's been a couple of similar threads already and i've actually got the control to become greyed out but when i open the form again later, the control is no longer greyed out even though the checkmark is still in... 6 Jan 2010 09:46
HOW DO I GET MS ACCESS TO WORK WITH GOOGLE MAPS I am using ms access and want to display a map of address, city, state, zip, and country from my database. i am not a programmer but could certainly use some help. I understand to create a button i just don;t know how to create the code or link to make this work. Thank you in advance ... 7 Jan 2010 02:31
Syntax Error on DLookup I have a code that I've copied and used several times but it isn't working in this one instance. The control to which this is attached is on a subform nested 4 deep. The control to which it is referring "Measurements" is on Subform3 (the parent of subform4). Here's my code: DLookup("Expr1", "qryMeasurements",... 6 Jan 2010 09:46
Using less than a date in Code To prevent date mistyping of the new year, I'd like code to run on the AfterUpdate event of my DateInspected control if the user accidentally inputs a date before 2/28/09 (for instance, 1/4/09 - when it probably should be 1/4/10) My table is storing the date in 2/28/09 format. Here is my code: Private Sub DateIn... 6 Jan 2010 09:46
Form Menu's Question I have encountered a problem in Access 2003 where the user has performed a "File, Print" option and wasted a ton of paper... I have looked through the existing posts and found advise on creating a custom toolbar. Under Tools, Startup options I have taken away all menu's and toolbars, however, the user still has... 6 Jan 2010 09:46
"Copy" isn't available now Error I have a command button on my Main Form that is supposed to, on the OnClick Event, set focus to a control on a subform and copy its contents and then close the entire form but I am getting an error that "The command or action "Copy" isn't available now." Any ideas about how to work around this?? The OnGotFocu... 2 Jan 2010 18:18
From another mdb run VBA code I have a function updateTables() in a a different db. How do I run this remotely. In addition is it possible to pass parmeters Regards -- Trev B ... 3 Jan 2010 17:11
Back tab between subforms? Some of my users are naturally using a back tab (Shift + Tab) to back up to a previous control where they may have made a mistake or tabbed to quickly over but in this case, the previous control is on a different subform. The back tab doesn't work - it only ends up tabbing to the next subform. Can I make a fi... 2 Jan 2010 13:55
Making an Access 2007 app more professional looking. I'm trying to figure out the best way to deploy and make my Access 2007 application more professional looking. The database is readonly so I'm thinking I can save it as a .accde file and give that to the user. I'd like to be able to disable and hide the ribbon and all menu commands. I really only want to display ... 1 Jan 2010 20:40 |