I would like to hide/show button depend on is there anything in a field. My current code is not working at the moment:
Private Sub Form_Load()
If Form![fourniturenErrorsub]![Code Field] <> Null Then
errorbtn.Visible = True
Else
errorbtn.Visible = False
End If
I'm trying to alter the look of my menu Menu Image.JPG. Depending on the User's Permission setting from the Table PermissionTable.JPG.
If they do not have permission for a company then, i want it to be hidden from the menu?
I use DoCmd.ShowToolbar "Ribbon" acToolbarNo (or acToolbarYes) depending on a value in a table which I have shown certain "trusted" users how to change.
But is it possible to do something similar with the Navigation Pane?
I have an Undo button : [btnUndo] and would like it hidden until someone starts to enter data, where it will become visible...
what code would I use? and where would
Code:
me.btnUndo.visible = true
be triggered?
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code:
ABC Co.
ZYX Co.
123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.
Right now, my code looks like this for On_Click:
Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?
Hey 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
Hi
How do I easy create a checkbox that displayes a field when I check it.
For example, if I check a box named I agree, it shows a field with a phonenumber to call
Mike
I'm using access 2007. I'm trying to get a combo box on a form to show or hide an image on a report based on the combo box's value. It seemed simple, but I've tried lots of codes.
View 7 Replies View RelatedI have a sub form with checkboxes. Each check box represents one of the columns/fields in my query. If one of the boxes is checked, I only want the column that matches with the check box to appear. I have done some research and have came upon the ColumnHidden property.How would one do this in a macro or VBA format.
View 1 Replies View RelatedI want to automate a query so when the user views it they see only the columns that have data. Columns that do not have data are not there.I am using MS 2007
My Access tool is setup to import data into tables and then the user views the data imported. However, if their's no data (and no column to import) I want the query report to not include the column.
I want to add a section to my report and control the visible value based on page (1st, 2nd, etc...)
So:
1st page show 'Page Header' which has lots of detail, but dont show 'AccNum.Header' section.
2nd, 3rd, etc.. don't how 'Page Header' as I don't need lots of detail, but show the 'AccNum.Header' as this has customer name and Invoice numer, which is enough header information of all the rest of the pages.
Tried using 'On Page' and logoc aroung [Page] but no progress.
I have a combo box with the following
YES
NO
EXPIRED
this is named "Permit_Holder"
when you click yes i want two extra fields to appear called
"Permit_Date_Issued"
"Permit_Date_Expired"
but i cannot seem to get them to hide or show?
I have used the below codes but no success
Private Sub Permit_Holder_AfterUpdate()
If Me.Permit_Holder = 1 Then
Me.Permit_Date_Issued.Visible = False
End If
End Sub
Quote:
Private Sub Form_Current()
Me.Permit_Date_Issued.Visible = False
End Sub
I want to show or hide a box on a continuous form. If there is a date in the ShopOut field i want the label to show up , if not then it will not appear.
I am trying
If IsNull(Me!ShopOut) Then
Me.StillinShop.Visible = True
Else
Me.StillinShop.Visible = False
End If
however, it shows the box whether there is a date in ShopOut on not. Is it possible to do this in a continous form or do i need somekind of me.record#.ShopOut or something.
I have a button on a form which calls a module to show a calendar form. The user picks date and time, and saves it. The calendar form closes and adds the date and time to a text box on the initial form.I want to save the record so that the underlying table/query is updated, but it's not working. The record is not saved until the initial form is closed.Here's the form vba...
Code:
Option Compare Database
Option Explicit
Private blnFlag As Boolean, blnSaveIt As Boolean
Private Sub btnDelete_Click()
On Error GoTo Err_btnDelete_Click
[code]...
I would like to know if the following is possible: I have a table, I have a form based on that table (datasheet view) and I would like for certain columns to visible or not based on the input on a Combobox (list of countries) that is based on another form.
I have searched on the web and I found that the following:
On a button based on the main menu form:
Code:
Private Sub Go_Click()
Dim stDocName As String
Dim stOpen As String
stOpen = Me!cboDest
stDocName = "Datasheet"
DoCmd.OpenForm stDocName, , , , , , stOpen
and then on the event "on open" of the form Datasheet I have inserted the following:
Code:
Private Sub Form_Open(Cancel As Integer)
Select Case OpenArgs
Case "USA"
Forms![Overflow]![Tasks].Visible = True
Forms![Overflow]![Constant Number (Min)].Visible = True
[Code] ....
I have done it as a test, but it appears that it does not work. It opens the forms, but it does not hide or show the columns based on the option, it brings all the columns.
I have a database with a main menu which opens up on start-up it works fine and all but I want to go the extra step, I wish to disable / hide the ribbons (Top and Bottom) - Or Hide the whole Microsoft Access Window and display my form with the desktop behind it.
The next thing is once I click the X or the button to close the form I want Microsoft Access to appear again as in everything to show itself again.
The user wants all the non-basic functionality of the ribbon hiden. To accomplish that by doing the usual stuff:
File >> Options >> Current Database >> Allow Full Menus (unchecked)
Everything worked as expected, but we came across an issue. The user needs to open a report in "print preview" and they need to be able to export their report to excel. The "print preview" ribbon tab is there, but it is not showing the "Data" area, where all the export options are.
How can I do this without a costume ribbon?
Maybe there is a way of manipulating which areas of the ribbon/tabs/areas/controls are enabled from VBA?
I am creating a database for an ambulance organization to track call history. One of the fields that needs to be populated is patient's last name. I need to show the last name when printing the form for billing purpose. However, I only want to shoe the first three letters of the last name in the table. For example, if the patients last name is Smith. When printing the form I would see the name Smith, but in the table I would only see Smi**.
View 1 Replies View RelatedI 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.
View 2 Replies View RelatedCurrently I have a query where the criteria is dependent on the combo boxes on my form. I would like to add checkboxes to my form which determines which fields are shown or hidden. For example if I had a checkbox for address, selecting it on my form will show the address column in my query results.
View 4 Replies View RelatedIs it possible to have a text box momentarily show the character that is input, and then hide it with a dot (or similar)?
This is for password input so that users can see momentarily, but others won't be able to.
I have a form (employee info) that requires the user to do a search to find the employee before then editing anything that needs to be edited.
I have a search box that will find the relevant record without any problem, however what I am looking to do is hide text boxes on the form and have them appear only once the search has found the matching record.
If no matching record is found, I would then like a message box that states 'No matching employee, would you like to add an employee' and when the user clicks OK, it then reveals the same hidden text boxes and sets focus to the first one of the bunch.
Now, I have used the 'me.textboxname.visible = True (or False) elsewhere, however, I am not sure how to trigger that after a search.
I assume I am looking at an If statement, but I am not sure how to construct it, hence turning to the experts.
Code:
Private Sub txtEmployeeSearch_AfterUpdate()
If txtEmployee = DLookup("EmployeeNumber", "tblEmployeeInfo") Then
Me.txtboxname.Visible = True
Me.txtboxname2.Visible = True
DoCmd.GoToControl "txtboxname"
Else
MsgBox "Employee Not Found", vbYesNo
<<<<<<<<<<<<<<<<<<<<<<
End If
End Sub
I know that there is a massive gap where I have put <<<<<<<<<<<<<<<< - but I am stumped as to what to put in there?
I have chart (grpMaster) that is embedded in a form (frmMain), the chart is a line graph based on a query (qryDataFilter) with 4 data series.
What I want to do is have various checkboxes (chk1 to chk4) that if selected show the series and if no don't - It seems straight forward!
I've tried SeriesCollection() but this comes up with errors. (Object doesn't support this property or Method).
The easiest way i can think of is just to hide / show the series line on the chart, but can't figure this out?
I have a report base on my table. Here a check box. I wanna show two label text hide/show base on when check is true or false. It will be when report will be open. I have try this but nothing is happened.
Code:
If AffecteAc= True Then
affected.Visible = True
general.Visible = False
End If
I have a Split form displaying parts information and have all data displayed from the table including an obsolete field which is a Yes/No checkbox.
I want to display ONLY unchecked fields on a button click. I have tried this code so far but it didn't seem to have any effect
Private Sub cmdCurrent_Click()
Me.chkObsolete.Visible = Nz(Me.chkObsolete.Value, True)
Me.Requery
End Sub
Commands:
- cmdCurrent = show all unchecked fields
- cmdShowAll = show all fields
- cmdSearch = filter based on textbox entry
Other: There is also a hyperlink in each field (on the form only) to open each individual record for editing.
Field in question is chkObsolete
Command in question cmdCurrent
Hi Guys. I want to Display a command button on a form dependent on the value of another control.
I have a Main Form: frmSalesOrders and a Sub Form frmSalesOrderDetails
I have a command cmdSpecialInvoice on frmSalesOrders.
On Form Load I hide this.
However if the user selects a MakeID from frmSalesOrderDetails with an ID of 61 I want the button to be visible.
I attempted to put this on the After Update Event of control 'MakeID'
If Forms!frmSalesOrderDetails!MakeID = 61 Then
Forms!frmSalesOrders!cmdSpecialInvoice.Visible = True
End If
I got an error stating could not find frmSalesOrderDetails?
That aside is it possible to do what I want?
Note:
MakeId is a combo. Takes its value from qryMakes if tht makes a difference.
Any ideas?
Cheers,
Phil.