Hello,
I woul like to programatically (with VBA code) hide and unhide the database window.
In Access 97, this can be done with Tools > Startup > Display database window box (check/uncheck).
But I would like my program does that himself : when the user launches the application, the database window should be hidden and when he leaves, the database window should be shown again.
Thanks.
Dear Friends I made my a stupid mistake and I don't know how to rectify it.
There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is
a) Display Startup form
b) Display status bar
c) Allow Full menus(Changed with Custome Menu)
d) Allow Default shortcut keys
e) and foolish thing cleared Use special key also
I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....
I need to find a way to not allow users to access the backend by using the database window. Is there a way I can password protect this?
Thanks
I am looking to minimize the access window when my database is opened. I already set it to do that from the startup menu, but all that did was open my specified form on open. I want it to actually only show my form w/ acces on the startup tray. Any suggestions?
View 14 Replies View RelatedI have a database and I need it so once the database file is launched the Database window & tool bars are hidden so people cannot see them. Along with that once the operator clicks on "Exit" on the main menu I would want it to close the database but display all of the Windows / Tool Bars again.
View 4 Replies View RelatedI have a Access database that is used as the user interface for general users but the data is stored in SQL. My client has asked that general users be able to see only selected fields in the table. This means that they must only use the form to view records and not be able to get to the table.
How do I disable the the Window Unhide in the MDE?
I created an app., for tracking changes, where once the user is logged in , the login form is hidden.
When a user modify the status of a change, i cretaed an event procedure in the update before. In that event procedure i am opening a new form to ask to continue or not and then i hide it. When the program comes back to the form where the event procedure is, it closes the hidden form, which asked to continue or not. The problem is that it closes the login form as well.
To sum up:
-Login form is hidden
- Edit form calls Confirm form
- when user comfirm, teh comfirm form is hidden.
- Edit form, close Comfirm form and also login form. (i dont want to close login).
Here is the code to close comfirm form in edit form....
DoCmd.Close acForm, "comfirm"
thank you, max.
I did hide the menu bar,
Tools->customize....
but how can I unhide the menu bar, because hide/unhide option is on the menu bar. If I hide it, then I cannot unhide it.
This is complicated!
I need to be able to have user run 5 different queries,
I think, and have the results from those queries show
up one under the other on one form footer.
Ex. fld 1 fld 2 fld 3 Date Range
fld 1 fld 2 fld 3 Date Range
fld 1 fld 2 fld 3 Date Range
Each of the rows would be based on a different query.
Also,
part of the query has a date range, and I would like
to have the Date Range from query show up next
to each row.
Thanks
I would like to hide/unhide the navigation pane completely by using two buttons (pop the hood & close the hood) in a form. At this moment I used the following code:
Private Sub Command77_Click()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub
Private Sub Command78_Click()
DoCmd.SelectObject acTable, , True
End Sub
This however makes my form shut down and not my navigation pane.
hi guys,
easy question.
when the DB is open a login form comes up. The issue is that the properties window for that form comes too.
any suggestion? thx max.
Yes...I am a newbie. In an attempt to secure my database, I accidently hid my entire datebase from everyone, including myself. How do I "unhide" it if I can't see it? I know that there is a really simply answer to this problem but I haven't found it yet. Please HELP!
View 6 Replies View RelatedIn Access, Tools->Start... I uncheck the "Show Database Window" checkbox to hide the database window when the database opens.
When I enter an icon to be used for the program, the hide DB window utility cease to work on Windows 2000, but not on Windows XP, e.g. the DB window is shown when opening the database on a Window 2000 system.
Any suggestions on how to solve this?
How can I hide the objects window on startup. I did it before witha command, but I cant remember how!
View 1 Replies View RelatedI 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?
All,
I've been using Dev Avish's excellent code shown within the sample database section to hide access windows. I've taken his call fsetAccessWindow function and set it to 1 or normal in two separate databases. Both databases seem to work slightly differently. The idea is that opening the database produces one Visible instance of access on the taskbar which is the purple standard graphic (Access 2000 / Windows 2000). With the first database I have set up reports through the active x control as required when using dev's code and even when I hit the report button the user is only aware of one visible instance of access as the purple colour graphic.
I am trying to implement the same code in a second database and have copied the code from the previous database into this database. It works great for the forms however there is a slight glitch when report forms are accessed. Rather than remaining with the purple access part on the task bar the task bar section is split into two between the form and the report. In the previous database users would not notice that the report had been opened at all. (although technically it was still running in the backrground)
I have checked most of the properties between the two database forms and they would appear to be the same..
Has anyone got any ideas why the taskbar is behaving differently between these two databases there must be some difference between my set up but as yet cannot find it??
Thanks Mark
Hello,
I have hidden most of the menu bars for my database (from the tools.. startup.. menu) and I dont have a backup of my latest database (yes, I know, stupid.) The only menus I have are File, Edit, Insert, Records, Window and Help. The database window is also not displayed.
How do I get them back..? My database is set to load a form on startup, all data is accessed via a set of forms linked from the first. I cant access the tables, design view, anything.
Help!!
I need to disable or hide the restore, minimize and close window buttons found in the top right hand corner of a form.
I navigation buttons that controls open, close etc already set up.
Good Afternoon,
Could some kind person please point me in the right direction as to how to
stop the 'VB code' window appearing and remaining on my task bar when I initially open up my DB. When I look at whats in the window there seems nothing untoward, but I would simply like to get rid of it as it is annoying??
Other sample db's that I open up on a regular basis are fine, so I was just wondering what could be causing it and how I could avoid it re-appearing..
Hope you can help....
Kind Regards
CarolW
I want the write a code that can be when run shows the Color Selection Window. For example I want the user to select the color of one object in the form by clicking on a button. Then I can store the selected color into variable.
http://cops.msc.tamu.edu/graphics/cset.jpg
Please Help me as soon as possible.
HIGLY APPRECIATIVE,
Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!
So I do map drive on this way and it is successful ...
Code:
Dim FSO As Object
Dim objFile As Object
Dim objFileS As Object
Dim WshNet As Object
persistent = false
set objNetwork = CreateObject("WScript.Network")
objNetwork.MapNetworkDrive "driveletter:", "serversharename", persistent, "username", "password"
But I need to have mapped drive hidden from the client users So I red that i might be possible if put $ after the share folder
Code:
objNetwork.MapNetworkDrive "driveletter:", "serversharename$", persistent, "username", "password
"
but it does not work.. the other way is to set values in win registry, but I don't like that way...
I have a report that displays maybe about 4 columns that read data and if a columns reads zero then I have a code where it will hide, but my problem is that I cannot get the columns to move over once the column that is zero is invisible.VBA code that will hide a column that has zeros and move over the remaining columns so that when the report is ran it will not show just an empty white space.
View 10 Replies View Relatedhi
ive been disabling the database window from the startup tab in MS access, just now when ive tryed to show it on startup it appears but its stuck in the top left hand corner and i cant move it! so i cant access the tables
help any1 pleassse
I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window simple moves up so I can't grab it and move it. Any suggestions?
scratch
This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas? Also, is there another way to view my objects in ACC07 because this way is slowing me down tremendously! It's much more difficult to find the objects I'm trying to work on and visually see where I left off. Any help would greatly be appreciated! Thanks in advance.
View 6 Replies View Related