Search results

I am interested in making forms show current data, but I am hesitant to use requery in the timer event. Firstly, I have a huge aversion to the timer event in general. I don't like that I can sometimes tell when it runs. Sometimes the mouse wheel spins. If I am writing code and it runs my...

I don't think so. Just don't use an input box. Use a new form. You will probably want popup and modal set to true.

A couple of things. Firstly, if you are using the xml I posted, I posted a version for 2007. That version does not have a backstage. Make sure you change the xmlns property. Secondly, your xml shows gethelperText. I'm sure it should be getHelperText. Notice the 'H'. I also noticed you did...

Run this once from the immediate window: Public Sub CopyCutPaste() Dim cmbRC As CommandBar Dim cmbButtonCopy As CommandBarButton Dim cmbButtonCut As CommandBarButton Dim cmbButtonPaste As CommandBarButton Dim strBarName As String strBarName = "CopyCutPaste" On Error...

I don't know what you mean by popup menu. You mean the right click?

The sample I posted is only designed to work with one dynamic object. If you have mulitple dynamic objects, you have to start expanding the code. You are using the booVisible variable for everything. That will cause issues. You need to separate variables to store the visible status of...

This shows you the basics of dynamic ribbons.

I think the start from scratch command disables qat. I've locked down stuff before and there is nothing harmful in the QAT.

Access allows you to export reports to pdf. PDFs allow you to place signatures anywhere. Just use the Fill & Sign toolbar and click on Place Signature. If you don't see that, you may be using on old version of adobe reader. I'm pretty sure the link MarkE posted uses a reference to Acrobat...

I'm not sure, but it may not be the best idea to rely on those filters. If there are many different values those filters wont appear.

What is this subset of unique data? Can you elaborate on that? Depending on your answer, I'm wondering if you can have two tables: tblProjects -ProjectID -Other Stuff tblProjectData -ProjectDataID -ProjectID -Field1Label -Field1 -Field2Label -Field2 Have enough blank fields of various...

I'm pretty sure they mostly just wanted you to disclose that you cross posted this. That issue aside, if you are expecting free help on a technical issue, you should treat these volunteers with a bit more respect.

Yep, you're going to get a ton of help.

Check this out. That website is the best resource on the whole internet for ribbon stuff. Also, if you disable all those command in the xml in my sample you can almost lock down most of the things end users don't need access to.

The get subs are called by the xml. The set subs are called by us via vba. The only thing the set subs do is set a variable and tell the ribbon to invalidate (which forces the get subs to run). Everything about this dynamic ribbon hinges on the variables. Anytime you get error 91 it is...

Invalidate is our way of telling the ribbon to refresh itself. It is a method of the IRibbonUI object. That is why we have to use the reference. All of those get subs are called by the ribbon interface every time we invalidate. We don't actually call it ourselves.

Heres going above and beyond...

Bear with me a few more minutes. I'm almost done.

I've always seen people recommend against 64. Personally, I don't know one from the other. I've only read that you do NOT want 64.

Noooooo...you want 32 bit. Get rid of 64.