Search results

When I add the excel library in access then try and use a function from excel that is an "add in" it doesn't work. Is there something else I need to add other than the excel library? Example is the workday function in excel. Thank you.

The plot thickens - thanks for the heads up I was just looking in Access VB help - now I search Outlook. Marie :D

Thanks - I'll play with it and see what happens.

I want the following part of my docmd. sendobject to display in the message portion of my email as a hyperlink. \\Net\group folders\Data Services Planning and Engineering\Products\ If it weren't for the spaces in the path it would automatically. I'm not sure how to incorporate...

I use the following code on a form to inform various individuals that a report has been placed in a folder for their viewing. Because the "path" has spaces in it, the users are unable to click on the link and go directly to the site - I can do this manually by highlighting the path and pasting...

Thank you! I'll try it. Marie :)

I'm able to send a query to someone via email using the SendObject, however, when I replace the "To" variable with a path to a folder, it, of course doesn't work. What command would I use to run a query and send the results as an excel document into a folder? Thank you.

I have an unbound form, with many subforms. The unbound form is used to select records on the subform. Everything works just fine EXCEPT: When a user goes to the subform and sorts a field, the sort works just fine. (They righ click and select sort ascending or descending). Then when they...

thanks! I'll give it a try. Marie

I would like to utilize a list box, where a user can select multiple lines and then send those selected items in excel format via email to another person. I have the list box part okay - I just got stuck on the other part. Just point me in a direction and I can do the research. Thanks! Marie

As a follow up . This problem was occuring at work where I have both Access 97 and Access 2003. In creating my Access 2003 database, some of the users could not view it, so I converted it to an Access 2002 file. Apparently, I can't use a 2003 link table manager with a 2002 database. So I now...

Thank you!

I have access 2003 and access 97 on my computer - with access 2003 I can import tables as linked tables, they come in fine with the little arrows next to them. But when I go to manage my links, the window comes up empty. What am I missing?

Thank you!

My Access that came with my computer did not come with the Northwind Database - I know that I've seen it on the Microsoft web site before but can't find it now. I searched for Northwind.mdb and go no results back. Is this not available anymore or, more likely, I just searched for the wrong...

You are correct - that was the problem - as soon as I removed the quotes from around the zero it worked! thanks. Marie

The following is code associated with a form that opens up an excel template. This template is tied to a table in access and I want to refresh the table. I recorded a macro in excel to do just that and the code came recorded as follows: Range("A2").Select Selection.QueryTable.Refresh...

The following is on a query I am using to calculated percentages: Switch % Capacity Utilized: 1-([Switch Ports Available]/[Switch Total Ports Turned Up]) Because I have some instances where the divisor is a zero, I was getting "Error" - so I revised the above to: Switch % Capacity Utilized...

Well - I'm impressed. How do you know that and how do I research what is on her computer? Even if you don't answer - thank you! Marie

We are using Access 97. A text box on a form contains the following in the control source: =Ucase(Mid[txtSiteCLLI],5,2) This works fine on three computers that use this form for input. On the fourth computer the #Name comes up in the text box and the function refuses to work. I looked at her...