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.

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

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

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

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?

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

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

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

I am trying to run a procedure in another access database. I have the following code in the "active" database. The query and "PopBucket" procedures are in the "other" database. I got it to work - but would like to understand why the changes I've made have caused it not to work. I got this to...

I have recently upgraded to Access 2002, I also still have Access 97. While in Access 2002 I tried to import an excel spreadsheet into access. It kept causing my database to shutdown. "Microsoft Access has encountered a problem and needs to close. We are sorry for the...

My code, attached to a form, is not recognizing a procedure in a standard module. I have used this in other databases and there is no problem, but this particular database has decided to not recognize anything in the standard module. Which is where I store code that I can call from anywhere...

I have a table with has three fields as primary keys - to prevent duplicate information being input. I have a form that uses an append query to add data to the table. If the user tries to input a different dollar amount to an already existing Program/State/Date (the three primary keys) it...

Below is a procedure attached to a button on a form. However, it always ends on my tables tab and not on the form, so to continue I have to click windows, select my open form so I can click the next button. The offending line is the "Call VerifyImportErrorTables" - which I've also listed...

Private Sub Command0_Click() Dim objAccess As Object Dim strdoc strdoc = C:\\2003 Deployment Data\" strdoc = strdoc & "2003 DA Data_be_v2.mdb" Set objAccess = CreateObject("Access.Application") With objAccess .OpenCurrentDatabase strdoc .Visible =...

I am copying some forms, modules etc from an access97 db to an access2000 db. The following, which works in the access97 db, will not work in the access2000 db. It stops at the rst.FindFirst and gives me a compile error: method or data member not found. I've checked the book I'm using (Access...

The following code is attached to the click event on a form's control button (frmInput2004Expense). It is intended to open the report (rtp2004Expense) to the same project that the form is on. Simple enough. However, the report insists on opening to the first project and continues to list all...

I have an unbound form (frmInput2004Expense) that is calls an append query when I click a command button on the form. When I click the "add data" button I get the following error message. "Reserved error (-1517). There is not message for this error". I tried looking on the Microsoft web site...

I have a form - that when opened by itself appends data to a table (it uses an append query). When I open this same form from another form (I have a button that the click event opens it) the form doesn't allow any updates! What would cause the same form to act differently depending on where...