Search results

Dear All, I want to make a query but cant able to do that, plz help..... I have 2 tables and i want to make a query to sum values... Detail: Sales Table SNO BID 1 222 2 555 3 333 4 222 5 333 Payment Table PID SNO Total Paid 1 1 1000 500 2 3 500 200 3 4 900...

Dears, I want the user to input date by datetime picker .... kindly guide me how i can do that, example input("Enter Date Here") When i use the above code, prompt comes for getting the value but i need datetime picker, like a normal textbox in runtime mode... regards,

Dears, i want to make a query with a criteria based on value of Field.... Table: Purchase Field. ID Field. Balance I want to make a query in such a way that 1. Balance =0, output 0 2. Balance >0,output 1 3.Balance <0, output 2 Kindly guide....

Hi every one, I have a report and i have a field Name "Balance". I want following conditions on group level 1. Balance =0 2. Balance >0 3. Balance <0 How can i do that? Plz guide.... regards,

Dears, I have a Report with 02 subreports. how can i filter the subreports all in one... , means normally if i have to open the report with filter option, where clause is used but how to filter multiple subreports once... kindly guide.... regards,

Hello everyone, i have unbound text box in report; i need to show multiple values from a table into unbound text box... For single output , dookup is working but i have to show multiple records into unbound textbox... kindly guide me how i can do that.... regards,

Hi every one, is there any way to combine two different from two different tables into one column.....; example t1:a1 t2:a2 what i need is, t3:a1+a2 how i can do that...

Dear, I have a table but i need to see the result like this, any one can guide me , how i can do that...... means i need to add the previous row to current row..... regards,

Dear Friends, Kindly guide me, 1. T1 (ID,Name) --- Master Table 2. T2(ID,Qty) ----- Child Table Now, my question is how i can make a query, which will sum(qty) from T2 against each record in T1.... Example ; T1 ID Name 1 A1 Pent 2 A2 Shirt 3 A3 Jeans T2...

Hello All, I want to use Bound Option button in continuous form with 2 options only ( Yes or No)...... how can i use that.... kindly guide...

Hello Friends, I need to make a report based on 2 or more queries/Forms/Tables...... First Page of report will show First Query till all records will end. then, next page will start Second query....... Kindly guide...

Dear, i need to send pdf file to whatsaap .... 1. Is this possible? If yes, plz give me details..... Regards

Dear, I have a form with Checkbox control (unbound) and when i select a record by clicking on Checkbox, all checkbox are selected but i need to check only 1 record....

Dear Friends, Is there any way to Disable Subform except First Record or First Row...... Kindly guide....

Dear All, I have a Parent/child tables... Parent Table: Sales (SNo) Child Table : Sales_Detail (SNo) Child Table : Sales_Payment (SNo) Child Table : Sales_Return (SNo) Each Parent Record has multiple Child records in each table.... Each Child Table has column SrNo column with AutoNumber...

Hello Dears, I have a subform and a column "Discount" and i have some code on OnExit event for Column "Discount" and it works fine, but when i click out of subform then the event OnExit does not triggered?? can u explain what is the reason and how to solve the issue..... regards,

Dear, I have a master form linked up with 3 subforms; what i want to do is ... when i move focus from main field "SNO" (Primary Key field), it finds the existing record and display and if no record found then clear all the form & subform and make new entry.... I tried to find solution from...

Dear Friends, I have a main form with subform, what i need is when i change value of main form and record exits then populate data for subform based on main form value else clear subform for new data entry.... Kindly guide, Main Form: FrmSales Main Form Field: SNo (Primary Key) Subform ...

Hello dear, I want to delete a post from my account but i m not getting any option.... Kindly guide... How can i delete a post???

Hello Friends, i have 02 subforms and i want to update Form2 on update value in Form1, 1. FrmSales_Detail ( Field: SubTotal) 2. FrmPayment_Detail (Field: GTotal) What i need is, when i enter data in subtotal, it will reflect to New Row in GTotal in FrmPayment_detail .... Kindly guide,