Is it possible to open an Excel FILE using a macro, if so could someone shed some light on this? I know how to open Excel itself using RunApp but it doesnt work with files.
Any help would be appreciated
Cheers all
Bikeboardsurf
I have a form in Datasheet view and when you click on a record in that form I want it to take you to a report with all the details of that record number. I have the On Click event set to run a Macro. The Macro is as follows:
OpenReport
Report Name Incident Report
View Report
Filter Name Open
Where Condition =[Event ID]=[Reports]!Incident Report]![Event ID]
Window Mode Normal
This Where Condition works for me open another form from the form with the same Event ID. Why does it come to a "new" Incident on the report?
Self tought in Access07 but I'm trying to do the following:
I've got a form (Clients_F) that has a subform in datasheet view with a list of quote numbers made by each customer, I have managed to make a Macro after a few hours and googling, that opens another form (Quotes_F) so that it can be edited when a quote number is clicked, but I wish to be able to open Quotes_F as a new record when the empty field under the numbers column in the list is clicked.
Also want to know if it's possible to mantain the Customer's details pre-filled?...I am guessing that this is done through the CustomerID(PK & FK)?
Hi everyone,
I was wondering if anybody knew a way to disable the security warning in Access that pops up saying "This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?"
If possible, I'd like to disable the message for just my database, but we currently don't use any other database anyway, so I'm not too concerned with turning it off completely if that's all I can do. I'm sure there has to be an option somewhere to not check for macros or something, but I can't find it.
If anyone knows how to do this or if you know that it is not possible, please let me know.
Thanks,
Sean
Question: Is it possible, using VBA, to determine the actual Excel file type without opening the file?
I receive data files from other departments. Seems like every time someone changes their download structure, I end up with file types that do not match the download extension (example: xlm file with a xls extension). The files can't even be opened because of this. I think I can fix it if I could figure out how to determine what the file type really is.
I'm using Office 2010.
i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text
i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.
I have a bound form that normally is opened via macro. Very straight forward just has the following in the where.
Code:
[userID]=[Forms]![Home]![txtSelectUser]
I'm trying to open the same form via doCmd.
Code:
DoCmd.OpenForm "frmUserInformation", , , "UserID=" & Me.txtProblemID
I've msgbox'd the txtProblemID and the correct ID is being passed. Where I fall into an error is on the frmUserInformation's onLoad event which uses the ID form the frmUserInformation.txtUserID box. The error I get is "Syntax error (missing operator in query expression '[fldUserID]='."
Code:
strEndMonth = DLookup("fldDateExpiration", "qryUserExpirationDate", "[fldUserID]=" & Me.txtUserID)
What I've narrowed it to is the timing between the docmd.openform and the onload of the form. I've tried changing the onload to be on activate - and it just opens empty.
how to get the docmd to open the form correctly before the onload tries to fire?
I changed the name of a form referenced in the Autoexec macro from "frmLogin" to "frmLoginPW". However when I Open Access 2010 instead of Form "frmLoginPw" opening I get a message box saying that the system can't find "frmLogin". If I do a search through all the code in the project there is NO reference to "frmLogin" as I changed any code to refer to "frmLoginPW" and recompiled the project.
I can not get rid of this error and if I press the OK button on this error message ( from MS Access not my error coding) the "frmLoginPw" opens and the code in the form works. (Password authentication etc etc.). I deleted the AutoExec macro and remade the macro and referred it to the new form "frmLoginPW", this did not work. I loaded the Accdb file using the Run command and the /Decompile command line parameter to no effect.
I need to find a way to close a file (spreadsheet) if it was left open by a user before my scheduled macros need to delete and remake that file to update it. Is there a way to do this in Access? I've been looking for scripts everywhere... Any help is greatly appreciated. Thanks, Rick.
View 1 Replies View RelatedI am trying to complete a macro that starts with importing of a text file. However, when I go to complete the steps in the macro, I do not see the specs for the import file that i created. There is a dropdown with a few specs for me to choose from in the box titled "Specification Name" when I am completing the action titled ImportExport Text. However, none of those specs are the right ones.
When I go to "Saved Imports" I can plainly see the import that I am interested in. So is a Saved Import different than a spec? If so, what steps do I need to do to create the spec?
Using Access 2000, I have a macro to generate a report by updating various make-table queiries. I would like for the macro to print the report to an Adobe PDF file and save the file as the database name.
When I manually print the report, it gives me the opition of selecting printers and Adobe PDF is listed as a printer. After selecting the "printer", a "Save As PDF" menu pops up and currently it lists the Access Report Name. I would like to use the database name as the name of the PDF file.
In short, when I execute the "Generate Report" macro, I want the end product to be a PDF file using the database name as the PDF file name.
I need to import 15 csv files into access every month. I have location of all those files listed in a table in the same access DB but i'm not sure how to incorporate them in a macro I have written to import one of those files:
Function Macro_TransferCsvFileTo_RatesTradeData()
On Error GoTo Macro_TransferCsvFileTo_RatesData_Err
DoCmd.TransferText acImportDelim, "Import_Spec_tbl_RatesData", "tbl_RatesData", "c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv", True, ""
[Code] ....
where c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv is the file name I want to be replaced by each of the file listed by me in the other access table.
Is there a way to create some sort of an EXE or BATCH file in any Windows Explorer folder, that executes me a specific Excel Macro?
My problem is that I got several files split up by Departments, updated every day.
So far I have to open each file and update the format.
It would make my life much more easier if I could just run a file that opens each file and applies a format to them.
Is it possible to open a Microsoft Word FILE using a macro(or even a query??)? I know how to open Word itself using a Macro by Selecting the Run App Command and typing in my Word address e.g C:Word.exe . I have tried opening a word file using C:filename.doc but no success, the address is correct as I've successfully opened it using Start, Run
Any help would be superb
Cheers All
Hi All
I'm not sure if this is even possible but I have a table which has a list of Categories(text) and another field named filepath(also text) which contains a file path which points to specific pdfs. So my question is Can I create a report which then prints the categories with a button next to them which if clicked on opens the coresponding pdf ?
Any help will really be apreciated I am a database novice but am really good at following instructions and copying code :)
Thanks in advance
Mel
Access 2000
WinXp Pro
Greetings:
I have a small access database that I keep on my thumb drive, the last time I closed it I removed my thumb drive before it finished saving and I got the windows was “unable to save” dialog box. Well, the next time I tried to open it, it would not open; when I click on it, it asks for the password (password protected) but when I enter the correct password “Nothing”. I tried to compact and repair but all I get is the option to browse as though there is no file open.
I have researched but can find no solution. Any help will be greatly appreciated.
thanks
Mickey
It is my understanding that a custom macro was built to pull text data from a file and import it into Access in the appropriate fields. This macro no longer works and will return the following error message:
"License information for this component not found. You do not have an appropriate license to use this functionality in design mode."
It only gives an option to click OK. When you do it shows a box called "Action Failed" that lists the macro name, condition, action name, and arguments with three button to click on the right of the box: "Step" "Halt" and "Continue". It appears that only the "Halt" button is available to be clicked.
Does this sound like an issue with the Access license or whatever license the macro might have? We're trying to decide if it's possible to restore the functionality of the macro.
I created an Excel file using:
DoCmd.OutputTo acOutputQuery, _
"Compile_Query", acFormatXLS, _
"G:ServiceCompanySanDiegoWarehouseLCDLine_Summa riesDaily" _
& DateMonth & DateDay & DateYear & ".XLS", False
However, after creating this excel file, i want it to automatically open.
Is there any way to do this in 97?
Hi
I am having trouble opening a file I created like 6 years ago. The verison has changed and I have changed computers. When I try to open the file I am receiving an error. That the current user account doesn't have permission to convert or enable this database. Is there a way to correct this? Thanks
Is there a way to stop users from opening the front end file twice (stop from having two sessions of the same FE at the same time)?
I've been searching the forum and found this
http://www.access-programmers.co.uk/forums/archive/index.php/t-67724.html
but since im not using an .exe updater is not my case t.t
I have a database application that I have to get to display some external PDF files.
I thought that I would create a command buttone and use that to open the files, but that doesn't want to work. Can anyone provide some thoughts on how to open a Word document or PDF file from within an access form? I only need to display it and then close the file so it doesn't have to be anything fancy.
Help
I wish to open a specific MS Word file using a button on an Access form. Word opens OK, but how do I get it to open the particular file please?
Thanks
I seem to be having a problem opening a file if there happens to be any spaces in the file name. If I open a .pdf no problem acro reader opens it but if it is in word or excell or any other tells me that the file can not be found and seems that only the first part of the file name before a space in the name and the file extention.
example: "Test it.doc" would appear as "Test.doc". somewhere it seems to be trimming the file name.
Windows 8.1, Access 2013, Microsoft Office 2007 , Access 2007 uninstalled When I try to open Options from File, I get the Windows Installer box open up, Preparing to install.......wait while windows configures Microsoft Office professional 2007. File Options was working before!
View 4 Replies View RelatedI've got a table with field define as hyperlink which stores link to a external pdf.
Then i create a form including this field and add a unbound field which has got intermet browser format (as a type).
What code I have to put in onclick event in a hyperlink property sheet to open PDF inside the form?
A colleague sent me an .accdr file, and since I don't have Access, I was told to download Access Runtime. From other forums I see that I'm just supposed to be able to double-click the file to get it to open, but I cannot. The file is associated with .7s, and since I can't locate the Access Runtime program, I can't change the association.
View 1 Replies View Related