Search results

I don't think there is a way for the tab's label to NOT be there. @Ari, what do you mean by that Add_ins bit?

I think so. The xml code you posted should work. Worst case scenario you can startFromScratch=true. You can hide buttons, menus, and tabs. Just use the getVisible callback. I can test it when I get home. This computer wont let me use custom UIs.

Its hardly new! What are you trying to hide, and when should that happen? Most objects have a getVisible property. edit- If you are only trying to hide the home tab, you posted the xml for that yourself. I'm confuses as to what exactly you are having trouble with.

You can use the LoadCustomUI method to load the xml file from a string, and then you simply set the database property to set the ribbon. I believe the property name is RibbonName stored as text. The first time you set the property, a restart of Access is required. I don't think the file button...

If you're using a datasheet, you set the width to -2(I think its 2). If it is a standard form, you can anchor the control so it stretches across the screen in Access 2007 and up, but that doesn't really answer your question. If you want to go through the trouble, you can test the length of the...

Is there no way for me to tell the difference?

Yes. In the button's click event, you would do something like: Forms![orders].YourFieldName = me.YourFieldName Before that, make sure the orders form is open, and move to the appropriate record. Before you get carried away, look into naming conventions. You don't want spaces in your form...

Check out the application.LoadCustomUI method.

Of course I can, but I'm asking because I don't know the network topology. Basically, I don't know how far away the shared drive is. The backend should not be stored on a WAN, or so I've read. I've had issues before doing this that would cause Access to get hung up. I tried a traceroute, but...

You should do the steps David Fenton describes here once every day or so. Also, make backups frequently. Especially anytime you make large changes, whether it be to code or to objects (such as deleting a form!). Also, email yourself all necessary files regularly.

I have a shared drive at work, but I don't know the network topology. I do know there is no wireless involved. How can I determine if it is okay to use to store the backend? Can I tell simply by pinging it and checking the response time? Should I build a test that writes a new record over...

It allows you to make your own properties and do with them what you will. The debug button will print all of the properties to the immediate window. To see that, enable special keys, restart access, press Alt+F11, and then I think it is Ctrl+G. If you are having issues, use the debug button...

If I understand correctly, it sounds like a permissions issue. Make sure the user has both read and write access to the backend directory.

All of the properties are built in. Most can be accessed from the Options > Current Database. Like I said, this form isn't necessary, I just think it is very convenient. It's very anoying to go finish up a project, make the mde, and then realize you still have shortcuts enabled.

Here is what I am using just for cut/copy/paste. I think all of this was derived from ChrisO's work. The first part creates the menu object in the database. You can run this from the immediate window first: Public Sub CopyCutPaste() Dim cmbRC As CommandBar Dim cmbButtonCopy As...

I think his code can be trimmed down a lot. What's nice about it is you can use tables to control how the menu is.

Here is something you might like. I will post it in the sample database eventually once I have used it some more. If you notice any errors let me know. Use it to set all the properties to lock down your application. Ctl + Shift + K to open the form. Of course Access provides a GUI for...

Ahhh...Here it is.

There is a really good sample here somewhere. I think it was by ChrisO. I'll take a look for it.

So when you say unmanaged, you're not talking about C, you're talking about the mda file itself? It sounds like you could do the same thing I did and write a managed addin to install the mde and provide a custom ribbon interface. Edit-When I say install, I really mean placing the mde in a...