Recent content by pinky

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