I am having an issue opening an old database somebody else created, and I can't figure out the problem I am using access 2007, and when I open my database immediately I get the error message:
An error occurred while loading 'Form_MAIN SCREEN'. Do you want to continue loading the project?
I...
I am trying to get the variable "MyList" to only have unique values. It works fine when I just load all of the values, but I can't prevent duplicates. The values are sorted alphabetically, so it shouldn't be that difficult, but I am at a loss. Any help would be greatly appreciated. Thanks...
I have a bunch of weekly jobs, running to a partition that contains three tapes. We have two drives, and the jobs all run smoothly until a tape fills up. Once the first tape fills, it goes to the third tape. If the second tape fills while the third tape is in use, the job won't recognize that...
We have 70 store locations with vpn connections through cisco 871 routers. Every time there is some disruption, the tunnel drops, which I understand. The only problem is that it does not re-establish the connection. The only way to bring back the tunnel is to telnet into the router and reload...
I have the code below, which in xp is creating a new menu bar with items to click which will run the macros assinged. When this is opened in excel 2007, the addins tab has the "Order Entry Program" dropdown menu with all of the items in it, and also all of the items on the addin tab. Is there...
I understand, but when I am looking at the form, the "line" button is not in my toolbox. That is why I'm stuck. I have no way to get a line on the form, by design or by code.
When I am looking at the form, the toolbox does not have a "line" option. When I am looking at the code, I can not even click on the toolbox. It is greyed out.
The toolbox icon is greyed out while i am looking at the code, and I can't bring it up. my visual basic version is:
Microsoft Visual Basic 6.3
Version 9969 VBA: Retail 6.4.8869 Forms3: 11.0.5709
Could you post the full code above? Then I can modify it. Thanks!
so, it should look like this:
with ThisWorkbook.vbproject
Set xObject = .References.Item("ordering")
.References.AddFromFile("c:\my orders\ordering.xls")
End with
Correct?
I have an excel file with some macros and forms in it that I have emailed to some external users and are getting the above message. I have searched the error and have found the solution, but I don't want to have to walk 100 users who don't have a strong grasp of computers through the steps of...
I have an excel workbook, that uses a ton of vlookups. In each row, there are 7 vlookups. They pull product information (description, price, size, etc) from a worksheet (PRICE BOOK) based on a sku number (Column A) on the main worksheet (TEMPLATE). Is there a way I can find the row number of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.