When Opening Access
Apr 27, 2005hi, when opening access how can i get a switch board or a form to automatically open up, instead of viewing the main acess windows
View Replies
ADVERTISEMENT
Opening An Access Program Without Opening Microsoft Access
Jun 11, 2007I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???
View 6 Replies View RelatedOpening Forms Directly (instead Of Opening MS ACCESS)
Apr 20, 2006Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Opening Forms Directly (instead Of Opening MS ACCESS First)
Apr 20, 2006Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Question: Opening Access Form Without Access Installed.
Mar 28, 2007Hi,
I have a database (.mdb file) which includes a table, forms and VB code. I intend on putting it onto a CD and then opening the form on another computer which may not have Access. Is this possible? Can I convert the file or can I attach some type of reader to the disk?
I have seen some software for download on the internet which allows you to open the tables however the Form is the most important thing in this case (but I take it whatever I use, it will need to be able to view the VB, subforms and tables as well since the Form depends on them?).
...also can I install an auto-run to the file for when the disk is inserted? (this is not a major issue though).
Thanks.
Opening PDF File From Access Is This Possible
Nov 24, 2005Hi 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
Opening One Access Database From The Other
Dec 28, 2005Hello everybody,
I have a question.
I have a button on a form.
When I press that button, another database should be opened.
I tried this:
Dim dbMyDB As Database
Dim rsMyRS As Recordset
Set dbMyDB = OpenDatabase("C:DocumentenJohnnyStyle_be.mdb")
Set rsMyRS = dbMyDB.OpenRecordset("nslArtikel", dbOpenDynaset)
But it didn't work.
Thank you very much in advance...
Maximise Access When Opening
Jun 4, 2006Hi - I have built a web page which holds links to Word,Excel & Access files.
I have the .doc & .xls files opening as I want but when I link to a DB file Access opens in a reduced (small)window. Is there a way to force the Access application to open maximised - before the DB file loads?
Any suggestions would be much appreciated.
Thanks
RussG
Access 2007 Not Opening
Mar 5, 2007Hi All,
I've been developing in Access 2002-2003, and now have Access 2007. I can open a 2002-3 .mdb database OK, but when I click on the Main Menu buttons, nothing happens -- they do not work. So I cannot access any of the existing Menus and Forms. In fact, none of the previously existing databases I tried will open/close Forms using the existing buttons. Any ideas?
Thanks for any suggestions.
331
Opening A Word Doc From Access
Mar 4, 2005i have a word doc that is built by code. at the end, after the doc is completely built, i save the doc and kill my word object. what i want to do is be able to launch the doc automatically for the user, but still be able to kill the code object used to create the doc. what i currently have, which obviously doesn't open the doc, is as follows:
Code:wrd.ActiveDocument.SaveAs sOutputDir & sHeader & ".doc"wrd.ActiveDocument.Closewrd.QuitSet wrd = Nothing
i can't figure out how to get word to open with my doc. i'm sure i'm overlooking something simple, but does anyone have ideas for me on this?
Opening MS Access Faster
Mar 10, 2008I revised my DB thinking that one big form divided by Page Tabs would speed things up. Wrong. It slowed everything down to a crawl. I found the more I broke up Forms into sub-forms the faster things went.
Incidentally this may be the answer to the problem I posted about Permission Lockups. (See Access 2000 Permission lockup posted on 2/20/08). I noticed that the big form version requested to save forms that I think I had not even opened. So when I encountered the problem on installing the DB on my network, I just did two or three saves just for luck. This seemed to do the trick. This suggested that my Permission Lockup may have been due to not all Forms had been saved on closing.
The evidence is circumstantial but I have had no trouble since.
Opening Access Forms
Mar 8, 2006Hello,
I work at a library and we often add books to the library. Each time we have to fill out a form and fax out multiple copies keep a copy. Today I made a database and form in access to do this, so it won't be done on paper anymore. It is actually the first thing I have ever used access for. I have 1 problem now, I need to make it as simple as possible for everyone using the form. I am trying to make it soyou can click on a shortcut from the desktop and open just the form without having to open access and then enter in the data. Is this possible? I have attempted to save as a different type, export as a different type and nothing works. Can someone give me a little expertise on this? Thanks.
Access Database Without Opening Access First
Jul 20, 2007I'm wondering if there is a way to open an access database (ive started with a microsoft template for an inventory management database) outside of the access environment. I'd like the program to run more like a .exe file rather than a database, but still having the links to and the functionality of the microsoft database
is this possible?
Opening An Excel File In Access 97
Aug 26, 2005I 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?
Opening Access To A Specific Report
Mar 21, 2006Is there any way to put a shortcut on someone's desktop that will open a specific report in an Access database? I'm thinking back to the days of DOS when one simply added an argument to the command. I don't want to put it in startup and have it always go to that report. I just want non-Access users to go right where they need to without menus, etc.
:confused:
Thank you.
Opening A Word Document Within Access
Sep 14, 2006I've used the Outputto method to archive reports creted in Access to Word in .rtf.
I now want to have an option to view these archives from Access. How?
Thanks,
Richard
How To Disable The Warning When Opening Access
Nov 14, 2006Hi,
i was wondering if anyone might be able to help me out here. I've been spending hours but to no avail. It seems to be a very trivial problem but i'm just out of luck.
I've been getting this pop-up message everytime i try to open up an access application such as .mdb files.
Open file - Security Warning
Do you want to open this file
...
two buttons: Open & Cancel
My question is if there is a way to turn it off or disable this warning from popping up when opening an access application.
Thank you in advance
Trouble Opening Access Files
Nov 27, 2006Hi,
I was wondering if i could get some help here. I think this is to do with the security issue. I usually double-click to open or run an access file (for example student.mdb) that sits on the server with no problem. But this time, nothing happen when i did double-clicked on it from my laptop while the file was being open by someone'else on another computer. I know that it makes sense that we shouldn't open a file that's being used by other users. But my curiosity is that should it not give you a warning like (you know) you're not able to save any changes or things like that. No, i didnot get any of that messages. It's just nothing happen after trying to open it by double-clicking it.
I have set the macro security to low level but that did not help either. Is there any thing that i need to tweak?
Thank you in advance
Opening Access 2007 Using Msado15.dll
Dec 1, 2006I have an appplication that reads information from Access Database, it uses ADO (msado15.dll) to open a database using Connection15::Open( ). I am unable to open Access 2007 database using this method. I get the following error: "Microsoft JET Database Engine, Unrecognized database format". Is there something I am doing wrong or I should be aware of? Does msado15.dll support Access 2007 databases? Thank you in advance.
View 1 Replies View RelatedMS Access Error At The Time Of Opening It
Dec 25, 2006I have created a database then saved it to my computer.
Now while I am trying to open MS ACCESS in my computer I am getting an error message -
"This file may not be safe if it contains that was intended to harm your computer.
Do you want to open this file or cancel the operation?"
Giving the options - 'CANCEL' 'OPEN' 'MORE INFO'
How can I by pass this dialog box?
Problem Opening Access Database Twice
Jan 8, 2007Hi There
Im probably being thick, but...
ive just upgraded our sales database from access 97 to access 2002. everything is fine apart from when i try to open the database twice on one machine - it wont allow this. In access 97 this was allowed and i normally had atleast 3 databases (all the same database) open at once.
is there an easy answer??
many Thanks
Neil
Problem Opening Access File
Apr 9, 2007Hi
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
Trouble Opening Access Db With Shortcuts
Aug 21, 2007Ok this is a weird issue that has been troubling me, On some computers that I have, Access refuses to open databases through a shortcut. The only way to open any databases is to first open access the go to file open.
I've tried creating new shortcuts, as well as mapping a drive and making a shortcut from there...but nothing is working. Is there a setting that access has to preven this? The same database can be opened on different computer without a hitch....
Opening Word Documents From Within Access
Feb 27, 2008As a basic user and relatively new user of Access, I have designed a database which holds the data for several word documents that I use for mailmerges. I want to be able from the "switchboard" link the word documents so that users can easily access the letter/form required and print them. Ive tried many things - just not working!!!! Time to shout for help!
View 1 Replies View RelatedOpening Other File Types From Within Access
Nov 16, 2004I 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
Opening A MSword File From Access
Jan 27, 2005I 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