Search results

Creat command button and write below code in ON CLICK EVEN DoCmd.OpenReport "Report name", acViewPreview, , ([TableDateField] Between #" & Me.StartingDate & "# And #" & EndingDate & "#)"

Thanks Bob, Please have a look attached statement. When I sum Purchase amount it multiply number invoices, i.e. $3575 x 6 (number of invoices) = $21,450.00 Regards mithani

Hi, I am working on Accounts Statement query. I have compiled my StatementQuery which is based on two queries, purchaseQuery and invoiceQuery. If I have got one purchase order of amount $1,500.00 and we received three invoices $600 + $500 + $400, my query shows as below POno, POamount...

See if this might help you. Write this select statment in After Update even in contactfield. Me.territories.RowSource = "SELECT TerritoryTable.Territory FROM TerrirotyTable WHERE Contact = '" & Me.ContactField & "'"

Thanks John.

Hi John, I have attached sample DB. I have tried group and max but still POno is showing duplicates number. My query should show only three records 1001 ~~~ POamount(sum) 1002 ~~~ POamount(sum) 1003 ~~~ POamount(sum) Thanks Mithani

Thanks John, Yes I did try but didn't help. Still showing duplicate POno. Regards Mithani

Hello, I am working on statement of accounts. I have a purchasing table (POno, POdate, POdescription, POAmount, .........). What I am looking for is, If I have difference amount against same POno, my query should show only one line with POno, PoDate, POdescription and POAmount(total Amount as...

Hi Everyone, I have one combo box which listing name of different screens. When I click on any item from Comobox, that screen opens. What I want is, how would I make enabled false on any item. Means as per user rights, some of the item(s) would be enabled false. Thanks Mithani

Hello, I have a simple continues form where I have two check boxes. I am trying to click check box but showing RECORDSET NOT UPDATABLE. Any clue. Thanks Mithani

Thanks David

Thanks ShaneMan

Re: MENU Hi DCrake. Your menu is awesome. Could you pleaes give me hint how this menu work. Thanks Mithnai

Thanks guys. You all are very helpfull.

Hello, Can anyone help me please. I have got my own user password screen which protect my software to use unauthorized person. What I am looking for is, I want to display username on everyscreen. How would I save a current user?. Here is a code of user password screen Private Sub...

I ve tried and tried but think am not good in Access. If you got any sample DB, please send thru. Thanks a lot Mithani

Dear Do I have to write this code to call public variable value? Regards Mithani

Thanks Banana, Still its showing #Name? I am using Access 2007 Any clue? If you got sample form, please send thru to me. Regards Ameer

Hi mates I am moving my head arround but couldn't figure it out. What I am looking for is when I enter user name in my login form, should save in public variable so I can call in any other form or can save in any table. Thanks for your help Mithani

HI mates, Trying to display bmp but can't figure it out. See attached screenshot. Just showing file name and something else. Can anyone please help me? Thanks mithani