Topics Search

Prob in Excel

Prob in Excel
Views: 2
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?

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.

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.

Initiate Export to Access from Excel

Initiate Export to Access from Excel Icon
Is it possible to initiate an export from Excel to Access from Excel?

I also cannot find it discussed on forums.

Multiple users are using individual, I am attempting to centralize the separate excel files into one access file. Even though the spreadsheetenvironment is not shared and centralized, the access file is centralized.

It is not feasible for me to run docmd.transferSpreadsheet from Access because there are too many excel files to reference. A better way is for the excel files to include an identicalmacro that references on Access file.

Secondary question: is it possible to export excel worksheets to other excel files? In this scenario I could centralize all the data into one excel file before importing that file into Access.

Using Excel macros

Using Excel macros Icon
I have some excel macros that work great in excel. I am trying to import a sheet into access and need to do some formatting on the sheet before the data can be imported. Like I said, these worked when it was just excel, but when I put them into Access, I run into all kinds of errors.

I have built a connection to the excel file, then have put in the original macros:


The first error I run into highlightsthe xlDown, saying it is an unnamed variable. In excel vba, this is a valid command.

Import Excel file as report template - possible?

Import Excel file as report template - possible? Icon
The subject pretty much sums it up. Is it possible to import an excel file into Access as a report? I have an Excel file that looks like how I want the data presented, with the data filled in on the Excel sheet. I take it I would have to export to the Excel file and print the Excel file? in that case?

Date formate prob

Date formate prob Icon
One of my tables are link to a form which the user is allowed to input a date by hand or using the calendar function, the formate seems fine at this point.

The data then is used to merg into a word doc after a query has got the information needed, but when it goes into the doc the formatting changes to USA, as you will understand you cannot change the formate within word as it kills the merg field.

Top 10 reasons to use Access with Excel

Top 10 reasons to use Access with Excel Icon
When using the Office family of products, should you use Excel or should you use Access to manage your tabular data? Why choose between one or another? If you store your data in Access and connect to it from Excel, you gain the benefits of both. Here are ten reasons why a marriage between Excel and Access makes lots of sense. Excel users, don't be afraid to let go of your data. Think of it this way. You're not losing an Excel daughter; you're gaining an Access son-in-law.