if I am using value list as row source type in combo box and typing the value the auto expand property is working but if I am using table/query as row source type then auto expand property of combo box is not working.
yes but it is not working for me if I typed value in combo box it is working but if I call a value from table it is not working. I am using ms access 2013.
well thnx for reply I need solution thank you friend..
I have a problem with the combo box on my form. I have a combo box "driver name" and the row source is a table and I selected "auto expand" property to yes but when I am typing it is not expanding the values on the behalf of the character I am typing and I dont know what to do ?? please help..
can anyone tell me what this code mean is??DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70how I can know the number 8 mean in this code??I want full explanation of this code if anyone knows please tell me.thanks in advance....
can anyone tell me what this code mean is??
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
how I can know the number 8 mean in this code??
I want full explanation of this code if anyone knows please tell me.
thanks in advance....
how to make a code behind buttons to do event which is already an event on the form with different procedure.
explanation...
I have a form and on the form I have an event on dblclick. now I want to make a button on the same form to do the same thing on button click. now how I can do it??
Re: Macro to open an existing form
how to convert subroutine to function?' I want to make a button on my form and want to add an event on_click. the event I want to add on click of button I made the event code but I dont know that how to convert it in function so that I can run in the macro and...
i have the code reset every year yyyy/0001 with the event before insert
here are the code
Private Sub Form_BeforeInsert(Cancel As Integer)
Dim vLast As Variant
Dim iNext As Integer
Me![RIMYear] = Right(Year(Date), 2)
vLast = DMax("[RIMINC]", "[RoadIM]", "[RIMYear]=" & Right(Year(Date), 2))
If...
is there any other way to do it???
can you tell me the process that how i can make the autonumber that if i delete any record the next record will take the deleted record number.
because in autonumber if i delete any record i cant enter the record with same number.
hello sir I am teri.g to make a database and I have a field id no and I want it in "yyyy/0000" this formate where first four are year and last four are increment no. and I want that on every 1st April the increment no reset from 0001. is it possible?? how to do it please reply as
fast as...
hello friends I want to make a field idno in my field like. " yyyy/incrment no. " (2015/0001) like this but I want that every 1st April increment no restart from 0001 and increment with 1. how to do it??
hello my dear friend I have a database every year the no start from current year/0001. like for this year it started from 2015/0001. now I want that every year on 1st April it start like this. I mean in the place of 1st January the autonumber reset on 1st april.... how to do it please help. I...
hello my dear friend your suggestion for the id no is working well thanks for this again. I want to ask one more thing. I want that the id no will restart from 0001 automatically from every 1st April not on the 1st January. what to do I tried but I couldnt find the way I want your help. thank....