Search results

Yeah thanks. Not really the ideal solution, but it seems that some work around should be followed. Strange that Microsoft has changed this behaviour. Thanks for the replies.

It happens when the focus moves away from the control. Even with the SQL provided.

Hi Thanks, but deleting what is in the combobox does not work. It works for bound fields, but if the field is unbound, then the default value appears when you delete the value. It worked on Access 97 - 2003, not sure about 2007, but not in 2010.

Hi I've downloaded the add-in and it works, but I can't see how I can use that as a base for my own add-ins. Don't see how I can add items to the Add-in menu that will call my functions, or change V-Tools as it is locked. Thanks for the reply.

Hi Using Access 2010. I've got an unbound combobox with a default value, but I still would like users to enter a Null value. I've got the Null value in the list of drop down items, but when it is selected, the combox value does not go to null, but instead goes to the default value. Any easy way...

If you have a control name and field in the database with the same name, a statement like that might cause problems. Change the name of the control to be different from the database field name.

Hi I'm trying to create a custom Add-In for Access 2010. I've created the add-in, and gave it a new ribbon with some buttons that will run my custom functions. I've created a accde file from that. Next, I've opened a new accdb where the Add-in should be added, and added it with the Add-In...

OK, now I'm creating a new ribbon and I can add new items to that ribbon, but only items that have been predefined by Microsoft. How do I add new items that I've made myself to a ribbon?

Hi In Access 2010 it is now possible to link a web service as a table. However, when I try to link a Data Service, and select the XML file, I get errors. I can't find a lot of info on the Interwebs, so I'm not even sure that I've got the correct kind of xml file. Error I get is "The Microsoft...

No, don't like Macros. VB just better. But if I don't have a choice I'll use it for the menus. But only for that...and the other areas where we are forced to use it :-)

The shortcut menus can also be created with macros.

Thanks. It seems like the vba coding as described in the previous post is only for backward compatibility and that they would like to force us to start creating our own ribbons instead of menus. That can be done. But what is Microsoft's preference for context sensitive (right-click) menu's...

Hi I upgraded an older Access app to Access 2010. The old app had custom menus and toolbars. The custom menus and toolbars now display in the Add-Ins ribbon, but how do I change those menus? Eg if I would like to add a new button on my custom form toolbar? Under Options -> Customise Ribbon, I...

Thanks for info, but as you mentioned its only good for bitmaps. The OLE will contain any docs, and will mainly comprise out of Word, Excel, PDF and MS Project. So I would need a generic method to calculate file size. Tx for reply.

Hi There is a form yes, but your solution will only work sometimes as users can still open the form and drag-and-drop a file in there. They can also copy and paste contents, and then I won't know from where the file came. We need the preview of the form and I don't want to remove functionality...

Hi I'm looking for a way to check the size of the file that was used to populate an Access OLE field. I've got a file on hard drive (any type), and I then add it to an Access database's OLE field. Now I would like to know how big was the orginal file. I tried the Access Len(OleField)...

Oops, apologies. :o Did try it now, checked and unchecked. Not working. (Its possible to switch the error handlers off and then its fine, so its not a train smash.)

Hi Nope, sorry. The option is unchecked, and Ctrl-Break is still not working.

Yes, I am using error handlers. If I remove the error handler then the message with the 'Debug' button comes up and the code opens. But with the error handler, I show a Abort, Retry, Ignore message box, and Ctrl-Break doesn't do anything there anymore. Did work a week or 2 ago... Thanks for reply.

Hi When I receive an error in Access and I press Ctrl Break, it does not goto my code (it used to work, but not anymore). Ctrl Break still works to halt query execution. I've tried uninstalling and reinstalling Access. I do have read, design and admin permissions on the form. My error trapping...