Open Database Without Opening Full Program

Feb 18, 2008

Im trying to open my database switchboard without having the whole Access program open. Is there a way to have only the database open without the whole program?

View Replies


Forms :: Form To Open Only When Opening Database

Nov 19, 2013

I've made my database, now I can remember in older access I could make it so when I click the database you would only see the form and not access its self. Is it still possible to do this in access 2010.

View 1 Replies View Related

Opening Popup Form Is Full Screen

May 17, 2006

I must be missing something simple here.

The opening switchboard of my db is set to popup but on opening the db it is showing full screen. On reopening once closed it pops up. How can I make it popup to start with?

Settings are:
Default View - Single Form
Auto Centre - Yes
Auto Resize - No
Border Style - Dialog

View 8 Replies View Related

Reports :: Opening Report In Full Window Mode?

Jan 14, 2014

i have a button opening forms however when they open they appear in window mode and not full screen. is there an option or a line of code of code i am over looking to make it open in full screen mode?

ps. i am using access 2010

View 4 Replies View Related

Opening A Form From The Program Start Menu

Jun 10, 2006


I would like to be able to open a customer form without starting MS Access.

Is there a way to make a form an executable module?


View 2 Replies View Related

Form Opening In Full Screen Mode Instead Of Size Set In Design?

Aug 9, 2012

I just imported all of my objects (tables, forms, etc.) into a brand new database file and all of my forms are now full screen instead of the size I set them to in design. What caused this? I can't get them back to their normal size.

I am using Access 2007 but imported files into 2003 .mdb file.

Form View

Design View

How it should look?

View 1 Replies View Related

Opening An Access Program Without Opening Microsoft Access

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

How To Get A Form To Open In Full Screen Again

Dec 7, 2014

I had the Main Menu open when clicked on access file. I put a autoexc.bat file somewhere. Where? Also how do I get a form to open in full screen again?

View 3 Replies View Related

Only Show Form Application When Open A Program

Aug 17, 2006


I once used a program, when you click this .mdb file, it opens a main Form interface that user can run programs such as view report etc. That is, all tables, querys reports, other forms are behind the sence (user does not need to know them).

Could anyone tell me how to do this? Thank you for yoru help.

View 2 Replies View Related

How To Open Access 2007 From Visual Basic Program

Nov 22, 2014

I have a fully operational Visual Basic program that uses MS Office XP and it's related MS Access. Because of security concerns, I recently upgraded to MS Office 2007 and MS Access 2007. I can open MS Access 2007 using the shortcut on the desktop and run any of the database queries. When I try to run the Visual Basic program (called prjPathfinder) and open Access 2007, it says "Error 5: The type initializer for prjPathfinder.Upgrade Support threw an exception". It then shows the first form in prjPathfinder but does not open Access 2007. What am I missing?

View 3 Replies View Related

Unable To Open Excel And Prompt To Select Program

Jan 8, 2015

I am attempting to create a Macro that will export the COMPLAINT table to an Excel Spreadsheet. However Excel does not open and I am prompted to select the Program I want to use. What am I doing wrong?

View 1 Replies View Related

Forms :: Open Form To Show Full Details When Double Click On Subform

Jun 16, 2015

I have a subform 2SiteList (Datasheet View) with the field SiteName... i also have another form SiteDetails.

if possible i would like to be able to double click on a SiteName on the subform and have the SiteDetails form to open to show the full details.

View 1 Replies View Related

Having A List Of Record Names Displayed And Opening The Full Record Via Click

Sep 13, 2005

Im not sure if this is the right place to put this but I was wondering if you could help me:

Say I have database with forms that display records or people ie name, address, postcode, etc. What I want to do is display a list of Names then from that list I can double, single click and open the record details.

Id call my self and amatuer at access and am probably guessing this is done via vscript or something else, but any help will do.


View 14 Replies View Related

General :: Creating A Database Full Of Contacts

Jan 2, 2014

I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list.

View 1 Replies View Related

Connect Program To Database Backend

Jun 16, 2005

Hey guys... I created a reaaaally simple wages calculation program some time ago in VB6. When you click the save button, the records are saved to a .txt file stored in the same directoy as the program itself.

However, I'd like to take this a step further and connect this program with some tables setup in an Access database. I know this has something to do with ADO, right? But not quite sure how to set this up..

Would it be possible to get some guidance on this? If you'd like to see the program, let me know.

Thanks for any input!

View 11 Replies View Related

Email Program And Access Database

Jun 27, 2005

Can anyone suggest a good program that will handle scheduled emails to people in our Access database? I need to send an email automatically to each of our employees on their birthday. I need the program for much more than that but that is what I am working on at this time.

Thank you!


View 4 Replies View Related

How To Get Full Permission:Add, Delete, Update, Edit In The SQL Server Database

Jul 26, 2007

I wrote the following statements to update a SQL server database:

Dim MyDb As Database
Dim MyRs As Recordset

Set MyDb = DBEngine.Workspaces(0).OpenDatabase("AMD", dbDriverPrompt, False, "ODBC;DATABASE=AMD;DSN=Remote")

Set MyRs = MyDb.OpenRecordset("SELECT AllAttendanceEvents.* FROM AllAttendanceEvents ORDER BY AllAttendanceEvents.EntryTime DESC")


While Not MyRs.EOF
MyVal = MyRs!EntryTime
Debug.Print MyVal
MyRs!Ix = 50099

When it execute the red line statement, it generates the error:Cannot update. Database or object is read-only.

This error is generated isnpite that I already checked the boxes: SELECT, INSERT, UPDATE, DELETE in the Permissions page of the tables?

Please advise.

View 3 Replies View Related

Forms Count Of Other Database Without Opening That Database Physically

Oct 7, 2005

Hello All...

Well, I am facing one my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..

Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject

Set frm1 = AcProj.AllForms

intCount = frm1.Count

But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..

Thanks in advance..!!

View 4 Replies View Related

Modules & VBA :: Get Open Args To Work While Opening A New Form

Jun 25, 2013

I have tried a few times to get open args to work while opening a new form.I never could get it to work.

View 4 Replies View Related

Forms :: Opening Form Directly When Open ACCDB

Dec 19, 2014

I am trying to make my form open directly when i open my access file.accdb. When i double click on my .accdb can it be done to open directly and only my form. I found a way to open my form but it opens the access program in the background.

View 7 Replies View Related

Database Not Opening

Sep 27, 2005


I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.

I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.

It's getting frustrating because I've been trying to get this working for 3 hours now with no success.

View 5 Replies View Related

Opening A Database?

Aug 9, 2006

Here's a little problem I have and wondered if anyone knows a way around it.

I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.

We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.

So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far

Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.

SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.

FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.

Are there any other ways to open a database from within access RT version that will open the access application full screen?

View 5 Replies View Related

.MDE Database Not Opening

Dec 15, 2004

A ex-coworker created a .mde database, but didn't save the .mdb version. The .mde version has been working fine, but today it closed when the end-users tried to open it. It looks like it tried to open the start up form, but it closed. I was able to get into the database and launch the second form, but the start-up is the issue. What could cause the start-up form to keep the database from opening?


View 2 Replies View Related

Modules & VBA :: Open Database / Run A Query / Close Database

Aug 22, 2014

i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.

View 4 Replies View Related

Database Stuck On Opening

Jul 16, 2005

The problem: I have my database set to open a form on start-up. On opening that form I put in a command for a message box. When I click OK on the message box it tries to open the form again which leads to the same message box. I need to somehow get to the design view on start-up. Any help would be appreciated. Thanks Bob

View 1 Replies View Related

Opening One Access Database From The Other

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

Copyrights 2005-15, All rights reserved