Search results

After googling i have got the solution and That is:- Creat a query add a new column RecNo with this Code: RecNo: DCount("transid","feetable query","transid<" & [transid] & "AND STUDENTID=" & [STUDENTID])+1 and in the form in which i need the value place a unbound textbox with the code...

Not working ,,,,

RecID(autoNo) StuID StuName Data 1 1 a Dr 2 2 b Cr 3 1 a Cr 4 1 a Cr 5 2 b Dr In a Continuous Form I Need when I select recid4; a textbox (unbound) Show me “This is 3rd Transaction of this student” So what code will be applied in unbound tex

Try to understand, RecId (autono) stuId Stu.name 1 1 2 2 a 3 1 b 4 1 c 5 2 d 6 1 e Here I need When I select recodid 4; in a textbox it show "This is 3rd transaction of the student."as till recordid 4 the student whose id is 1 have 3 transactions.although his total...

In a DB There are many transactions of many students with unique student ID I need a VBA code by which I can get the transaction number (Index) of a selected Record of selected student from his all transactions.

Nothing understandable?~?~~??

when i open report in print preview the details section not appear in ms access

Thanks

I want to send a message to students parent on a specific date automatically by setting a date. How can this done by VBA in ms access db

i have a ms db with employee info when i click a button a message sent to first employee of the table.but i want to send for all employees in the field so how can i refer a hole column by using recordset

Thank lot

Ok sir I have created a laundry software I want a query in which i can trace (sort) orders which are to be deliverd after 3 Days So i can prepare them before expected Date.

Respected sir, in my db there is a form "order entry" there Qty & unit charge fields are set to default value of "0", So automatic calculation done properly. but when i get report of this record there i also find "0" values. but the client want that in invoice report the empty fields must be...

Thanks a lot!

Yes

I have a database. In a Table "Orders" i have create two fields general customer & Regular customer. If a new customer comes i enter name manually in general customer field .when a registered regular customer comes i select from regular customer field which is a combo box whose rowsource is...