Search results

hi every one i have some problem when i use Query in DLookup Function As a refrence instead of Table For Example i am using this..... =DLookUp("Item_Rate","Query","Party_ID =" & [Forms]![Transaction]![Party_ID] & "And Item_Colour = " & [Forms][Transaction]![Colour]),""") Here i want to...

How to display a report in an unbound object, as we can show a form in an unbound objec.

hello i am working on a project in which i have a form named "employee" now i am facing a problem when i enter a token number in that form, the amount of monthly salary in a field named "monsalary" must b shown in the field named "salary" by default. for instance:- i am entering token number...

Hello I am using a command button in a form named "databutton" but their is a problem that the image.bmp is not fit to button size automatically. is it possible that the image size will be auto fit to button size?

Hello i am working on a project where i have a table named "employee info" in which the fields are "employeeid" "employeename" , "employeesalary" , and also have another table named "employeesalary" in which the fields are "employeeid" that is linked with the "employee info" table...

Hello I hv 2 fields named 1- date 2- dayspermonth i am usitng to enter date in "date" field like 12-Jun-2010 now i want to calculate automatically the number of days in the month of Jun in the field named "dayspermonth" plz tell me is it possible?

Hello, I am facing a problem in my access project. Actually i was using a monitor of 14" so my MS Access project is set to that screen size. Now i have changed my monitor with 17". But the problem is that my MS Project is not showing the image in forms fit to screen. plz tell me what to do...

hi all i am running a ms access project on my computer, but now i have changed my computer monitor, now i have purchased a LCD. But my ms access project is not running properly on this LCD resolution. is it possible that my ms access project will be adjusted automatically on every computer...

i am using DAvg formula in a report field [avgrate] as......... =DAvg("[Rate]","Main Query","[TranDate]<=[Reports]![Issue Plot/w]![Trandate] AND [Rate]>0 and [Itemdes] = '" & [Itemdes] & "'") but when i want to sum this field in report i dont get any result now i want to use this formula in...

Hello All I am facing problem to sum up in report group footer of a field for example i have some fields like......... Qty(A)---Value(A)----Rate(A)---Qty(B)----Value(B) 5----------25---------5---------20---------100 10---------50---------5---------10----------50...

Hello All I am facing some problem in subtotal of a field called rate in which i am using this formulla =DAvg("[Rate]","Main Query","[TranDate]<=[Reports]![Issue Plot/w]![Trandate] AND [Rate]>0 and [Itemdes] = '" & [Itemdes] & "'") but when i use to sum this field the result is "0" Plz...

Hello all How to hide a whole field in ms access report based on a null/zero field? :)

Hello All I am facing some problem when i using the DAvg Formulla I have a Query Named Main Query. It contained data as... Purchase Qty--Rate--Purchase Value---Issue Qty---Issue Value -----50--------10------500----------------0----------0------...

is it possible that can we use the criteria parameter in report instead of a query?

Hello Dear All i am using this criteria in query to generate a report when i put dates in a form named "frmReports" in which the fields are named "txtdatefrom" & "txtDateTo" the criteria is....... >=[forms]![frmReports]![txtDateFrom] And <=[forms]![frmReports]![txtDateTo] Using this criteria...

Hello All I have made a project in ms access that contains graphics/pictures. In that project i have added data of pictures in jpg formate. Now the problem is that when i generate any report of pictures or related data that contains more than 10 pages, it takes too much time to reach at last...

Is it possible that any report can be linked with sub report For example can we link any report with unbound object like a form.

Hello I am using this code for opening a form with subform but i want to open form in add mode. Plz tell me how is it possible? Which code can i use? I am using this code Private Sub Command5_Click() Me.Object2.SourceObject = "Payments" End Sub Dj Wasim Pakistan

How can i protect my form/report/query/table design from changing through vb code? but only the person who have the password can change the design. Wasim Shahzad Pakistan:rolleyes:

how can i set the default value of a field (before entering any any value) as another field in a form? For example there are 4 fields named Quantity---Price---Amount---Avgvalue now i use to enter data as......... Quantity---Price---Amount---AvgValue ---5--------20------100--------20---...