Thanks Remou.
Append query helped a lot in merging control table values. But we had to re-enter details of smaller database again because re-arrangement of autonumbers disturbed the description of identifiers.
In any case, it reduced the manual work.
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...
Thanks.
My company does not have large number of employees and is contented with this solution.
I am desirous to implement solution number 2 suggested by you; i.e., to connect to Outlook as a data source from within Excel in a template sheet. It is a good solution in our scenario.
I need...
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...
I read an article on this issue:
http://support.microsoft.com/kb/284204
According to this article:
NDRs are generated whenever a message cannot be delivered. If the computer can detect the reason for the failed delivery, it maps the reason onto a status code, and a corresponding error message...
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 found a nice FAQ word document about Windows Licensing System at the following link:
http://download.microsoft.com/download/4/e/3/4e3eace0-4c6d-4123-9d0c-c80436181742/OSLicQA.doc
Thank you RichardMoran.
Can you please explain the difference between pre-installed (OEM) and full retail package?
I read definitions on the following website but am still not clear on the difference:
http://www.viosoftware.com/packaging.html
Can the company purchase full retail package...
Thank you.
It worked perfectly.
In cmdPreviewReport_Click of rpt2Select, I added the following lines:
DoCmd.OpenForm "rpt1Select"
Forms!rpt1Select!cboFromDate = Forms!rpt2Select!cboFromDate
Forms!rpt1Select!cboToDate = Forms!rpt2Select!cboToDate
In the report, VHRunningProject, I added the...
...For a given InvoiceDate, query shows total cost for each VehicleID. SQL view of query is as follows:
SELECT Vehicle.VehicleID, Sum([FuelRate]*[Quantity]+[RepairCost]+[OilChangeCost]+[MiscCost]) AS [Total Cost]
FROM VehicleMaint INNER JOIN Vehicle ON VehicleMaint.VehicleID =...
Thanks dhookom.
It worked perfectly.
I also did the same for VehicleID and it worked too:
Vehicle.Description AS VehicleName
Can you please explain why did it work for ProjectID? For Project Description, I wrote:
Project.Description AS Project
In this case also, I have a table named...
...LogBook.OfficeID, LogBook.VehicleID, Sum([KMAfterTravel]-[KMBeforeTravel]) AS [KM Traveled], Sum(([KMAfterTravel]-[KMBeforeTravel])*[Unit Cost]) AS [Cost per Project]
FROM VHCostPerKM INNER JOIN LogBook ON (VHCostPerKM.OfficeID = LogBook.OfficeID) AND (VHCostPerKM.VehicleID =...
...AS Project, LogBook.OfficeID, LogBook.VehicleID, Sum([KMAfterTravel]-[KMBeforeTravel]) AS [KM Traveled], Sum(([KMAfterTravel]-[KMBeforeTravel])*[Unit Cost]) AS [Cost per Project]
FROM (VHCostPerKM INNER JOIN LogBook ON (VHCostPerKM.OfficeID = LogBook.OfficeID) AND (VHCostPerKM.VehicleID =...
Thank you.
I read Windows Vista Volume Activation 2.0 Step-By-Step Guide. According to this guide:
Volume License Product Use Rights require that you have a previous qualifying operating system license for each copy of Windows Vista you deploy. The default 32-bit Volume License media are...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.