Hi,
I want to hide a sub-form borders, so when I run it it just shows what's inside it e.g. textboxes, labels....etc
I fiddled around with the properties, but no luck.
Any help will be very much appreciated.
B
move a form without borders but not for microsoft access it's for visual basic microsoft access 2013
View 3 Replies View RelatedI generate reports of various lengths and would like them to be outlined by a solid border (both vertically and horizontally). So far I have drawn lines of fixed length but I really need a border that will grow and shrink with the length of my report. Any ideas?
Thanks
Is there a way to delete the borders from a form? You know the ones from the bottom and right hand side which have the buttons on for you to skip between records?
Also the one on the left which has the arrow in the top corner.
1. I want to put borders like in excel to my reports in access.
2. I want to calculate gratuity like this: nil for completing less than 1year service, 7 days for service between 1 to 3 years, 14 days for service between 3 to 5 years, 21 days for completing 5 years and 30 days for service exceeding 5 years. The calculations to be made on basic salary and the no. Of days in a month to be taken as 30 days. Can you send me with an example how to do it in a query.
I have several reports that include subreports in them, each one has a bold border surrounding it. When viewing the reports in Access, the spacing and layout is great.
But when I print the reports--either physically or to PDF--the text within the subreports somehow shifts left and up. Some of the subreports--by virtue of chance--happen to have enough extra space, but others don't and part of the text gets clipped by the border.
I'm not exactly motivated to go through the reports and readjust the layout for each one but if there's a database setting that I can change to correct it that would be nice.
I've attached a screenshot (where the layout is perfect) and a printed PDF (where the text is clipped) of one of the reports. The issue can best be seen in the Public/Private ZooMobile and Indoor/Outdoor ZooMobile subreports.
how to hide the the 'Details' section in my form when viewing it in Split Form. I tried to use
Code:
Private Sub Form_Load()
Me.Detail.Visible = False
End Sub
but that just makes the Details section look blank, as oppose to not having it there at all.
have only the Form Header and Datasheet visible in the Form View of my form. Similar to the 'Contact List' form in the Contacts Template that comes with Access.
On my report, I want rows with expired dates to stand out by having their borders thicker. Something like:
Code:
If Me.txtDate < Date() Then
Me.txtDate.BorderWidth = 6
End If
When I do that, it ends up formatting every txtDate field in the report if one of them passes the If criteria instead of only ones that are expired.
I have one main form with 3 tabulated sub forms.
My main form consists of two fields.
When the user clicks tab 2 (subform 2) or tab 3 (subform 3) the main fields should hide
I tried to achieve this by using the on click event at the tabbed forms. I referenced the two main fields and used the visible property followed by a form requery. It didn't work.
thanks in advance
Hi.
I was just wondering if you can hide a form in the windows status bar?
Hi, I have a form with a cmd butto that unhides a text box, this text box is quite big on the form and I want it to display extra informations, the problem I have is when I unhide the textbox this will appear under fixed fields on the form, I need this text box to appear over everything over the form, Hox can I achieve it?
Thanks
Marco
hello everyone,
I have a database that has only two tables and one form. There is about 100 people that will be using this system(not all at the same time), and I want to hide everything from them except the form, including the microsoft access window behind the form. if i just make the access window small and put it behind the form, that looks alright, but i don't want to have to go to everyone's computers and do that! i've already hidden everything else, i just can't figure out how to make it seem like it's a stand-alone application. Any ideas???
Thanks very much in advance
*j
What I need to do is, not have a form pop up when all the conditions are met. I have 30 some users that log into the db.
I have a form that pops up when the date of the project is past due. to certain users when they log in. I am using the Environ("username") theory, which works very well. But when the user has COMPLETED all the necessary dates, the form still comes up, (but of course it’s blank).
How can I eliminate that problem?
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.
View 1 Replies View RelatedHey AP.uk
I've got Form with some drawings on it and I'd like it change depending on what the user has entered in certain fields on the same form.
For Example: when the user selects a certain type of item in the "Item1" field, I'd like the graphic to change (or another one appear) in the form. Basically an "If this is true, show this picture" type thing.
I've been trying a few things to make this happen, but to no avail... :(
Any incite anyone could give would be most appreciated.
Truly,
Dragonchaser
Is it possible to hide or show a combo in certain records in a continuous form. i.e if certain certain conditions are met.
At present I have if Check1 = true then Combo1.Visible = true
The trouble is it then displays the combo in all records.
Hi All.
What I would like to do, is have a form popup when the main form is opened in my db, which will detail all the changes I have made to it since the last version (this bit is OK) and also, I would like a checkbox on the popup form, that the user can tick once they have read the details so it will not show up everytime they open the main form. (Just like the "hidestartupform" property within the Northwind Database)
I create the form and all that, but do not know how to do the checkbox so once it is checked, the form will not appear.
Hope this makes sense and someone can enlighten me and point me in the right direction?
Many Thanks.
Frank.
How can I hide and display a field on a form depending on what choice I make from another combo box?
View 2 Replies View RelatedI do not like the look of combo boxes on continuous forms. I think that they really take away from an aesthetic I am trying to create. However, I really like their functionality.
What I would like to do is have a text box for the field when the control does not have focus, but switch it to a combobox when it does. Now, this is pretty easy to do - however, it ends up switching all of the text boxes on the continuous form to a combo box and back. I only want to switch the currently selected record.
Does anyone know if this is possible, or have any ideas as to how to accomplish this?
My fellow developers
I want to develop an Ms Access Main Form, which will be able to :
Move automatically to the Left of the Database Window
On Mouse over to be able to show with animation (done that)
When Mouse pointer isn’t on the form to be able to hide with animation (partially done, only when the form loses focus)
Actually I want to have a form with buttons placed on the left of my desktop (hiding Ms Access Window – done that after Internet searching), which will be hidden and when I move my mouse pointer over the form to show.
Check my example. I’m waiting for your comments – suggestions
Best Regards
Theodore
Can you have a hidden field in a form? Trying to set up an order process system where I need to take a wholesale price of an item then mark it up (behind the scenes) and display only the customer price. How can I accomplish this.
View 4 Replies View Relatedhow to hide all form controls at once like if i have many text box and labels how to make a loop to hide it all at once
View 1 Replies View RelatedI would like to have 3 buttons on a form. When clicking Button1, Button2 and Button3 should be shown and Button1 hidden. When clicking Button3, Button2 and Button3 should be hidden and Button1 shown.
How can I do this when it is not possible to manage the object being clicked? I tried the following which did not work because of managing an object clicked is not allowed.
Code:
Private Sub Button1_Click()
Button1.Visible = False
Button2.Visible = True
Button3.Visible = True
[code]....
I am trying to hide certain fields on a form based on the value in another field (if yes or no). I used the change event to enable/disable the fields in question. however, this doesn't work. This is the code below...
Private Sub Combo314_Change()
If Me.Combo314 = "Yes" Or Me.Combo314 = "No" Then
Me.Reason_Label.Visible = False
Me.Combo316.Enabled = False
Me.Label946.Visible = False
Me.Label77.Visible = False
Me.care_not_qualified_date.Enabled = False
[code]....
I have a small access project completed for my office, I have almost everything turned off so only the user can see the main form, but I can't figure out how to hide the ribbon bar on the top, can you do this. This is access 2010 by the way.
View 3 Replies View RelatedHi guys,
I have moved all my small databases into 1 larger database to save up on Taskbar space, but the problem is that when I use an opening form to open other forms (switchboard style) the additional forms show in the Task bar.
Is there some sort of macro that I can use to tell each form to suppress itself from the Task bar?