Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eshaan
  • Order by date
  1. eshaan

    minutes calculate

    How can I add minutes into hrs if minutes more than 59 in report? I created report that is calculating minutes . I created grand total. In grand total it is showing 59.82. Last two digits are more than 59 it has to be add into hrs. ex: 59.82= hrs60.32mts. Any idea?
  2. eshaan

    tab control

    Hi all, I am using tab control. I have 13 tabs . Each tab has one page. I can see 6 tabs (horizontal)on the form in run mode. How can i create another 6 tabs in the second line(in horizontal) on the same form. Any help please. Thanks in advance.
  3. eshaan

    Save/Export

    Hi all, Anybody knows how to create save/export button on Customize menu bar with out grayed . I created save/export on cutomize button but it is grayed. Any help from anybody. Thanks,
  4. eshaan

    Save/Export button

    Any help from anybody to fix this problem.
  5. eshaan

    Save/Export button

    Sorry its not import it is export .
  6. eshaan

    Save/Export button

    Hi All, I created cutomized menubar. I add Save/Export command on the customized menubar. After created mde file all other commands print, send , printpreview etc. are showing but Save/Export button is grayed. This button has to show when user try to import report. Any idea? thanks,
  7. eshaan

    Report

    Hi gol4 User is selecting Depart. Number values from the form . When reports prints it has to show Dept Name. There is other way to use iif function Can you please provide code how to use choose() function on report colum. Thanks,
  8. eshaan

    Report

    Hi all, I created report. On that report tthere is department name has to show. Data is coming from table with numeric values. I coded on report depart name =iff[forms]![frmname]![combobox] ,"2", "financial",or[ forms]![frmname]![combobox] ,'3' "Billing Dept"...
  9. eshaan

    report

    Hi, I have problem for another combo box that is this values are all numbers. If user select particuler code it will print that code only that is printing fine, but how can I allow user on the form to to select all print all codes . Also I have another combo box on the form those values are...
  10. eshaan

    report

    Hi PHV, It works well thank you. I have another question. IOn the Form n combobox I entered values ( "all, dept1,dept2,dept3 ") . If user select in combobox "all " it has to print all departments information or If user select "dept1" it has to print only dept1. In department table there...
  11. eshaan

    report

    Hi PH, where nz([completion date],'?')=iif([forms]![testfrm]![Cmbproc]='completed',[completion date],'?') I entered above in where clause giving error The expression you entered contain invalid syntax.
  12. eshaan

    report

    It is not working . Please specifiy where can I define data type as text? Also Third combobox. Urgent please.
  13. eshaan

    report

    Hi PH, Thank you, I want to put both completed and incompleted if combobox = completed it has to be isnotnull if combobox = incompleted it has to be isnull. How can i enter both in where conditions. what is the Nz after where ?
  14. eshaan

    report

    Thank you. I will try today to set data types date and text. If i choose two options on third combobox how can I enter in criteria? if user choose from third combobox "completed " It has to be isnotnull if user choose from third combobox "incompleted" it has to be isnull. How can i enter...
  15. eshaan

    report

    I have form. User can enter start date and end date on text boxes, and select data from three comboboxes. User can select from first combobox dept name seccond combobox person name third combobox is completed evaluation or processing evaluation or incompleted. I created a query ...
  16. eshaan

    update

    I used Innerjoin.
  17. eshaan

    update

    I am trying to update one filed from table1 to another field table2 with join condition about 50,000 records. It is is giving error 0 records updated. Urgent please.
  18. eshaan

    DataEase

    How can i convert DataEase data into Access 97 with out using any converting tools. Any Ideas ?
  19. eshaan

    tracking date and time

    Hi all, I need to track date and time to store user's name on table when database or application is open and making changes on forms ,reports ,queries ,macro's and modules. Anybody have any idea? please help.
  20. eshaan

    distinct in query

    I converted database from text file to temporary access table. I want to append data from temporary table to original table. In temporary file every record got another duplicate data. My orginal tables are Employee info table and Employee details table. When I append from temporary file to...

Part and Inventory Search

Back
Top