Search results

I am having a small issue with using the .dropdown command. I am using a combobox as a search tool with the code Me.combo107.dropdown in the On Change Event. I am using the Not In list property set to yes to trigger a custom message box stating that the number is not a valid project. If the...

This is a shot in the dark, but maybe it has something to do with the compact on close. To get there got to Tools-Options-General Tab, and unclick the box named "Compact on Close". Good Luck....Gregg

I need to see if any of you can give me some info regarding Linked OLE objects. Currently, I have a database that has a tabbed page with 8 text fields which are OLE objects. I have a button for each field in order to insert whatever type of attachment is needed and the icon of that application...

Hey Bob, I probably should have mentioned that I am pretty new to VBA, so please excuse my rookie mistakes. My boss pointed out the same naming convention to me, and I am starting to use it. Most of what you are seeing now is older code. I tried the revised version and it appears to be doing...

Here is an example of what I am working with. I put the rule that I am using on a label at the bottom of the page. The scenario in this case is that the operating unit is always going to be 1410. So, anything that is below $5000 should be 0.065% tax with 0% flat tax. Anything that is greater...

If you go to tools -> startup Unclick All Built in Toolbars. That will completley get rid of it altogether. Also, you can click on the arrow at the end of the tool bar that lets you add or remove buttons.

Sorry for the delayed responce. Thanks for responding so quickly. I have indeed tried the before update which gave me the same results. I have also tried running the calculation in the after update before my iif statement and that also did not work. As of now, my only solution is to leave the...

I am working on a bill of materials database. Once a record is entered, the current total appears. After the record has been updated, I would like to use a iif statement that determines what the tax should be. I already have my iif statement that is working. My problem is that the calculation...

Currently I have a table called documents with about 10 ole objects. The fields are doc1, doc2, doc3,.....etc. I have set up a form with 10 bound Object Frames and a command button for each ole object. I put VBA code in the on click event that says: Me.doc1.SetFocus DoCmd.RunCommand...