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:

Similar posts...


Problem with opening the database

Problem with opening the database Icon
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

MS Access 97/Outlook 2003 interaction, error msg:not implemented Icon
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

Passing value from one for to another Icon
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

Keep From Copying Database Icon
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

Exporting to excel. Opening workbook and then editing it...failing Icon
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

question driven query Icon
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.

Showing % Sign in Access

Showing % Sign in Access Icon
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

print on macro Icon
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

Importing Excel 2007 spreadsheet into Access 2002

Importing Excel 2007 spreadsheet into Access 2002 Icon
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.

Print Access Report to Excel

Print Access Report to Excel Icon
I have rptITDReports that I need to print to excel AND have excel automatically open with the report. I can send the query to excel but it doesn't give the totals that are in the report. Presently they have a macro for the old version of their report that prints the report in excel format.

The problem is that they have to then hunt to find the report. This was not a bigdeal form them but now there are new users in the office and they want to simplify it but having the report automatically open in excel vs having to print to excel and then hunt to findit.trying to save mouse clicks.