Topics Search

Prob in Excel

Prob in Excel
Views: 0
I have used the same formula in COL C I.e. col A-col B = 0, NO CHANGE IN QTY. 1st row it works correctly but 2nd row it shows false. I don't know what is the prob
Sponsored Links:

More topics

 

Problem with opening the database

Preview
I have created a database in version 2003 and 2007. the users were able to opened either one of them in their PC but there is one user who could not open the file and access keep saying that it can't change the working directory.

I have labeled the problems according to what comes first in my screen. I.e Prob 1, prob 2, prob 3, prob 4 (where it shows blank screen)
 

MS Access 97/Outlook 2003 interaction, error msg:not implemented

Preview
At work i usse windows xp,MS Acc 97 /outlook 2003. when trying to email a report thru Acc 97 via outlook 2003, i get a err msg "not implemented". Ive tried reinstalling both, still get the same msg. when others on their computer access the same db, they have no prob. Is my prob with Acc 97 or Outlook 2003?
 

Passing value from one for to another

Preview
I can seem to work out the prob pleas help
I need to pass value from form1(form) to form2 and save the value in table 2 of form
 

Keep From Copying Database

Preview
I am wanting to develop an Access database, prob in 2007. When I develop it, I want to be able to sell it. I want a way to have the customer to register it and not be able to give a blank copy to his/her buddies
 

Exporting to excel. Opening workbook and then editing it...failing

Preview
Like the title says I am trying to push a table out to excel. Then open the excel workbook and edit it. I used an excel macro to create the editing part in excel and think I converted it right.
 

question driven query

Preview
I have a query that pulls from just one table. What I would like is once the query is clicked, prob 3 or so to drive the criteria. In the past I have done this for dates but can't figure this one out.

the fields to be queried are all checkboxes. IE: Was the voice Male or Female?(they are both checkboxes) Was it a child? (a checkbox) Which Antennae was it heard on? (6 total options, all checkboxes.
 

Access to Excel

Preview
I'm exporting data from Access to Excel using "DoCmd.OutputTo" and it works fine. However, I need the data formatted in Excel and would like to know if there is another way to export into Excel using a custom template. Or a way to automate formatting of the excel spreadsheet
 

Importing Excel 2007 spreadsheet into Access 2002

Preview
I have an Access 2002 database which a number of users use to import worksheets from excel. Most of my users are using excel 2003 but a few have migrated to excel 2007 to move beyond the row limitation. The GUI for my db uses the docmd.transferspreadsheet command to import the excel tables. I get an error when trying to import an excel 2007 table. Any comment on modifing the vba code to allow import of the excel 2007 data.
 

Showing % Sign in Access

Preview
This is prob a simple query (i hope :-))

On one of my fields within a processing table I am trying to default the data type to show a % sign when a value is enterd without manipulateing data eg user enters 50 shows as 50%

What currently happens is user enters 50 turns into 5000% is there a way I can counter this I have tried to enter different formats but nothing seems to change this
 

print on macro

Preview
Would someone be able to help with a print prob please.

I have a macro which prints a report of a days money.

sometimes the report has two pages.
could you tell me how to only print the last page in the macro lines