Search results

Hey to All I am wondering and searching through threads since many hours about the solution of my problem. I success to find only 1 thread on this topic but in which 1 part of my problem is mentioned. What is My Problem? I HAVE... ...I have a query(qrySearch) which contains data from 2...

hey to all. i have report form such as... here i want that user can open report filtered by account name as well as filtered by date range. firstly if he select a report "Account Report" then he can select a account from combo box to show its report, otherwise leaving blank both combo...

hey dearz. I have a query which includes 3 fields: (1)- Sum of WithDrawalAmount (2)- Sum of DepositAmount (3)- BalanceAmount (Balance: [Sum Of Deposit Amount]-[Sum Of W/D Amount]) I have a bound Form including a unbound field name "GrandTotal" I want to show query "BalanceAmount" value...

this code works good. i have a main form "Account" where i click on cmdWithDrawAmount button to open withdrawspecial form for amount entry in concern account record. withdrawspecial form open using openArgs properity for opening in same record as in "Account". Form withdrawspecial also have...

Slaam to all. hey everyone. i have form with some txt fields and close button. i want that when user click on close button then access generate a message with yes and no button. which is such as" Are you sure to close Application" vb yes or no when use press yes then access check only two...

thank guys i get the solution which is that: the second combo box "cboProduct" RowSource will as under: SELECT Products.ProductID, Products.CategoryID, Products.ProductName FROM Products WHERE (((Products.CategoryID)=[Forms]![Form1]![cboCategory])) OR ((([Forms]![Form1]![cboCategory]) Is...

:) Hey All Dears. i am wondering for several hours to reading threads and searching about this problem but i can't fix it till yet. I have a form1 containing two combo boxes. cboCategory and cboProduct. both combo boxes are unbound. cboCategory RowSource property is as under: SELECT...

thank you for your help

Re: Run Time Error 424: Object Required hi to all. i find a solution of that problem. here is the detail: it is very lengthy but not to type all, just copy paste. I HOPE IT WILL USEFULL FOR ALL THE MEMBERS.

i am using two seperate main forms. 1 Accounts on base of Account Table and 2 Payments on base of Payments Table. how can i get the same accountid value into 2nd payments record.

:)THANKS YOU VERY MUCH.:) MStef and JANR the link of post help me and now it is working well. one thing more is wondering in my mind. that is i) i click open form button ii) payments form open iii) AccountID has get its value automatically from previous form iv) and under this value...

i remove the from command20_click event. and then behind the payments form i type such as: i tried both event open and as well onload but when i click on command20 then this massage appear: what going wrong??

hi to all i have seen all the post on this forum related to this error but cannot understand the type of this error. my code is here: Private Sub Command20_Click() On Error GoTo Err_Command20_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Payments"...

i will appreciate for new techniques. i want to more facilitate my software. as i do job of accountant and want to create accounting software to manage my all record in well manner so may be i indeed your kind help again.

highandwild thanks for your qualified help. its working fine

Hi. Thank You for your help. as i tried it seemed to me that it is useless to update a combo box who's control source is attached with an autonumber field.:( But i design another database. which include three tables. Category Prudocts and Order Details i Create a Form: Products and placed a...

Button of another unbound form will update 1st bound form and its subform data Hi. Thank You for your help. as i try it seemed to me that it is useless to update a combo box who's control source is attached with an autonumber field.:( But i design another database. which include three...

HI all. i am facing a difficult situation. :confused: i have 3 tables thats are: 1.AccountType (AcTypeID, AcTypeName,) 2.Account(AcID, AcTypeID, AcName, AcDetail, AcDate) 3.Payments(AcID, PayID, PayType, PayMode, Amount, PayDate) i want to have a bound form with Accounts Table which include...

update 2nd combo box and subform with 1st combo box HI all. i am facing a difficult situation. :confused: i have 3 tables thats are: 1.AccountType (AcTypeID, AcTypeName,) 2.Account(AcID, AcTypeID, AcName, AcDetail, AcDate) 3.Payments(AcID, PayID, PayType, PayMode, Amount, PayDate) i want to...

Hi! I build a form that include many command buttons. such as Next Record, Previous Record, Find Record, Close Form e.t.c i want to press command button with a keyboard key not with mouse click. for example 1:i want to press Find Record button with "Ctrl+F" key combination. 2: to press Next...