Search results for query: *

I am using Microsoft Office Access 2003. I have two copies of the same database. These are mde files. Two offices have entered data in these files. I have to merge this data in a single mde file. I thought to copy table from db2.mde and paste it in db1.mde with Paste Option as Append Data to...

I am using Microsoft Office Access 2003. We received an mde file from an organization in which we have to enter data. Since the information has to be updated by multiple users, so I split the database into front and backend with the following steps: 1. Split the database into db1_be.mdb and...

In my organization, Microsoft Office Outlook 2003 is being used for marking attendance. Our administrative officer, at the end of day, creates a message, with the following options: Voting Buttons: Present;E/L;S/L;C/L Do not deliver before: Date of next day, 9:00 AM E/L, S/L, C/L refer to...

We are using Microsoft Exchange Server 2003 for our email system. Operating system is Windows Server 2003. We are having problem in sending email to one email address. Whenever we send email to that email address, the following message appears: Your message did not reach some or all of the...

I sent a purchase requisition to a company for a desktop computer. For the processor, I wrote the following: Intel Core 2 Duo Processor E6300 Clock Speed: 1.86 GHz Bus Speed: 1066 MHz When I received the desktop computer, a sticker was present on the CPU box. The following is written on the...

I am using Microsoft Access 2003. I have a query VHRunning2 (Vehicle Running). In this query, there are three tables; LogBook, Office and Vehicle. For a given DateOfTravel, query shows KM Traveled (Kilometers Traveled) for each OfficeID and Vehicle ID. SQL View of query is as follows: SELECT...

I asked this question in another thread of mine, thread701-1365250, but could not get reply. May be because it was in continuation of my previous question and I should have avoided asking multiple questions in a single thread. So, I am writing my question again in this new thread. I am using...

I have to prepare proposal for a company for licensed operating system. The company is buying 3 new desktop computers. I have gathered quotations from a Reseller. Quotations include price for the following: 1. MS Windows XP Professional OEM. Quotation says that OEM can be purchased only with...

I am using Microsoft Access 2003. In an Access Query, I have one table and one query; LogBook, VHCostPerKM (Vehicle Cost Per KM). Fields in LogBook table are: ProjectID OfficeID VehicleID DateOfTravel KMBeforeTravel KMAfterTravel Fields in VHCostPerKM query are: OfficeID VehicleID UnitCost...

I am using Microsoft Access 2003. I created a selection criteria form. This form has two combo boxes; cboFromDate and cboToDate. Report is opened when the user clicks cmdPreviewReport. cmdPreviewReport has the following code: Private Sub cmdPreviewReport_Click() On Error GoTo...

I am using Microsoft Access 2003. I created a report using Report Wizard. I selected the query VHRunningMaint (Vehicle Running and Maintenance) where the object’s data comes from. VHRunningMaint query has two parameters: PARAMETERS StartDate DateTime, EndDate DateTime; When I click the...

I am using Microsoft Access 2003. I created two tables to enter details of Vehicle Running and Maintenance; LogBook and VehicleMaint. LogBook table records Vehicle Running Details: OfficeID VehicleID SerialNumber DateOfTravel KMBeforeTravel KMAfterTravel VehicleMaint table records Fuel...

I am using Microsoft Office Access 2003. I have a form LogBook. This form is bound to a table LogBook. The Composite Primary Key of LogBook table is OfficeID, VehicleID and SerialNumber. In the table, two other fields are KMBeforeTravel and KMAfterTravel. When any entry is made in the LogBook...

I am using MS Office Access 2003. I created a Pop-Up Calendar on my form as follows (the form is bound to a table): 1. Insert -> ActiveX Control -> Calendar Control 11.0 2. Calendar Control (Name: Calendar; Visible No) 3. Added the following code to the MouseDown event of the cboDateOfTravel...

I am using MS Office Access 2003. I created a table (name: Item) with three fields; ItemID, Active and Description. ItemID is Primary Key. Then I created a form (name: Item) and chose Item table in New Form dialog box. In the form, Item (Combo Box), Active (Text Box) and Description (Text Box)...

I created LetterDatabase workbook in Excel. Sheet1 contains columns for letter fields like Name, Address, JobTitle, Salary etc. Then I created a document LetterFormatA in MS Word. In the Mail Merge, I selected LetterDatabase, Sheet1 of Excel and inserted Merge fields in Word. I then created a...

I have an Excel Sheet, Sheet1, which prints donation receipt. Required Data is entered in Sheet2. Sheet1 has a cell, in which user can enter row number of Sheet2. Then Donation Receipt is populated with the data of that row. What I need to do is underline partial text so as to exactly simulate...

I have a userform in Excel Workbook in which user can add new employee records and browse existing records. Data is stored in EmployeesData worksheet in the same workbook. This sheet is hidden and the workbook is protected. To browse existing records, user can click cmdFirst, cmdPrevious...

I need to clear contents of few cells based on value change in one cell. I placed the following code in Worksheet_Change event: Private Sub Worksheet_Change(ByVal Target As Range) If ActiveCell.Address <> "$A$2" Then Exit Sub Else ActiveSheet.Range("A8,A9,A10").ClearContents End If...

I have compensation details in a sheet PayScale. Columns are A to F. Rows 1 to 4: Salary Level upto 2,000 upto 5,000 upto 10,000 upto 25,000 upto 1,000,000 Salary Ranges Minimum Salary 0 2,001 5,001 10,001 25,001 Maximum Salary 2,000 5,000 10,000 25,000 1,000,000 In the second...