Opening Different File Types With Ms Access 2003

Jan 15, 2008

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

End Sub

View Replies


ADVERTISEMENT

Opening Other File Types From Within Access

Nov 16, 2004

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

View 9 Replies View Related

Access 2003 ODBC Widows Not Opening

Apr 28, 2007

Hi m8

I have Microsoft Access 2003 which is running fine. I have setup ODBC source through windows xp Professional control panel.

While i am in access application and try to open by selecting
File/Get External Data/Link Tables

It open Link PopUp Window, then from the Files of type drop down, I select ODBC Database(). Windows just disppear, not opening odbc source selection
window.

Please could you help me, why this is happening and sort it out.


Many thank

View 1 Replies View Related

Opening An Existing Project In Access 2003

Aug 14, 2007

Hopefully this is pretty simple.

Have an existing app. When I open it from within Access the app seems to go into some runtime mode ... shows a splash screen, menus, etc.

Okay how do I go into design mode so I can modify it ?

Yeap am a complete newbie with Access and haven't touch since the Office 97 version :o:eek:

Not sure if you are meant to ask multi questions in one thread, or create a thread for each one. Will created a new thread for my other question, so if one of the Mods could point out the correct way of doing this would be appreciated.

View 2 Replies View Related

Forms :: (Upload File) Button Stopped Showing All File Types

Oct 7, 2013

I recently upgraded a DB from 2003 to 2013 and ran into the following problem.

I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.

In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.

Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show
Dim Yourroute As String
Dim yourrouteName
Yourroute = fileDump.SelectedItems(1)
yourrouteName = StrReverse(Yourroute)
yourrouteName = StrReverse(Mid(yourrouteName, 1, InStr(yourrouteName, "") - 1))
FileCopy Yourroute, "us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
Me.Drawing_Link = yourrouteName & " # us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
End Sub

View 1 Replies View Related

Modules & VBA :: File Open Dialog Does Not Allow Selection Of All File Types

Oct 4, 2013

I recently upgraded a DB from 2003 to 2013 and ran into the following problem.

I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.

In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.

Here's my code and a screenshot is attached.

Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show

[Code] ....

View 3 Replies View Related

Access 2003 File

Dec 27, 2005

I am wondering if someone could save the attached access 2003 file as an access 2000 file so I will be able to open it. Thank You

Jeffsal

View 2 Replies View Related

Creating MDE File From Access 2003

May 26, 2005

All..
I have an access 2003 application I have front end and back end separately. When I click "Make MDE File" from tools menu, nothing happens.
When checked the Windows Task manager(Windows 2000), CPU usage is 100% and MS ACCESS is not responding. There are no messages.

Anyone experienced this problem ?

Thanks
Bosch

View 3 Replies View Related

Importing XML File Into Access 2003

May 31, 2005

Hi, I have an xml which fields of text and some of numbers.

When I do: File --> Get External Data --> Import; I'm able to import the file.

The problem is that not all the data is entered in the fields. The colums containing the text are excluded.

While importing, I did choose the option "Structure and Data", so it should work.

Any suggestions on to why it is doing that?

Thanks.

View 2 Replies View Related

Workgroup File In MS Access 2003

Jun 29, 2005

I created a Workgroup file (Project.mdw), assigned different Permissions to different Groups, and put different Users in appropriate Groups.
The above setup is working fine and just as required. But, if I remove or rename the Workgroup file, MS Access does not look for it, creates in its own Workgroup file and starts just as usual - without asking for the Password, or caring about the Permissions and/or restrictions set.
How can I make the database file bound to the MDW file, so that it does not open without it.

View 5 Replies View Related

Dbf File Not Importing To Access 2003

Nov 3, 2005

I have a dbf file that I need to somehow get the table data out of, and into access, excel, or some other usable format. I searches the MS Knowledge Base and read several articles on updating the Jet 4.0 drivers (up to date) and updating Foxpro ODBC drivers, etc. I also searched these forums, and I have yet to find any solution that works.

I think this dbf file might be Foxpro, but I'm not sure. I don't know anything about Foxpro. I was getting an error message "unexpected error from external database driver (8961)", until I read an MS article stating that I should change the name of the Borland folder to BorlandOld and try re-importing. Now Access 2003 just says: "external table not in the specified format".

View 3 Replies View Related

Workgroup File In MS Access 2003

Jun 29, 2005

I created a Workgroup file (Project.mdw), assigned different Permissions to different Groups, and put different Users in appropriate Groups.
The above setup is working fine and just as required. But, if I remove or rename the Workgroup file, MS Access does not look for it, creates in its own Workgroup file and starts just as usual - without asking for the Password, or caring about the Permissions and/or restrictions set.
How can I make the database file bound to the MDW file, so that it does not open without it.

View 3 Replies View Related

Converting Access 2003 File To Access 2002

Nov 19, 2006

Hello,
I have created several files in Access 2003, and sent them to a collegue, but he is using Access 2002 and cannot open my files.

What do I need to do so he can access my files? My experience with Access is very limited.
Thank you in advance for your help.
Phil

View 3 Replies View Related

Opening PDF File From Access Is This Possible

Nov 24, 2005

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

View 3 Replies View Related

Importing Fixed Length File Into Access 2003

Sep 6, 2006

I want to import a fixed length file into access 2003, it can only be imported directly into access 97/2000. This site, link http://www.ams.usda.gov/science/pdp/03data.txt
has the idea, but the problem is I can find the "2003 Data zip file" which this
site is refering to. - I have looked for it on the ms office 2003 cd,but I still
can find it.
Please can someone tell me where I can find de "2003 Data zip file"?

View 3 Replies View Related

Opening An Excel File In Access 97

Aug 26, 2005

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?

View 1 Replies View Related

Problem Opening Access File

Apr 9, 2007

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

View 1 Replies View Related

Opening A MSword File From Access

Jan 27, 2005

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

View 6 Replies View Related

Txt File Field DDMMYYYY Fails To Import Into Access'07, But OK In 2003

Apr 1, 2008

Hi there anyone and everyone.

My problem concerns importing a date from a txt file. I've been doing this for years with '97 and 2003 with no problem, but with 2007 I am now getting import errors which I can't resolve. The files, either fixed width or delimited, contain date information in the format ddmmyyyy (without any date separators). After importing I receive an import error message, and the relevant field in the table is blank.

In Access '97 or 2003 I can import date information directly into an Access date/time field by using an import specification where I have set the date delimiter to blank (by default this is set to "/" , so I simply delete this to leave the box empty). Using this method a file containing "25122007" (without the inverted commas) will be imported into Access as a date, and can be subsequently manipulated as date without having to resort to any fancy reformatting tricks. Obviously the import will not be sucessful if the date delimiter in the import spec is left as "/", or set to anything else, eg "." or ":".

But now that I've updated to Access 2007 this is just not possible no matter what I do or try. I can only import a date if the txt data has a separator, and that the same separator is set in the import specification.


In some new databases I have done a couple of workarounds, importing it as text into a text field, then using a CDate(Format(CLng([date]),"00/00/0000")) type expression in a subsequent query, but this is a pain having to do it, a really backward step.

But the real pain is older databases ('97 or 2003) which have been converted up to '07; they no longer work, and there is a lot of redesign to be done unless somone can tell me what I'm doing wrong.

Unfortunately I am not able to change the format of the dates in the data I receive, so the solution has to come from my end (ie Access). Surely Access 2007 should be able to recognise 25122007 as a date? All ideas gratefully received.

I've been happily using various versions of Access since 1994 and I've learnt lots along the way, and have always previously been able to sort out problems that I've come across without resorting to a forum, but I'm now really puzzled by a problem that I have come across in Access 2007. So although this is my first post I certainly wouldn't call myself a newbie. Hopefully I have described the problem accurately (it is realy simple in fact), but very happy to provide more information if required.

Many thanks (in anticipation)

Benjy

View 13 Replies View Related

Got Warning Everytime Opening An Access File

Dec 3, 2006

Hi,

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?

Thank you in advance

View 2 Replies View Related

Opening An Mde File In A Newer Version Of Access

Apr 22, 2007

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?)

View 1 Replies View Related

Opening Doc File Through Microsoft Access Ribbons

Feb 17, 2012

Any module that would open a word document. Also, If that module could be linked to a ribbons menu item...

View 3 Replies View Related

Forms :: How To Open A Specific File Using Search Function In Access 2003

Dec 5, 2014

I have a access 2003 database, and i am wondering if i can't setup a search function in a form that will open a file in windows explorer?

What i would like to do is have a test box that i enter in a number for example: 1234 then have a button named "Search" hit that button and it opens a corresponding file in windows explorer named 1234, or just opens that folder directly..

View 14 Replies View Related

Modules & VBA :: Opening Excel File From Access Form

Sep 21, 2014

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?

View 1 Replies View Related

General :: Opening Access Database From Batch File Or VBS

Dec 20, 2012

Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed.

(The reason for this is so that the Database can refresh itself from Sharepoint on another users machine so that the excel reports on his machine are up to date).

View 3 Replies View Related

General :: Possible To Permanently Display File Path In Access 2003 Main Title Bar?

Nov 22, 2012

Is it possible to permanently display the file path in Access 2003 main title bar? I.e. whatever object is open the filepath is shown.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved