Prob in Excel
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
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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)
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?
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.
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.
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.
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.
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.
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?
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.
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.