Hi all, I have been given a database from a small business who just want some menial report editing. Their problem is the supplier of this simple access database has disappeared and in over a year of reporting the problem has not resolved it.
The database is locked interface-wise, i.er. if you load you cannot access tables, queries, reports etc. I was wanting to know how you do this. If the database is passworded I have a revealer, but actually getting to the edit area seems to be the problem at the moment.
How do you hide the canned record scrolling keys on the bottom of a Form? I have placed my own controls and do not need them to confuse the Operator, or cause problems.
I have this code that works. I have a form with 3 tabs. When I select the middle tab I am prompted for password but if I click the 3rd tab I am not.
Code: Private Sub TabCtl9_Change() Dim strInput As String Dim ctl As Control ' Hide controls on tab until correct password is entered For Each ctl In Controls
I am using Access 2010. I wish to show or hide controls based on the value in the combobox. The combobox is bound with the data type Yes/No. If Yes, controls should be visible and if no, they are to be invisible. The database is a linked one. This selection should update all the users' forms.
I've searched and can only find information setting the visible property when selections are made on an open form--I want to set the visible property when the form is opened depending on which avenue the user chooses from the navigation form.
I have a navigation form (Form A) and a second form with a subform (Form B). The user will choose from a combobox, either an existing record or a new record on Form A. On Form A there are two buttons, one that will take the user to the correct record on Form B for editing and one that will open to a new record on Form B. Once Form B is open, all controls will be blank (if a new record is chosen) or with certain controls prepopulated if an existing record is chosen.
What I want to do is to hide controls on the main form (not the subform) of Form B if the user chooses an existing record. Form A's buttons work correctly to open Form B right now. I want to be able to hide prepopulated controls on Form B if the user chooses an existing record from Form A.
Here's the code I'm using to open Form B to an existing record. I'd like to set the visible property here if at all possible.
NOTE: "Form A" and "Form B" are not the actual names of my forms--it's just easier for illustration purposes here in my question.
I have a checkbox that determines whether or not to display certain form controls. How can I also hide the resulting white space that comes from hiding the form controls?
Can I put all of the controls in some sort of container and hide the container? The form objects are all displayed in order, so it shouldn't cause issue.
Can I create a subform for the objects and hide it? This would make the main and subforms based off of the same table.
Occam's Razor would be the preferred philosophy in this case. Nothing too fancy is needed.
I have a subform which lists a set of records. In the footer section of the subform, I have a number of controls which display calculations based on the records present.
The number of records in the subform will change (reduce). Basically, this is a review / approval function, the idea being that each record will be checked and approved, which will then remove it from the list.
So eventually, all of the records in the subform should disappear (the subform is requeried each time the user approves a record)
I want to be able to hide the controls in the footer section once the subform has been cleared of all records.
But not sure
a) how to determine when the subform's recordset reaches zero and
b) what event to use to fire the code to hide the footer controls.
This is my basic attempt :
Code: Private Sub Form_Current()Dim ctl As Control For Each ctl In Me.FormFooter.Controls ctl.Visible = Not (Me.Recordset.EOF) Next ctl End Sub
But it doesn't work (it only seems to fire when the subform is loaded, not when it is requeried after each approval?)
I've tried Form_Query, Form_DataChange and Form_DataSetChange but no joy with those either.
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!
Please give all the info you can. I have my database and forms set up. what I want to do is just see my forms and not see access in the background. Please specify where I enter code if it's provided. thanks for all your help, Derek
I am looking for a book or poster or something that can show me all the access controls and what they do. My VB.NET version came with several posters. I have looked at many books but can not find one that enumerates and explains all of them. I would also like to get similar information for the Active X controls included with access. Thanks
I have two subForms on separate pages of a Tab Control on a main form. I want to create a Textbox on one Form to display the month of a Date field on another form, using DatePart.
Using the On Current event, this works ok, if I have the 'other' subForm open in its own right, but I get message telling me it can't be found if i don't. Here is what I have...
Private Sub Form_Current() If Not IsNull(Forms![Reviews]!SelectLessee) Then Dim revDate As Date revDate = Forms![subReviewPEST]!DateOfNextCreditReview Me.Text118.Value = DatePart("m", revDate) End If End Sub
What syntax do I need, or how then can I access the control without having the subForm open itself, by getting to the page on the tab control, then to the control on the subform...
I m trying to create a form with tab controls but it keeps on disappearing in the form view but showing up in design view. Even when I delete the tab control and drag existing fields onto a blank form it is still not showing up in form view but showing in design view.
I have several new employess on my facilites Access Database however their Monitor Displays are on differnet settings and the databse window is to large for their monitor, how do I set the database to open to their personel settings?
I'm trying to find out if its possible to add multiple pictures to 1 record.
For instance..
If I had a row containing information on a person
First Name, Last name, Address, Picture
Currently I have used the Image option in Design view in my form. But when I go to insert Object it only allows me to choose 1 picture for that particular person.
How can I change this to allow multiple images per person. I would also like to have a next and previous button to view multiple pictures for a particular person.
The below code will hide ALL menu bars and ALL tool bars. Ensure that you have a way to unhide the menu bars and tool bars before you hide them! You should place the hide all tool bars routine in your opening splash screen form for it only needs to be run once when the db is first opened.
This will hide all menu bars and tool bars Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i
This will unhide all menu bars and tool bars Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = True Next i
An added bonus is the right-click mouse button option is disabled if the menu bars are disabled with the above code.
Use the 'ShowToolbar' command if you need to display a tool bar or menu bar... DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarYes
This will hide a tool bar or menu bar when needed... DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarNo
This will hide the menu bar... DoCmd.ShowToolbar "Menu Bar", acToolbarNo
You can also hide/unhide the database window with code...
Hide the database window DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide
Unhide the database window DoCmd.SelectObject acTable, , True
Remove the "Type a question for help" on the default menu bar in Access 2002 or 2003 Application.CommandBars.DisableAskAQuestionDropdow n = True
This command will prevent the db from opening up a separate window tab on the Taskbar Application.SetOption "ShowWindowsinTaskbar", False
The above commands have been successfully tested with Access 97 and Access 2003.
Read this if you do not understand where to post your questions! >>> Please Read Before Posting (http://www.access-programmers.co.uk/forums/showthread.php?t=63576)
Please do not directly PM me with any questions related to my Hide all Access Toolbars and Menubars code. Please do not post any questions related to my Hide all Access Toolbars and Menubars code in the Code Repository forum. If you have a question related to the Hide all Access Toolbars and Menubars code... Please post your questions in the appropriate forum and include a link to this thread if you have a question or problem related to my Hide all Access Toolbars and Menubars code. I will be glad to help if I see your post and if I am available.
Key words: toolbars, tool bars, menubar, menu bars, hide, unhide, enable, disable, right click, right-click, database window, hide database window,
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):
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.
Hi All, I am learning heaps and constantly wrestling with access, this is a good thing. However at the moment i recently added tabs to my form to restructure the appearance and content and thus far i am happy and its working fine. Except that moving the mouse cursor accross the from causes controls and textboxes to flicker / refresh. I find this annoying and given all the effort going into the presentation of the application i have done. Is there anyway to eleviate this, is there something i have done wrong perhaps.
I wish to host various controls and inputs from other tables on the other tabs. Will this complicate things or should 1 form with its Tab controls be particular to 1 table........ or can / should a form serve as an input or display to several tables? Is this a bad database practice?
thanks for any assistance you may be able to provide.
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??
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.
I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. How to get rid of the default File tab or at least disable it?
I'm not entirely new to Access, but I don't have the formal training or experience to accomplish what I'm attempting. And, after hours of research, I haven't been able to find anything that quite works. I know it's do-able, I just can't figure it out. Any help is much appreciated. I'm using Access 97.
In a form (MasterBadgeForm), all fields require completion. However, I want to force the user to complete 2 fields before any of the others are visible.
The 1st 2 required fields are: - HostLastName: ComboBox (user's last name based on a simple query called HostMasterQuery) - Visitor_Guest: Bound option group frame with option buttons "Visitor" (option value = 1) and "Guest" (option value = 2).
Note: The logic behind using an option group frame (instead of check boxes, etc.) is to force the user to choose "Visitor" or "Guest", but not both or none.
After both fields ("HostLastName" and "Visitor_Guest") are completed, I want 2 things to happen:
First: Depending on the choice selected in the Visitor_Guest option group frame, I want respective combo boxes to either be visible/available, or not. For example, if the user selects the "Visitor" option button, I want to make visible a combo box named VBadgesCombo (based on a simple query that has pre-defined "Visitor" numbers) and "hide" the combo box named GBadgesCombo. The same concept applies if the user selects the "Guest" option button.
Second: I want all the other required fields to become visible.
I've done a ton of research, but I just can't quite figure it out. Any help is much appreciated.
I want to hide the top toolbars when my users open my database in Access 2007! i have an autoexec macro to maximise the window which gets rid of the navigation bar on the side but cant work out how to hide the top bar? do i need to write code? if so what code and where would i input it.. any help would be much appreciated...
I have developed .net application ....at back end I am using ms access database. When I deploy my application at client end , I want only my ms access database should accessible to application only. Client should not be even to see which type of database i am using or its business logic .