OnlinePCTips.com

PC Tips and Tricks to make your life easier
Subscribe

Archive for January 3rd, 2010

The Best Tool In Software Development Is Microsoft Access.

January 03, 2010 By: lilybird Category: Software

One of the best tools in software development is Microsoft Access, even though there are some downsides to it. MS Access allows you to develop a simple and functional desktop database. But one of the downsides of Access is that it is not that easy to export reports from MS Access to another application and file format. Most developers find it difficult transporting reports to MS Word for example. But the thing is that we can’t export OLE objects to MS Word through the merge process. You have to use VBA code in Word to call the OLE object through ADO. This is one of the methods you ca use. But, with the new Adobe Acrobat version you can do it more effectively.

With the Adobe Acrobat 7 available in all major MS Office applications, you can now create reports in MS Access and then print them directly to PDF format, instead of exporting it to MS Word file format and then converting it to the PDF file. Another advantage is that if you are using OLE objects in your report, they will be accepted by Adobe and it will show the picture, if you want. A lot of users want to use MS Access for creating reports with photos, so now, with Adobe Acrobat 7, you can create a pdf file from Access report with OLE objects and add them as photos into it. It is great for organizations that want to create and distribute product descriptions and create them in MS Access. They first create the product description as a report and then export it to Adobe Acrobat converting them to pdf files.

There are two ways to generate pdf report in Adobe. It installs the Adobe menu in MS Access main menu, where you will be able to find a feature to create report as an Adobe pdf. But, first you have to open the report. This menu function can also be used to create a report and then email it somebody else. Just this feature alone is worth the money you pay for the applications.

The second way is to open report and then in File menu choose Print. In the Print dialogue window you will be able to choose Adobe Acrobat as the printer and click ok. It will open Adobe and generate your report to pdf.

Many people also wonder if it is possible to make the feature of emailing reports automatic, so that the reports would be sent once a month, for example. It is surely possible, but you will have to leave your Access running on your computer and ask a developer to write a code that will act like a timer. So, when the time comes, the report will be created and emailed. It might seem difficult, but not for skilled developers.

The industry of computers and computer applications expands all the time. But you can turn this issue into your strong point by catching up with this knowledge and becoming a pro, for example in microsoft access database sphere.

Please visit this web site that specifies in microsoft access database topic and has a nice line of microsoft access database products available.

10 Fast And Easy Ways To Speed Up Your Pc!

January 03, 2010 By: lilybird Category: Hardware

Many individuals are interested in creating the foremost of their hardware. Therefore here are ten straightforward tips on how to make your Windows XP pc run faster while not having to purchase further hardware.

1. Defrag Disk to Speed Up Access to Information

One amongst the factors that slow the performance of the computer is disk fragmentation. When files are fragmented, the computer must search the hard disk when the file is opened to piece it back together. To speed up the response time, you ought to monthly run Disk Defragmenter, a Windows utility that defrags and consolidates fragmented files for quicker laptop response.

* Follow Start > All Programs > Accessories > System Tools > Disk Defragmenter
* Click the drives you would like to defrag and click on Analyze
* Click Defragment

2. Detect and Repair Disk Errors

Over time, your onerous disk develops unhealthy sectors. Dangerous sectors hamper onerous disk performance and sometimes make knowledge writing troublesome or even impossible. To detect and repair disk errors, Windows features a built-in tool referred to as the Error Checking utility. It’ll search the exhausting disk for unhealthy sectors and system errors and repair them for faster performance.

* Follow Start > My Laptop
* In My Pc right-click the laborious disk you want to scan and click on Properties
* Click the Tools tab
* Click Check Now
* Select the Scan for and attempt recovery of unhealthy sectors check box
* Click Begin

3. Disable Indexing Services

Indexing Services may be a very little application that uses a lot of CPU. By indexing and updating lists of all the files on the pc, it helps you to try to to a look for one thing faster because it scans the index list. But if you know where your files are, you’ll be able to disable this system service. It won’t do any damage to you machine, whether you search typically or not terribly often.

* Head to Begin
* Click Settings
* Click Management Panel
* Double-click Add/Remove Programs
* Click the Add/Remove Window Elements
* Uncheck the Indexing services
* Click Next

4. Optimize Show Settings

Windows XP is a looker. But it prices you system resources that are used to show all the visual items and effects. Windows appearance fine if you disable most of the settings and leave the subsequent:

* Show shadows beneath menus
* Show shadows under mouse pointer
* Show translucent selection rectangle
* Use drop shadows for icons labels on the desktop
* Use visual styles on windows and buttons

6. Disable Performance Counters

Windows XP incorporates a performance monitor utility that monitors many areas of your PC’s performance. These utilities take up system resources thus disabling may be a sensible idea.

* Download and install the Extensible Performance Counter List (http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/exctrlst-o.asp)
* Then select each counter in turn within the ‘Extensible performance counters’ window and clear the ‘performance counters enabled’ checkbox at the underside button below

7. Optimize Your Pagefile

You’ll be able to optimize your pagefile. Setting a fixed size to your pagefile saves the operating system from the requirement to resize the pagefile.

* Right click on My Computer and select Properties
* Select the Advanced tab
* Underneath Performance select the Settings button
* Select the Advanced tab again and under Virtual Memory select Amendment

* Highlight the drive containing your page file and build the initial Size of the file the identical as the Maximum Size of the file.

8. Take away Fonts for Speed

Fonts, particularly TrueType fonts, use quite a little bit of system resources. For optimal performance, trim your fonts down to only those who you need to use on a daily basis and fonts that applications may require.

* Open Management Panel
* Open Fonts folder
* Move fonts you don’t would like to a temporary directory (e.g. C:\FONTBKUP?) just in case you would like or want to bring some of them back. The more fonts you uninstall, the more system resources you will gain.

9. Use a Flash Memory to Boost Performance

To improve performance, you need to install extra RAM memory. It’ll allow you to boot your OS much quicker and run several applications and access knowledge quicker. There is no easiest and a lot of technically elegant means to do it than use eBoostr (http://www.eboostr.com).

eBoostr is a very little program that permits you to improve a performance of any computer, powered by Windows XP in abundant the same means as Vista’s ReadyBoost. With eBoostr, if you have got a flash drive, like a USB flash thumb drive or an SD card, you can use it to make your laptop run better. Merely plug in a flash drive through a USB socket and Windows XP can use eBoostr to utilize the flash memory to boost performance.

The merchandise shows the best results for frequently used applications and information, which becomes a nice feature for folks who are using office programs, graphics applications or developer tools. It’ll surely attract a special attention of laptop homeowners as laptop upgrade is typically a lot of complicated and laptop onerous drives are by definition slower than those of desktops.

10. Perform a Boot Defragment

There’s a easy manner to speed up XP startup: create your system do a boot defragment, which can place all the boot files next to 1 another on your hard disk. When boot files are in close proximity to 1 another, your system will begin faster.

On most systems, boot defragment ought to be enabled by default, but it may not be on yours, or it would possibly are changed inadvertently. To create positive that boot defragment is enabled:

* Run the Registry Editor
* Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Dfrg\BootOptimizeFunction
* Set the Enable string price to Y if it’s not already set to Y.
* Exit the Registry
* Reboot

To get an amazing NDS/NDSL Flashcards device, visit this site: r4. The r4 cartridge is the current top-of-the-line in DS SLOT-1 flash carts. Get it now… r4: Revolution for DS!