Recent content by indygirl

I have been successful in creating the Outlook Form with a button which will open a .dot for the user to complete. I have an icon on the toolbar that will allow the user to see the exact path address of the saved .doc and another icon to open a .xls file to enter that specific path address...

I can do part of what I am looking for by assigning a Word Macro but I need to alter the macro so it will autosave. How can I go about stepping into the macro? When I click step into my word doc closes all together and I am left with nothing.

Great idea. I will see if I can make this happen. ALways up to a challenge. Thanks!

One more thing, Excel does not open the .doc - Outlook does.

Unfortunatly, Outlook only knows the name of the template.doc not the actual saved name. The word .doc is a template that the user completes than saves as another name. Outlook doesn't even know about the Excel file. Do you think this is still do-able?

The user opens a form in outlook then clicks a button to open the Word Document. The hyperlink needs to be from the Word Doc. and needs to be attached to the button in Outlook and into the cell in Excel. Does that make sense?

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...

Thanks Hasit! You are the greatest!!!! It looks normal in print preview. Thanks Again!!!

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...

Thanks Ace! I do have the another Before and After Event but it is on the main form with a different field. Do I need to fully clarify the 2nd form? If so, how do I do that in VBA?

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...

Thanks! I tried your suggestion and it gave me nothing. :( The switchboard is there but was changed to reflect a form and for whatever reason, I could only view other forms. I check for Object Dependencies and was able to view the tables in that fashion. Thanks Again!

I have inherited a database in which the switchboard does not exist. How can I view the tables, queries, reports, etc.?

I tried the form name and the error message I receive is as follows: Run Time Error '2450' Microsoft Office Access can't find the form "Public Folder Contacts021907' referred to in a macro expression of Visual Basic Code. Which is odd since that is the name of the main form. I captured a...