Display Form Without MS Access In Background?

Mar 6, 2006

I was wondering if this was possible. I did a search on Google and on this form and I could not find anything. Is it possible to display a form without displaying Microsoft access in the background? In other words I would like to display just the form alone with access running or if possible a way to have access minimized with the form still showing. If anyone knows any tricks on this could be performed I would be very grateful.

Thanks, Chad :)

View Replies


ADVERTISEMENT

General :: Only Open MS Access Form Without Access Running In Background?

Aug 7, 2013

I have made a form on access which will be used by other employees within the company, however they have never used access before and they are wanting to access only just the form as I feel with Access and all the tools in the background will confuse them, plus I don't want them editing the data base its self.

Is there a way to only bring up the form, unless I obviously need to edit the date base.

I've done some research on Google and it seems I need to use:

SW_SHOWMINNOACTIVE

However I can not seem to find how I would use this or where?

and also if i did find a way to only bring up the form, how would I be able to switch it from that veiw to the veiw I edit in?

View 2 Replies View Related

Modules & VBA :: Display Background Image Via Message Box

Mar 17, 2015

I have a report which is an invoice I have a button on the report to reprint It . Now if this is a duplicate Invoice I need to add a background Image ,something like a duplicate stamp . I have added a message box which says" is this a Duplicate Invoice" .If the answer is yes then I want to display the backgrond image and print the report .If the answer is no, then print report without background image

View 2 Replies View Related

Forms :: Form Opening Inside Access Window In Background

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

Call / Display Image Or Text On Demand As Background To Specific Record

Nov 14, 2014

I have a lost/found property database form (soft-copy), it works perfectly fine. We enter the details of the found property and then take the print (hard-copy) of the form. Whenever an owner comes to claim his/her item we search through our soft-copy for the specific item/record and then ask them to sign on the relevant hard-copy record after which we cross out the hard-copy and write with a permanent marker "Restored". Whereas in the soft-copy we type in the details that it has been claimed/restored in available text fields. However, is there anyway that I can display a big large banner saying "restored" in front of only that record(s) where item(s) has been restored to the owner. It doesn't have to be a text banner/label, it could also be a picture saying "Restored". I have manage to get a print message box set-up for this but it's too annoying. Every time we pull out an item's record that has been restored, that message box comes up and then we have to click OK to proceed. I can remove it but only if can find a replacement.

View 2 Replies View Related

Access Background

Dec 20, 2005

I would like to change the color of the actual access database background. I've done my forum searching and found many many threads explaining how to do this but i cant open any of the sample DB's. Access says the file is readonly and you need to be able to edit upon the first opening or something to that affect. I assume its becuse the sample is a newer or older access than im running(XP)

Sorry to rehash old threads but i cant get the info from them.
Can anyone help..Grey sucks ha

thanks

View 7 Replies View Related

Add Walpaper To Background Of Access

Jun 8, 2005

I was wondering if it would be posible to add a wallpaper to the background of the MS access program.

I am ussing Access 97

View 3 Replies View Related

Hiding The Access Background Window

Mar 20, 2006

Hi,

Ok i am using the following code to hide the access window but when i do it, it also hides it from the taskbar aswell.

Is there any modifications to the code that will hide the background window but also keep it on the taskbar.

thanks
k0r54

Module: -

Option Compare Database

Private Declare Function IsWindowVisible Lib "user32" (ByVal hWnd As Long) As Long
Dim dwReturn As Long

Const SW_HIDE = 0
Const SW_SHOWNORMAL = 1
Const SW_SHOWMINIMIZED = 2
Const SW_SHOWMAXIMIZED = 3

Private Declare Function ShowWindow Lib "user32" (ByVal hWnd As Long, _
ByVal nCmdShow As Long) As Long

Public Function fAccessWindow(Optional Procedure As String, Optional SwitchStatus As Boolean, Optional StatusCheck As Boolean) As Boolean

If Procedure = "Hide" Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
End If
If Procedure = "Show" Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
End If
If Procedure = "Minimize" Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMINIMIZED)
End If
If SwitchStatus = True Then
If IsWindowVisible(hWndAccessApp) = 1 Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
Else
dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
End If
End If

If StatusCheck = True Then
If IsWindowVisible(hWndAccessApp) = 0 Then
fAccessWindow = False
End If
If IsWindowVisible(hWndAccessApp) = 1 Then
fAccessWindow = True
End If
End If
End Function


To call it: -

HideForm = fAccessWindow("Hide", False, False)

View 14 Replies View Related

Hide Access Background Window

Jan 31, 2013

I am using Access 2010 and trying to hide the background access window, so that only my forms are visible to the end users.

After researching, I found these VBA codes, but I always get an error. I have changed all my forms & reports to Pop-up and Modal. This is the code that I use on OnLoad of the Main (first form):

Private Sub Form_Load()
Const SW_HIDE = 0
Const SW_SHOWNORMAL = 1
Const SW_SHOWMINIMIZED = 2
Const SW_SHOWMAXIMIZED = 3

[Code] ....

When I open my the database- the mian window is still there and I get an error

"The espression On Load you entered as the even property setting produced the following error: Only comments may appear after End Sub, End Function or End Property.

*The expression may not result in the name of a macro, the name of a user-defined function, or [Even Procedure].
*There may have been an error evaluating the function, event or macro.

Do I have to change any thing in File-> Options?

View 3 Replies View Related

Reports :: How To Display Access Form In Excel Form

Dec 13, 2013

I have created a MS access form having a combobox,button.There I have coded like : When the user click on button,a report will be generated. I need to show the access form in the excel form.I have searched and got code,which only allows me to open the ms access not the form.

View 8 Replies View Related

General :: Change Access Background Color

Aug 18, 2014

I'm using the changebackgroundcolor.zip sample that I found here at Lebans site. URL....I'm trying to find a way to keep the color that I picked after the database closes. I tried to follow the example here URL....but couldn't get it to work.how to get the color to stay on the color that was picked from the dialog box?

View 1 Replies View Related

Form Background

Aug 3, 2005

HI

How can I use/set an image (picture) as a background in a form? I can't seem to find this option...

thank you

regards, Miha

View 6 Replies View Related

Background Of A Form

Jul 6, 2006

pls Help,
I knw how to change the background of a form. but i need a particular file for the background. and i want to knw where the file is stored?
the file which i want is a texture file in a WORD. i.e. in word when we try to set the background of a page, the option Background gives us some textures for the background. i want a file called "water droplets" as a back ground in access form.
from where can i get the texture file?
i searched the whole Microsoft Office folder in c:program files. this file is not there. then where are this texture files stored? can anybody help me to find this file pls?

View 6 Replies View Related

Form Background

Nov 23, 2006

I have a master form with a picture as the background with a timer event that fires every 5 minutes. I have a subform (a clock) with a timer event every second to update the text. How do I make the sub form background transparent so that I see the master form back ground?

I did it this way so I didnt have to update the master form data every second.


help would be much appreciated.

regards

View 3 Replies View Related

General :: Can Display A Form But Hide Access

Jul 5, 2012

I recall using a database (created by someone else that I don't have contact with) whereby, when you open it, the user-end form opens up on your Windows desktop, but the usual MS Access window is minised/hidden.

View 6 Replies View Related

Access Pops Up Briefly Before Display Form

May 5, 2013

I have a simple time card database and set my Display Form properly and it pops up and works great. However, just before it appears, what looks like the main Access application appears for maybe 1/10th of a second, then disappears.

View 3 Replies View Related

Access 2013 Display Of Form View

Nov 6, 2013

My forms work well, but in form view are widely separated from the user tool bar. That is, the form is in the upper top left corner of the screen and the tool bar for choosing records is in the left hand corner at the bottom of the screen. I cannot get the tool bar in a position near the bottom of the form where it would be easier to work with.

View 9 Replies View Related

MS Access 2013 Application Background Image Or Splash Screen

Aug 8, 2014

All access application is realized as MDI container. (if I'm right)

In this case it is possible to set the MDI object background image instead develop splash screen. This picture always in background form open another forms or reports, does not depend on the screen resolution, etc, etc ... Splash screen must be removed in order to realize the other forms or reports.

How to set Access 2013 application backgroundimage, and backgroundImageLayout?

View 1 Replies View Related

PDF File Content Display On Access 2013 Form

Feb 7, 2014

I have an table with attachment field in which PDF files are attached.I need Access 2013 form to display PDF file content instead of PDF icon .While record changed should display PDF content for each record navigated

View 7 Replies View Related

Changing Background Color Of Tab Form

Apr 5, 2005

Hi,

I have design a form using the tab control. I need to add in color to make it more professional. Is there a way I can do it. I realised the filled /Back color icon is faded in color in design view.

Appreciate any help in this. Thanks.

View 2 Replies View Related

Conditional Format - Form Background

Mar 24, 2006

Could some kind person out there help me out please?
I have been 'dabbling in' the area of "conditional formatting", particularly in the area of changing the colour of my active form based on the result of whats input on a text box. I have had some success in this area but where I am getting confused is getting the colour of my form to change on the basis of what is entered into a text box control that does not match exactly. My form background changes to the required colour when its value is 'set exactly' or matches, but what I am trying to achieve is to change it according to the first letter of entry regardless of what follows thereafter? It always starts with a letter, either a ‘D’ or ‘V’ to indicate whether its ‘Vital’ or ‘Desirable’ and is subsequently followed by no more than 6 numbers and finally a letter. Basically I need my form to change colour based on the whether it is either a ‘V’ or a ‘D’ irrespective of what follows???

What I have been using so far is:

Private Sub Model_Number_AfterUpdate()
If Me.Part_Number = "V111145K" Then
Me.Section(acDetail).BackColor = 12632256 'Light Red
Else
Me.Section(acDetail).BackColor = 8421631 'Blah Gray
End If
End Sub

.................................................. .................................................

Private Sub Form_Current()
If Me.Part_Number = "V111145K" Then
Me.Section(acDetail).BackColor = 12632256 'Light Red
Else
Me.Section(acDetail).BackColor = 8421631 'Blah Gray
End If
End Sub


Your help would be gratefully appreciated:confused:

Thanks Very Much


Carol

View 1 Replies View Related

VBA Code To Change The Background Of A Form?

Jul 24, 2006

what's it?
I want to open the same form with different buttons (cos different criteria are attached to those buttons).
When i click i want the background to change based on the button.

So im asking for just one line of code: What's the vba to change background property of a form dynamically. cna't seem to find it :o

View 1 Replies View Related

Forms :: Access 2003 / Do Not Display Form Until Fully Loaded

Sep 23, 2013

Access 2003

I have a rather complex form with an ODBC connection to data that takes some time to load.

The Form has a continuous subform I am using in place of a listbox to select records (I need more functionality than a listbox)

The Form's Record Source is a query

When the form opens, I does so in pieces as it populates

I'd like to either keep the form hidden until it completely loads

View 1 Replies View Related

On Click Change Form Background Color?

Apr 30, 2006

I searched around but i couldnt really find or atleast understand how to do what i want to do. I want upon the user clicking on a checkbox for the background of the form to change to a set color?

View 8 Replies View Related

Forms :: Multiple Monitors - Different Form Display On Each Monitor From Single Access DB

Apr 25, 2013

I have built a few Access DBs and am looking to improve my development skills and attemt to migrate my Access DB to SQL Azure. I find access to be a very powerful development environment to build rapid applications . How to use multiple monitors so that I can display different forms on each monitor from a single Access DB.

View 1 Replies View Related

Forms :: Display Field List For The Table Associated With Form - Access 2010

May 21, 2013

I am new to Access 2010. When working with a form, how do I display the field list? The list of fields for the table associated with that form.

View 1 Replies View Related







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