I want to change the value of a combo box on a main form based on the update of a combo box on a subform. I have the following:
Private Sub cmbSubCombo_AfterUpdate()
If Me.SubCombo.Value = 1 Then
Me.Parent!cmbMainCombo.Value = 1
Me.Parent!cmbMainCombo.Locked = True
This is Repost with different title - since my original did not meet posting requirements (in error). Sorry started writing the issue and forgot to get back to the title to complete it.
Forum Use Guidelines, especially Item 4...
I have created 2 tabs Data and Form, Data Entry Form. With Name, Date, Item No, Outcome (dropdown) and Comment. Along with Save and Reset Buttons.
Could someone please help with VB for me. Thanks JJSB
I want to do a two criteria match and then return multiple values form a third column
Google makes it sound like this can be done but I can't understand the guidance. Hoping you can help. We have a new word document with about 16 form fields (a mix of legacy form fields and content controls). I'd like to be able to automatically compile the data from the 16 form...
I am not able to print the whole of user form. My User form seem to be quite big and when I print using the following code...the user form which appears in the screen gets printed and remaining ones are not missed.
Private Sub CommandButton2_Click()
I have 4 forms on one worksheet.
I need to place a command button with each form.
On click the relevant form needs to be saved as pdf on desktop.
Regards and thank you in advance
My User Form opens another excel file. I want to close this newly opened file when I want, but not have excel ask me to close my User Form interface.
I have the below code in my ThisWorkbook VBA script window, but it still does not allow me to keep my User Form open after trying to close the...
Got a tough one today (well, for me at least).
A workbook application collects data from the company server and populates a worksheet form (not UDF, just the sheet designed as a form). I need to grab the created datasheet form, copy it as a graphic to a Word document to finally...
I'm looking to copy particular information from one form and paste it into another form in access 2013. Does anyone know of an easy way to accomplish this?
I'm a novice when it comes to access, I just use the basic functions.
Thank you in advance.
I have multiple macro buttons on one Excel sheet, which i would like to hide in a 'form' of sorts which is opened with one command button. when i activate the command button, a 'form' with all the macro's are displayed.
Will really appreciate your assistance.
WHAT I AM WANTING TO DO:
I have a userform that I use for entry purposes.
I have a second form that I use for editing the previous entries. The second form (editing form) largely mirrors the entry form, save for a few additional fields that are not present on the entry form.
Hello i am new to VBA i am creating a user form to enter cash vouchers. The Problem i am facing is in searching back the results regarding 1 criteria . i uploaded the picture that can help u better understand my problem. I post several transactions with having one invoice number and i want the...
I have a button on a form. When I click that button I want it to change the value of a field (Combobox) on that form. The field on the form is named _NO_BID_RANGE_01
I tried with no success:
[_NO_BID_RANGE_01] = "NB"
here is the source selection for that...
I have an file I open(file defaultsd to cell C2 which Must be filled in.) with a click box in a form. when the workbook opens I can't edit the fields.
the cursor is a thin lined cross , when i click it turns to a plus sign then back.
when I try to close I get my message to fill in...
I inserted UserForm and some other Form Controls such as textboxes/labels etc. I changed the name of each control for example TextBox1 to Mybox, Label1 to Mylabel etc. I also changed the name of the UserForm from UserForm1 to MyUserForm. Now, when I go to coding window, I see on the left...
I created a Split form. Used the wizard. It put my fields in the detail section - which I can see all of them and edit them when in Design view. But when I go to Form view there I don't see my fields. I see them in the datasheet section on the bottom and I see the buttons I put in the form...
I have a few sheets of items.
I want a person to be able to put x's in the cell to the left of any one of those items on any one of those sheets, and have the selected items appear one after the other on a final sheet, i.e. an order form.
Any idea how I might be able to...
Just like the Title says..
I am trying to figure out how to add a WindowsMediaPlayer control to a form via code. I am not able to find the correct syntax for it. Apparently, it is not done the same way as adding MSForms controls such as labels, texboxes, commandbuttons, etc..
Has anyone seen...