Recent content by rana1978

Thank you very much. Now it is working well. I'm really grateful to this forum members. They have provided me a lot of supports. :):) Rana

Dear Friends... Greetings..!! I have a table (T_I_1) with a field (ChannelID, SIM). A form has been created based on the table. I am trying to do the following but not working- 1. If (in the form) I don’t insert any ChannelID (it is a text field), the curser will not move to the next...

Dear Friend (gemma-the-husky) Actually I am also new in Access and whatever I’ve learnt, it’s only from various Posts of this forum. I have the same question like yours. What should be done if the number of row is unlimited? And how can we filter the rows for particular report? How can we...

Hi, Attached DB can help you. Rana

Dear Friends, I am very much grateful to the Forum members, as I have learnt Access by the cordial support of the forum. I’m facing a new problem, when I am trying to open an Access (Access 2007) file clicking direct on it. If I click on it direct, the same file is opening one after another...

Dear All, I’ve recently installed Office- 2007 but facing the below problems- For Access-2007 1. The Access Icon is not been shown properly. In my PC it is like the attached Icon (Access Icon). But should be viewed differently. How an I make it correct??? 2. The command for Data...

I have converted my DB from Access 2003 to Access 2007. But after conversion the Command Buttons on Forms are not working. Any help Please??? Rana

Solved thankxxx

Friends... In a Text Box (Text2 ) of my DB report, I’m using the below expression ="Total BDT " & Format$(Sum([Value]),0,0)/1000000 & " Million" Properties of the text box: Format : Standard Decimal Places: 2 Bellow result is being created Total BDT 25.57775...

Thankx. But in my main DB I have used another word (like str1 other than reserved), but the result is same. The problem is table is not updating according to the DlookUp value. Please other help....:(

Dear Friends, I have below table and fields in a simple DB tblinout FranchiseID (text) InTime (Date/Time) OutTime (Date/Time) frmInOut is developed depending on tblinout. frmInOut has below controls frnID (control source: tblinout!FranchiseID) In (it is a DLookUp value) Out...

Thank you very much D... Now it is working properly:D:D:D

More Help_ Query with relation for inventory Dear .. Now, though the all fields of the Query (see the Query Q4_01B_dsr in the attached DB) are shown, the closingstock: [bal]+[recvqty]-[dayissqty] is not giving any result. It is happening when there is no value in Received or Issued Field...

Thank you very much... Now it is working as per my need:D Cheers Rana

Dear All…. I’m new in Access and I’ve got a lot of supports from the forum members. I have a inventory data base, where I need a Daily Reports with the below column heading Item Code, Item Details, Day Opening Balance, Received of the Day, Issuance of the Day, Closing Balance I...