Question: Opening Access Form Without Access Installed.
Mar 28, 2007
Hi,
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.
View Replies
ADVERTISEMENT
Feb 17, 2008
Ok, I know change isn't always easy, I remember going to 2003 and I didn't think I'd stick with it.
I'm now using 2007 and it's quite different in it's layout. I'm having trouble finding many things that I'm used to having "at my fingertips" but I'm muddling through it. The one thing that I'm totally lost on, has to do with form display.
Have a simple DB that a main form opens on start up. It's relatively small, auto centered, no resize and set to dialog. However, in 2007 it opens up occupying all available workspace space and I have to click the "Size to fit form" button. Then it's not centered.
Where the heck is the flag or setting to tell it to stop doing this?
Secondly, what's everyone else's thoughts on 2007?
View 5 Replies
View Related
Oct 2, 2006
I am building a database for users to input escalations in. The users that are actually keying the information in, do not have MS office. When they try to access the DAP html file, a message appears at the top of the page that states "The page requires the Microsoft Office Web Components.
See the Microsoft Office Web site for more information."
Can data access pages be used without office being installed? I have heard that it could also be the users internet explorer security settings.
Any help would be greatly appreciated.
View 3 Replies
View Related
Nov 22, 2013
We have an access database stored in a shared location. One of the tables in the database is used to record transactions made in an excel spreadsheet-this is done programatically using VBA and SQL.
So here is my silly question; If users don't have access installed locally will the code be able to write to the shared access database?
View 4 Replies
View Related
Sep 24, 2013
do I need to have MS Access installed, in order to open an ACCDE file.there is no need, as I see ACCDE as an exe file.
View 2 Replies
View Related
Nov 5, 2007
if let say i create a page that have database (*.mdb file) and for my client side, the PC don't have Microsoft Access, can they view the page that have *mdb file?
View 3 Replies
View Related
Mar 24, 2014
My new and previous laptops are both 64 bit and installed MA 2010 on both of the computers running win 8.
When I run reports on my new laptop the reports are not formatting. They are reflecting on 4 pages and not on 1 page like on my previous laptop running the same programs.
On my new laptop I installed Office 2013 and old one office 2010 but I used the same Access 2010 on both laptops which is a separate disk as office was not the professional one.
View 3 Replies
View Related
Jun 11, 2007
I 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 Related
Mar 12, 2006
Is there an easy way to open a powerpoint presentation from an Access form? Have seen the coding solution on msdn but was hoping there was a simpler way.
Thanks:)
View 1 Replies
View Related
Mar 14, 2013
I am using Access 2010 - Version 14.0.61.29.5000 (32-bit)
I am building a custom Export Wizard to export data to Excel using the Report Wizard for the basic ideas.
All I am trying to do is have a [Back] button on a form to open another form and close the current form.
Private Sub cmdBack_Click()
DoCmd.OpenForm "frm_ExportWizardPage2", , , , , , Nz(Me.OpenArgs)
DoCmd.Close acForm, "frm_ExportWizardPage3"
End Sub
The new form is opening but then the current form is not closing. All forms are the same size, shape and positioned centrally although this should not make any difference.
Could this be anything to do with which form has the focus when I open the new form?
View 2 Replies
View Related
Feb 15, 2005
How is it possible to open a form letter word docment from an Access form in which information on the form (such as name and address) is used in the letter?
View 3 Replies
View Related
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
Dec 4, 2013
My Acess2000 database holds records of members of an organization which I manage. I've got a button on my most-used form, called 'local members and helpfulness', which opens a report designed to print one envelope, using address data from the current member record showing in the form. I did this by configuring the button execute a macro. The button's 'On click' event is set to the macro name: 'mcrPrintC5env':
It works fine; the report shows up in preview mode so that I can click 'print' to print off that single addressed envelope. However, if I put an identical button on another form which uses the same data from the same "local members list" table (via a different query), it doesn't work. When I click the button in form view, a popup input box appears.
View 14 Replies
View Related
Apr 8, 2015
I have three forms:
Form_A (main form for the application - should always be open)
Form_B (always open, but sometimes has visibility set to false)
Form_C (opens from button on Form_B)
When I press the button on Form_B, the only code behind it is DoCmd.OpenForm "Form_C". This seems to hide Form_B, and open Form_C behind Form_A (which is the main form of the application) inside of an Access window.
I would like Form_C to open in front of Form_B. I suspect that I set up the form incorrectly or something when I created it, and it is therefore opening inside an Access window.
View 1 Replies
View Related
Dec 9, 2013
I am opening a new mail message in outlook using a button in a form.I want to change the "from" email address to a specific inbox (NOT personal email). Even though the email address is switched, after I hit sent and check my sent items - the email is actually sent from my personal email address and not from the inbox email address i wanted it to be sent from. I have access/permission to sent emails from the other inbox.
Is there a way to make sure emails are sent from specific email addresses and not ONLY personal inbox.What I read online is probably because of some "network" connection issues. Is there a way refresh connection between access and outlook? I am not even sure what the problem is.
View 1 Replies
View Related
Apr 20, 2006
Hi 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
View 1 Replies
View Related
Apr 20, 2006
Hi 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
View 6 Replies
View Related
Jul 20, 2007
I'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?
View 2 Replies
View Related
Jun 17, 2013
I have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for users with limited access.
Is this even possible to accomplish?
View 2 Replies
View Related
Apr 27, 2005
hi, 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 1 Replies
View Related
Aug 3, 2005
Can this be done? I would like to create a database with links to 10 or so other databases. It doesn't look like this can be done with the switchboard, so I tried a command button and I get an error? has anyone done this? I'm mearly trying to organize an interface for users to many databases.
View 1 Replies
View Related
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
Dec 28, 2005
Hello 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...
View 3 Replies
View Related
Jun 4, 2006
Hi - 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
View 3 Replies
View Related
Mar 5, 2007
Hi 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
View 6 Replies
View Related
Mar 4, 2005
i 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?
View 1 Replies
View Related
