Search results for query: *

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?

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.

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,

Any help from anybody to fix this problem.

Sorry its not import it is export .

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,

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,

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"...

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...

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...

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.

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

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 ?

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...

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 ...

I used Innerjoin.

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.

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

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.

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...