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