Can anyone help for writing code for populating the drop-down value from one form to another.
For Text box I did this:
Private Sub Txt1_AfterUpdate()
Me.Txt1.DefaultValue = "" & Me.Txt1 & ""
End Sub
Private Sub Txt1_GotFocus()
Me.Txt1 = Me.Txt1.DefaultValue
End Sub
But I am not able...
Before my macro was setting all rows to black before it enters the loop. But now the requirement is to Set back the color to black in the certain range. New code is not working. Can anyone help me where I am doing wrong.
Before code:
Dim cells As Integer
Sheet1.cells.Font.Color = vbBlack
New...
hi,
Can anyone let me know how to write a macro which checks the gaps in the records numbering and make it sequential. My Idea was that It should check for the missing numbering in that column. Then check for the highest number and change it to lowest Number+1 and go one incrementing the rows...
HI,
My Form has two fields, Number and Index where Number is autonumber Field and Index is set as primary key.
1> By mistaken if anyone goes to next record and fill any field without entering primary key, then Autonumber is incremented but is not saved. If they want to delete all the...
Hi,
I have created reports which are in reports section of Database window. I have a switch board which has reports button in it. When I click Reports in switchboard it should open either form or another switchboard with 15 reports.
I have tried creating another switch board but we can add...
Hi,
I have a textbox txt1 in form with many records. Initially when form is opened, txt1 is entered a text value. It needs to populate in next record of the form. When we start the second record entry then I need the txt1 of record 2 to populate with the value already entered in record 1...
Hi,
I have three text boxes txt1, txt2, txt3, txt4. I want to set
txt4 = txt1+txt2+txt3.
I could set txt3 control source as [txt1]+[txt2]+[txt3]. But if there is no value is entered in txt2 then it is not calculating sum. Whether or not text boxes are entered value i want to calculate the...
I have (yes, no, other ) in one combo box and (open, no, other) in another combo box. When Yes is selected in first combo box, open should be automatically be selected in second one. How can I do that?
Thanks
Pinky
Hi,
I am new to ms access. Trying to build a form with lost of functionality.
I have to calculate a value and display in text box. Its calculation is something like this.
"[amount+Number(additional_amount)]*3"
where Income is queried from database table Income_table. It has columns year...
Hi,
I have a priority issue and working on populating textbox. They are 2 textboxes, open date and start date. They enter date in open date textbox which needs to be populated in start date textbox which can be edited and stored in table if they are not the same in any case...
Hi,
I am working with form created in ms access database. I have to implement the logic so I am not able to get the right approach.Here is my scenario.
I have to calculate a value and display in text box. The formula needs to take input from other text boxes, values from database and...