Search results for query: *

ck1999 Thanks a lot for your valuable post That was useful

SkipVought Thanks for the response Actually each value has to be separated by a ";" and not a comma , because some of the data has commas in it So I have to load into Note pad with ";" separator Thanks

Hi I have an Employee table in Access database. It has fields Empno, EmpId, DeptNo, Loc, Salary , Manager_id It has close to 88,000 records in it I would like to query the data with a recordset and later I would like to dump all the data into a Note pad Each field needs to be separated by...

The day_worked has the values of the day in the week They are like Sunday , Monday , Tuesday...etc They are not numerics like 10th, 11th, 12th etc Could I have a single parameter in MS access 2003 which would yield me a single query from a single a paramter like Select * from Emoloyees where...

I am using Access 2003 database. I have an employee table with fields Empno, EmpName, Day_worked fields Day_worked have values like 'Sunday', 'Monday', Tuesday'..etc I am trying to parameterized query a table like Select * from Employees where Day_worked In ([P1]) Here P1 is a parameter...

I have an xml file ( C:\Emp.Xml) with employee information in it It has data with empoyee_id , employee_name, location and salary information These are the columns and the data is in xml format Emp_id, Emp_name, Loc, Sal The number of records in the xml file is varying I would like to read...

Hi I have a form field in MS Word 2003 . The default background color is grey color How do I programmatically make to back ground color of the form field to white The name of the form field is FField1. There are other form fields in the Active document also. But I want only FField1...

I have a 3 form fields in MS Word 2003 They are in 3 columns of a table in the Word Document Each form field has values Employee_id, Employee_name and Salary Form Field1 in Table Column1 is supposed to contain any number of Employee_ids Form Field2 in Table Column2 is supposed to contain...

I have MS Access 2000 on my machine . I have around 40 applications running in Access 2000 on my machine My client has sent me an MS Access 2003 mdb file I am unable to open that file from MS Access 2000 I am getting an error that my database is of a lower version and needs to be upgraded ...

I have a table (PROJECT) which maintains yearly expenses information. It has the expenses for an year and also the cumulative expenses till that year . The table may or may not have data for all the years in a consecutive manner The PROJECT table data is like Project_id Year Yr_Exp...

I have an Excel workbook (WBK), which has two sheets ( Sheet1 and Sheet2 ) Sheet1 has all the countries and their corresponding capitals in column A and Column B respectively. There are about 180 rows Sheet2 has only few countries ( about 100 ) and has country names and capitals in Column A and...

I am having two tables . A Master table and a detail table The master table is a HOLIDAY table which has a list of all the holidays in the company. The field is HOLIDAY_DATE. There is a detail table is HOLIDAY_PROCESS table which contains the overtime information worked in the holidays . The...

I have a Expenses table. It maintains the daily expenses in US Dollars of various units of the company. The structure of the table is Dept_Id Date Month Year Expense The data looks like Dept_id Date Month Year Expense --------------------------------------------------...

I have an employee table with Employee names All the Employees are supposed to end with a Full Stop (.) The data should be like Empno Empname ----------------------- 101 John Williams. 102 Tracy Roberts. 103 Alice Hilton 104 Joseph Fowler. But...

Beilstwh Thanks a lot for your valuable post It works

Hi I have a employee table with Empno and Empname The Empname has all Employee names like John Smith, Robert Jones Alice Williams .....etc However , The names are preceeded by " and the Empnames are looking like "John Smith "Robert Jones "Alice Williams "Keith Fowler How do I eliminate...

Dagon Thanks for the code It works Thanks

SantaMufasa Time_processed is Date Datatype Thanks

I have an ITEMS table. It maintains the record of all items which are in inventory. The columns in the table are Item_No, Time_Processed, Item_status. All items come in a queue and get processed within a minute So the Item_Status of items change from "Processing" to "Completed" Both these...

I have a worksheet with employee data. It has only one column which has employee ids All employee ids are in one column , one row after the other . However , there are some blank cells in between the employee ids. I would like to permanently delete those empty rows There are exactly 960 rows...