I have a word doc that on close I would like to have the hyperlink addess from that closed file automatically entered into the next available cell in a specific column in an excel spreadsheet. I think this should be possible with VBA but am not sure where to start since I am going to be working...
I have inserted an Excel Shpreadhseet Object created from my Excel file into a Word .doc. Some of the cells seem to have a light grey fill color in the embedded object but not on the spreadsheet when it is open in Excel. I check conditional formatting and the fill/pattern and both are clear...
I have 2 forms - a main form and form no. 2 in the same database. The main form has the contact information which the user chooses a selection from the drop down and the text boxes autofill with the correct information. Works great. But when I try the same thing (just with different information)...
I have been trying to auto populate a text box based on a user selection from the combo box in the same form. I changed the control source of the text box to reflect:
=me.Company.column(1)
And my row source for Company is:
SELECT Customers.Company, Customers.First, Customers.Last...
New dilemma....
I have my database which has sub-forms. I added the Add record Command Button but I am confused as to where it adds the record. When I look for the record, it is not there. I need the record to be linked with a field [Company] from the main form.
IE: When a user selects a...
I have a main form with a field for a company name. The user has the ability to choose the drop down menu and choose from a list (which is a linked table from our server). When the company is chosen, the appropriate fields for the person is completed...address, phone number, etc.
I have 3...
I would like to disable the Mouse Wheel in Access 2003 and have not been able to find anything that seems to work. I am not very familiar with code but I have tried to enter code from previous examples on how to disable the mouse wheel but I cannot get it to work.
My reason for disabling the...
I have created this database which connects to our server and autopopulates a main form. The main page has all the fields from the public folders in outlook. So when I want to view a certain company, I choose the name from the drop down menu (combo box) and the remaining fields autopopulate from...
I have a database which I have linked with the Public Contact Folder in Outook. The Company Name is populating in the combo box automatically. However, I would like the user to have the ability to use the combo box to choose from various companies (populated by the public contact folder) to view...
I have created a database to track our customer base, orders, shipping, etc. I would have also linked our public journal as a table in Access. However; how can I get the public journal to show on the form? I would prefer to do this without code since I am code challenged. Can someone give me any...
Our HP2600 has been working fine until there was a problem in the area and our printer started to automically detect the IP address and everyone lost the ability to print. I was able to manually input the correct IP address and entered the Subnet Mask and the gateway but I think I entered the...
We are currently running Windows 2003 Small Business Server and have 4 machines networked running XP Pro. One evening we had a bad thunderstorm which created a power surge. Ever since that night, we have lost our intranet. The message we receive is Database server not running. Please check...
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.