Search results

Hi DBGuys Thanks a lot for help, now its working perfectly. Regards Nasir

Please help how to use that functions. I am not so expert in programmings.. Thanks..

Hi I made the changes in DIMming the variables Dim Name_Field_DB as String Dim Name_Field As String Dim Amount_Field As String Dim TotalNo_Field as Integer, Dim Number_Field As Integer But still have same error I also search the threats but didn't find the solution. Please advise further...

Hi Gasman A. Yes Form remains Open B ID_Jamat is Also is in the query as shown below for both querries C. DIMming . BankName is an String as this is a Name, and FiledNo as Integer as value of the field if there is something wrong please help me which one is wrongly defined. Please note that...

Dear Friends i have created a function that will populate the values in a report from a query if i set month value in query as "JULY" then the report shows all the values and below function runs perfectly. as shown below the report shows all the values...without error Then added a form with...

Hello team i am in access so have less knowledge i have primary key that is the code of the customer i also have a Invoice no with a pattern of XXXXX/XX that is Text and controlled by the MASK i want that when i enter a INVOICE Number, when i go to next or save the form and new form opens...

If I use "budgetYear =' 2018 '" in criteria So it only get the value for one person. Even when I change the code from combo box Value not changes. If I use "budgetyear" = &[txtbox]& It gives #Name? Regards Nasir

i am not changing the criteria. i am explaing you that with only one criteria my dlookup works fine. however, i found a solution, i make a querry and for year i used the TextBox, in the criteria of the querry, then i use that query in the dlookup i was facing problem. now querry filter...

Friend DLookUp([Bdgt Aam_Amd]","tbl_Budgets17-18", [yourcode] = '" & [txtCode] & "'") this works fine. and i a,m getting proper data. underscores are in the field name, and not have any issue. when i add one more criteria , getting only one result, that is on the top of my table. criteria for...

if use it, it give me the value for year 2018, even if i change it to 2017 it give value for year 2017. But if i use the below code the Result is not changing as the code changes =DLookUp("nz( [Bdgt Aam_Amd],0)","tbl_Budgets17-18","[BudgetYear] =2018" And "[code] = """ & [txtCode] & """")...

hello i have tried this =DLookUp("[Bdgt Aam_Amd]","tbl_Budgets17-18","[BudgetYear]= '2018'" And "[code] = """ & [txtCode] & """") but when my code changes, data is not changing... please suggest.

sorry didnt get you.. Dear I am not very experience programmer... please help me out

Hi as per your suggestion, i test as below =Year(DLookUp("YearStartMK","tbl_FinancialYear")) works perfect give me 2018. =DLookUp([Bdgt Aam_Amd],[tbl_Budgets17-18]," [BudgetYear] = '2018' ") gives error #Name? my tbl_Budgets17-18, field BudgetYear is text filed having data 2017 and 2018 i...

i moved all the data makred with dataYear. now i have data for 2017 and 2018. in one table. my txtYear is :=Year(DLookUp("YearStartMK","tbl_FinancialYear")) Now i am still getting error #Name? please help.

Great... Thanks

I have two tables... 1 for year 2017 and other for year 2018. Both tables have same fields. Now I have a form that looks up data Now I have two table.. So I want that Dlookup (expression, table name, criteria) I want to use a combo box... To select the table name I want to look up. Plz...

Hello Team i want to get the values from two tables. both table have same filed names but different values. i want to choose the table name via a textbox that have a list of table. =DLookUp([Bdgt Aam_Amd],[tbl_FileName]![FileName],"[code] = """ & [txtCode] & """") i am getting #Name...

hi Arnelgp please explain the below code your used. Private Sub Form_Current() On Error Resume Next If Me.NewRecord And Screen.ActiveControl.Name = "Degree" Then Me.Code.SetFocus End If End Sub Private Sub Form_BeforeInsert(Cancel As Integer) Cancel =...

Hi arnelgp thanks for help, i will design my form as i required, the relation is ONE to ONE, degree is just a case i mention for explaining my requirement. thanks again. Regards Nasir

Hi freind but i dont need any sub form... Also my relation is ONE to ONE. Code is Primaty Key in Both Tables. kindly suggest. regards Nasir