Search results

Hello, I have multiple records with same date in a table and i want to find the last entered record with that specific date... how i can use that with Dlookup function... DLookup("Balance", "Sales", "CID=" & CID.Value & " and datevalue(Sdate) = #" & DMax("Sdate", "Sales", "CID = " &...

Sorry bro, u r more helpful than @Cronk as u replied earliest... Bundle of thanks dear

Hello , i have 2 sub reports on 1 main report... Working good but i want to pass date value before opening of reports (both subforms have date column) ... Tell me,how i can pass date value to both subreports at same time, sothat only specific records can be seen on main report ..... Kindly guide

Thanks a lot for help...

I have attached 2 pictures, 1. Sale records 2.Expense records Sale & expense are not related with any relationship...... but i want to make a report to give daily sale and expense on 1 page

Can u plz give me an example, so i can solve my issue

Hello, I want to make a report based on 2 tables which are not joined together by relationship... what is the way because when i try to make report, error comes that there is no relationship between tables.... Actually, i wan to make a report based on daily expense & sale tables..... kindly guide..

Ok but i need to run a specific form at startup... How can i can do that bro

i have an access database but how i can make it as runtime... i want to run access database as forms only and directly main form opens, no need for design view.... how can i do that

dear if u have combobox as unbound control, it works fine. but if u have bound combobox, it did not retrieve child records in subform

Dear, during navigation of master record, child form record changes. but during change of master record by combox box (master field), child records dont change...... this is my problem....

Hello I have a subform and i need to change record when i change master form record.... but when i change master form record, subform record doesnt change... i tried with filter option but useless... kingly guide... regards,

thanks a lot... it worked

Subform has only 02 events ( onentry & onexit), there is no other event shown... Basically, i have master child form with child form as datasheet view, so i want to control input or validate the datasheet values on every new row entered......

Hello, I have a subform with datasheet view. Now, the problem is how i can find out that New Row added or updated because i want to validate the value of column... KIndly guide, which event i can use to check for every new record added or updated,????