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?
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
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
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 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.
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 been trying everything I can think of. No matter what destination file name I try to use, it just gets copied over to the Excel file; it just takes whatever I type and treats it as a literal; i.e. Now(), "Random' & Now, and whatever else I try.
Is there no way to have the excel file name dynamic so it will make a new file And not over-write the existing file? I am using the full path name and it is exporting the Excel file to the correct location.