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.
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 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.
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
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.
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 :)
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.
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!
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.
I wonder if anyone here might be able to help me out here. I've been pondering this issue for so long and i was almost giving up.
I've been getting this warning everytime i open up an Access file (.MDB) especially, when trying to open up a file that's sitting on another computers. i have a few computers and they are set up in a peer to peer environment.
I took a printscreen of the warning message and attached it to this post. Please take a look at it. It's called "access.jpg"
Is there any way of turning it off? is it to do with the peer to peer networking?
I'm sure most people use Windows shortcuts to open their secured databases, but I found that it didn't always work (depending on which computer I used). Editing a shortcut is pretty confusing since the command is all on one line. I decided to make a batch file to open my secured databases instead. Here's a batch file I use to open a database of mine:@ECHO OFFREM - Set variables to be used in the batch file.SET BACK=Z:BobManager Listdb_be.mdbSET FRONT=Z:BobManager Listdb_fe.mdbSET WRKGRP=Z:BobManager ListSecured.mdwSET OFFICE=C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXEIF EXIST "%OFFICE%" GOTO PROMPTSET OFFICE=C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXEGOTO PROMPTREM - Ask the user which end to open.:PROMPTCLSSET /P dbChoice=Do you wish to open the frontend(1) or the backend(2)? if "%dbChoice%" == "1" ( "%OFFICE%" "%FRONT%" /wrkgrp "%WRKGRP%" GOTO END)if "%dbChoice%" == "2" ( "%OFFICE%" "%BACK%" /wrkgrp "%WRKGRP%" GOTO END):ENDThis isn't the simplest batch file ever, but if you want to use this you just need to change the paths to your frontend, backend, workgroup file, and your version of Access. If Office was installed in the default location you shouldn't need to change those lines, unless you know you'll always be using the same version of Access.
I have an mde database originally created in Access 2003. Will I be able to open it in Access 2007?
(I ask because this mde file was originally created in Access 2002, and wouldn't open in A03. We had to track down the creator and get her to resend a new mde file that was 03 compatible. Are we going to run into the same problem after the next upgrade?)
Hi guys, this might be a quickie, I did a quick search but couldn't find anything :/
Basically my database creates a table which some people would rather analyse within excel because they're not comfortable with access. I can get the table exporting to an xls file no problem, howeevr what I would like is for the database to export the file and open the file in excel at the same time so the user doesn't need to open up excel and find the file etc...
hello, i have an .mdb file, with one main form in it. i want to send to some friends of mine this file, but i want that when the file is opened, automatically, that main form will be opened. how can i do that?
hello good afternoon. i am trying to open different file types using ms access. the following piece of code i found would only open 'word' documents. how do i make this piece of code more flexible to open pdf documents and excel as well. as it is currently i have a txt field on my form and if the path in the txt fiels leads to a word document when i click a button the word file opens. i want it to open a pdf or excel doc if it was in the txt field
[code] Sub OpenWordDoc(strDocName As String) Dim objApp As Object
'Opens the document
Set objApp = CreateObject("Word.Application") objApp.Visible = True objApp.Documents.Open strDocName
I enclose a part of my project. I've taken out the table, query and so on.Only the form.What i want to do is to view only the form when entering the app. But if you open the file you could see a flash of the app before minimizing it. Very few, but you can see it. I've deleted some more code in the opening form that made the flashing a little bit longer.My code for entering is the following:
Code:
Private Sub Form_Open(Cancel As Integer) DoCmd.RunCommand acCmdAppMinimize Call fSetAccessWindow(0) End sub
And then in another module:
Code: Option Compare Database Option Explicit Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3
I want to open files from a networklocation from VBA, only normal users don't have access to that location (and should preferably not get it).
I instead of using shell("explorer.exe filepath") to open files using windows standard app for the file, which needs userpermissions to the path the file is located, for the currently logged in user.
I'm trying to use CPAU in combination with Shell, because using CPAU you can pass a user/password that has permission to open a process
The only problem is that the filepaths have spaces in them and that is Always a bit of a tricky thing to tackle.
The last command start explorer, but doesn't open the file (just as the first line I posted, it opens Explorer, but not the file. Must be something with the way I pass the filename?)
I would like to open a PDF document using a button control on a form to a file path listed in a field on the form (Me.Link). I am trying to use the followHyperlink code but I keep getting the runtime 490 error.
This is the code im using:
Dim strFilePath As String strFilePath = Me.Link Application.FollowHyperlink (strFilePath)
If I put a filepath to one of the pdf documents in the place of (strFilePath) it opens that pdf document fine but not when I declare a filepath based on the one listed on the form.
I am trying to program a button on my ms access form to open up an excel file.. So far the simplest code ive found online was from URL....
<code>
Private Sub Command57_Click() Dim xlTmp As Excel.Application Set xlTmp = New Excel.Application xlTmp.Workbooks.Open "C:Excel1.xls" xlTmp.Visible = True
[code]...
However the code doesn't work, any way to open a file from within access?