Search results

I am new to access and found the code similar and it worked. Its just an example...I want to populate drop down values when selected in first record to populate in the second form onwards until they change. Ex: It they select "car" for "Type of car" field for an Id=1, When they enter second Id...

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...

Thanks for helping me out....... How to set the Actual value? I can see the Default Value under the options under Data tab of properties, How could we get to actual value and set it. Thanks, Pinky

after googling and found dmax() method. I have written this in Default value property of form Textbox control. Here is the code: =nz(DMax("Control_Number","[tbl general]"),"Criteria=n")+1 But it didn't work. Later I tried, Before Update event procedure: Private Sub...

It is an Auto number field

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...

Thank you Hitechcoach....I was able to do it Thanks, Pinky

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...

Thank you so much....It got resolved :)

Thanks for providing me the info but can u help me with this. I wrote a After update event and set the textbox default value to value entered. But it is not working. Private Sub Review_Initials_AfterUpdate() Me.Review_Initials.DefaultValue = "" & Me.Review_Initials & "" End Sub The...

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...

Thank you....It got resolved

Thank you for helping me out. I have written got focus event procedure with the below expression. It is not working. I added three extra textboxes txt5, txt6, txt7. and each control source was set to IIF([Txt1] Is Null,0,[Txt1]); IIF([Txt2] Is Null,0,[Txt2]); IIF([Txt3] Is Null,0,[Txt3]). It...

Thank you for replying so soon. I tried both ways which make my text boxes default to zero before i start entering which i dont want. The requirement is that text boxes should be blank initially and when we type in only in 2 text boxes or 3, it should calculate the total in txt4. This makes...

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...

Thank you very much! But small enhancement. This is limited to two arguments. But I need to calculate weekly and bi weekly also. How to approach if there are more than two arguments. Thanks, Pinky

Thank you. I tried this earlier exactly same but it did not work. But now it worked . Thanks, Pinky

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