Hi Rabbit,
I already set control source to other table revision field.
sophannaly
Last Activity: Apr 17 '15, 03:44 PM
Joined: Mar 7 '14
Location:
-
Hi twinnyfo,
Column 2 is type field, and it also has duplicate value. Only revision and type could make each row unique.Leave a comment:
-
Hi Rabbit,
As you said, in my list for revision or type alone may have duplicate value, then I take description as bound column, but all the value of combo box will change to the latest value that I just select from dropdown list.
Could you give me ideas on how to solve this?
SophannaLeave a comment:
-
Duplicate dropdown list
Hi,
I have a problem with dropdown list in combo box. Combo box row source returns 3 fields data likes revision, type, description. In these 3 fields, only revision may have duplicate number but type number is different. Bound column of this combo box is revision. Column count is 3 and width is 0,0,2. I need to show only description of that revision.
For example, in dropdown list returns data like :
1,1,'apple',... -
Hi MTB,
Thanks you so much, now I could figure out where the problem is.
Best regards,
SophannaLeave a comment:
-
Delete query with IN clause
Hi,
I have a problem on deleting data from table with query which where clause use NOT IN. my query is:
but the result just leave only one data row with role_name = 'MOC_PP'.Code:DELETE * FROM role WHERE role_name not in ('MOC_PP',' MOC_SR',' MOC_BB')
Could anybody tell me what is the problem with my query?
Sophanna -
Hi Rabbit, NeoPa
Thanks you guys so much for helping. With your solution, my problem is solved.
Best regards,Code:=DLookUp("[description]","function_classification","[noparse][code][/noparse]= " & [funcgovt_code])
SophannaLeave a comment:
-
Hi Rabbit,
The code you provided, on my continuous form, it always change all rows of funcgovt_descri ption to the latest funcgovt_descri ption base on the latest select of funcgovt_code.
And one more thing is that, in my table, I need to store only funcgovt_code but not funcgovt_descri ption. So when I open my continuous form, funcgovt_descri ption will show blank.
Could you point me out the solution for these...Leave a comment:
-
Hi NeoPa,
I follow your code, but I got error as Run-time error '3085': Undefined function 'Forms!Request_ Budget_Expendit ure_Input!funcg ovt_code.Column in expression.
This is the code that I use:
Could you tell...Code:Me.funcgovt_description = DLookup("description", "function_classification", "([noparse][CODE][/noparse]=Forms!Request_Budget_Expenditure_Input!funcgovt_code.Column(0))")Leave a comment:
-
Hi Rabbit,
I used this DLookup function as
Look up the CompanyName field from table Company, where CompanyID = 874. This translates to:
But on my continuous form, for description field, all data will change base on the latest DLookup value. Could you tell me how to do this?Code:=DLookup("CompanyName", "Company", "CompanyID = 874")
SophannaLeave a comment:
-
Okay, let me try and tell you back the result. Thanks!Leave a comment:
-
Hi Rabbit,
Your explanation is reasonable. So it means that, for the field that rely on combo box column(1), I should change it to use with DLookup function. Is it?
SophannaLeave a comment:
-
Hi,
All these properties already set for combo box when I put it on the form. Do I need to define it again from VBA code?
SophannaLeave a comment:
-
Hi zmbd,
Thanks for your reply. As NeoPa suggest, I tried it with other laptop and the problem still exist. Could you tell me what to do with the four properties that you suggest? These four properties already used when I defined it on form design.
SophannaLeave a comment:
-
Hi NeoPa,
Thanks for your idea. The table that I do data entry, there is a foreign key reference to table that has two fields (code+level) combine together as PK. So in reference table, we also need to use these two fields as foreign key. On data entry form, I just let user choose only code from drop down list (dropdown list display data: code, level, description). After user choosing code, then I will store level automatically (each...Leave a comment:
-
Hi Jim,
Thanks you so much for your idea and it helps.
SophannaLeave a comment:
-
Hi Jim,
Thanks for your reply. But my problem is I would like to send combo box column(2) to a field in table which I didn't assign any textbox or combo box on form. For example, my table fields are a, b, c, d. On form, I have assign combo box which bound to field a, text field for b and c. After combo box A is selected, I would like to use after update even on combo box and send it column(2) value to field d. And this form is bound...Leave a comment:
-
Set field value on after update event of combo box
Hi,
I have a point that I don't know how to do it. My form is bounced to a table but not all fields of table have on form. There is a combo box which retrieve three column value. On combo box after update event, I want to use its column count(2) assign to a table field that doesn't have control on form.
Could anybody tell me how to do this
Sophanna -
Hi NeoPa,
Please a look at my screen shot.This my continuous form.
Below is the code that I use to call on button to run batch file
...Code:Private Sub btnFillWithNewRevision_Click() On Error GoTo err_handler If Me.Dirty Then Me.Dirty = False End If With Me.btnFillWithNewRevision .Caption = lblPleaseWait() .Enabled = FalseLeave a comment:
-
Hi Neo,
I'm really sorry for that. I have this problem cuz in my form, on click button event, I have code which will call batch file to run, and this batch file will erase all data from existing ms access table, then import data from Postgresql DB to this access table. And i'm sure that after this batch file finish running, it means that data is already wrote to access table.
...Code:runBAT ("Download_LastYear_Request_Expenditure\Download_LastYear_Request_Expenditure_run.bat")Leave a comment:
No activity results to display
Leave a comment: