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...
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...
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...
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 am facing one more problem in this query. I need to show description in place of ProjectID, OfficeID and VehicleID.
I added Project table and replaced ProjectID with Description field of Project Table. This worked fine and at this stage, SQL View was as follows:
SELECT Project.Description...
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.