Microsoft Access - Not as easy as it Seems

Beginners who use Microsoft Access face some problems in recognizing the variation between Me Refresh and Me Requery. So let's have a look on the points of differentiation among these two branches.

Smaller Aspect:
Well both the aspects whether it's Refresh and Requery keeps the alteration done in the current record, though…
Me Requery drags all the updated data from the basic table or problem, with fresh add ups and removals.

Best online Microsoft MCTS Training, Microsoft MCITP Certification at certkingdom.com

Me Refresh just renew the data in the updated form, yet it will not explain the new or erased data.

The Longer description:

Me Requery compel the full record set (essential data) for the things to stock up. It means that all the data in one's updated form will refilled. If one's recent position is misplaced and supposedly one is situated on the record of 10 to 100 than one will find him/herself at the starting position. Basically Me Requery is almost same as its closing and renewing process is alike. Records added by the coexisting users are also available. Similarly records earlier deleted will start appearing. Requery initially start "replay the problem" that dragged the folder into its original place. It can also be used to refresh the folder in a list box or combo box.

Me Refresh keep the present data that one is using. Through it one can extract the changes made to the current records except the add ups or removal done to it. Any estimation done on the liberated fields will be redone. Record set will not be refilled by the refresh. During this one do not lost its position on the current record. Recent data added by the coexisting users could not be seen.

While opening another form or mainly a data on the updated form one should give the Me refresh command. Usually it's done to create a statement in tutorials based on the recent direction. Me Refresh is used to save the information contains in the table to make sure it prints correctly. Well one doesn't want to use the requery because it will put the user to its initial position which nobody wants.

The two other branches which mostly people gets confused with Refresh and Requery are: Repaint and Recalc.
The command of Repaint redid the current form and all its contents on the monitor. It's very useful when the statistics are running the liberated fields with the help of timers and in long time rounds. In the middle of an event when you want something to appear on the screen from time to time so that the user wouldn't be sitting ideally. The most important thing is that Repaint does not affect the information.

Re-evaluation in the form can be done by giving the command the MeRecalc. For instance, if one is presenting the terms like Unit cost in a text envelope and it's refusing from getting updated then Me Recalc can be used to update the information.

Microsoft Dynamics GP: Recovering Failed Implementation Notes

Your Microsoft Dynamics GP (Microsoft Great Plains, Great Plains Dynamics or Great Plains Accounting for DOS, Windows or Macintosh), not successful implementation story might be not unique. GP is mid-market Corporate ERP application, where industry expertise might be required, plus profound technical exposure for your chosen Dynamics GP Partner. Of course, if you are insisting on coming through quick Sales cycle, there is often a temptation to sell you Dynamics GP software license and then "try our best" to help you with new Corporate ERP implementation. Again, in our opinion, cool down - you did the best you could (it is not something that you do every day - selecting new accounting system for your organization); and your Dynamics GP Consultants tried the best they could, but implementation failed and you have to move on, trying to preserve your investments into Microsoft Dynamics GP ERP application licenses. GP has huge number of implemented installations across the USA, Canada, Spanish Speaking South America, Caribbean, Oceania, Australia, New Zealand, South Africa, where most of the typical industries have implementation case. Look for second opinion in Great Plains implementation recovery:

Best online Microsoft MCTS Training, Microsoft MCITP Certification at certkingdom.com

1. Industry Expertise. It typically helps your Microsoft Dynamics GP Reseller to recommend proper set of modules, including Dynamics GP ISV add-ons, related to your industry. Plus your Dynamics GP VAR should have consultants in staff (or in good subcontracting relations), who are familiar with these modules business logic, data conversion, implementation steps and even aware about their restrictions and known issues. Industry expertise allows your chosen Great Plains consultant to build required reports in Report Writer, Crystal Report, recommend Microsoft Dexterity custom programming (to fill the gap in missing business logic)

2. Technology Expertise. Each midmarket Corporate ERP application has its tools and technology layers. In the case of Microsoft Dynamics GP you should be aware that your perspective Dynamics GP Partner has expertise in such technologies, as Great Plains Dexterity, Dynamics GP Integration Manager, Crystal Reports, SSRS (Microsoft SQL Server Reporting Services), eConnect SDK (especially when you are looking forward to integrate generic ecommerce website to Dynamics GP Sales Order Processing module). The list could be continued (Modifier with VBA, Advanced ODBC integrations, SQL direct scripting to GP, etc.), however we would not like to load you with additional concerns as in our opinion only required expertise should be demonstrated


3. Local versus Remote support. Local support for new Microsoft Dynamics GP implementation is definitely optimal, however it may not be available, especially when your office is located in rural or country side area. You may have local Dynamics GP practitioner available locally, but this consultant may only have basic installation and user training skills. Remote support is more challenging, as it requires your personnel to be familiar with new support technologies, such as web conferences, remote desktop support, VOIP and skype (especially in international scenarios). And at the same time, remote support opens for you access to real Dynamics GP gurus, who are familiar with your industry, have deepest technology exposure, have no problem with modifications, reporting, integrations, data migrations and conversions

4. How to find your rescuing Microsoft Dynamics GP implementation partner. We are in XXI century, where you could rely on internet search engines, such as google, yahoo or msn. Simply open your favorite search engine and type in your key words, something like: Dynamics GP Implementation Recovery, plus add your industry name and additional concerns. Several words about Alba Spectrum. We are serving Great Plains Dynamics GP community since 1994, plus we have top expertise in Great Plains Dexterity Source Code Programming (Dynamics GP Source Code Partner with Microsoft Business Solutions). We are specializing in ecommerce integration, warehouse management and barcodes, complex and challenging customizations, Dynamics GP reporting for multinational corporations (FRx, SAP Business One, 1S Bukhgalteria). Feel free to call us 1-866-528-0577, 1-630-961-5918 or email us help@albaspectrum.com

5. Additional tips on Great Plains upgrade. If you are looking for migration solution for really outdated version of Great Plains, something like Great Plains Dynamics on Pervasive SQL 2000 or Ctree or even older Great Plains Accounting for DOS, Windows and Mac, feel free to call us for instructions and the Quote. GPA to current versions of Microsoft Dynamics GP 11.0 or 10.0 requires multiple steps, plus to your information, Great Plains 6.0 and earlier on Pervasive SQL or Ctree in the case of deploying Intellisol Advanced Purchase Order Processing - you will have to come through applying migration tool to Great Plains Purchase Order

Absolute References Vs Relative References in Microsoft Excel

Microsoft Excel is built on a regime of Columns and Rows with the intersection of these two elements giving us our cells. The cells in Microsoft Excel are always named Columns and then Rows, so a typical cell address would look something like - AB256. This particular cell is found on column AB and in row 256. The reference I wrote there is very important as it tells me something significant, that is, it tells me the cell address is a relative cell address. So what does this mean? Well there are two types of references used in Microsoft Excel which is an Absolute Reference and a Relative Reference. On a day-to-day basis, the relative and absolute reference doesn't really affect the operations of your spreadsheet. Where it does become a noticeable issue is when you start copying formulas from one cell to another.

Best online Microsoft MCTS Training, Microsoft MCITP Certification at certkingdom.com

Lets investigate the difference between the two …

A Relative Reference is one that when copied from one position to another will adjust the formula cell address to suit the position it is in. For example if you have a formula in cell address C4 that was =B4*C1 and then copied the formula into say C5 what you will notice is that the cell addresses of the formula will change to =B5 * C2. The reason this has occurred is that the cell addresses are in fact relative addresses. That is the cell address is relative to its current position.

To change a cell address from being relative to being absolute we simply add dollars signs to the cell address in this way - $C$5. What this address is now saying to us is that we must absolutely refer to column C and absolutely refer to Row 5. This means that if we apply the dollar symbols to our previous formula in cell C4 which is =$B$4 * $C$4 and then copy our formula to cell address C5 you will notice this time round that the cell addresses didn't change. The reason is that by adding the $ symbols to the cell address we are telling the formula that regardless of where you place the formula you must absolutely refer to Column B and Row four thus we have $B$4.


There are many reasons why you may use Relative References over Absolute references and vice versa. One of the most common one for using absolute references is when you have a specific value you want to refer to in a formula. For example, lets say you are building a mortgage calculator and you need to refer to an Interest Rate. To ensure you are always referring to the right cell that has the interest rate value you may set an absolute value.

In Microsoft Excel there is also a reference called a mixed reference. Essentially what this means is that only either the Column or the Row has the dollar symbol, for example $C3. What this is telling us is that in the formula you must absolutely refer to column C but the value in the row is relative to the position of the formula.

There are a number of ways that you can enter Relative and Absolute values into a formula. One technique is that you can simply type the $ symbols next to the Row or the Column. However there is an alternative. Once you have typed in the Cell address like C4 you can move back into the cell address and then use the F4 key to toggle the cell reference from Relative to Absolute to a Mixed References.

Absolute and relative references are extremely important in Microsoft Excel and they ensure that the formulas you are creating actually refer to the correct cells. Remember one simple rule, if the cell addresses have a $ symbol next to it, it means you must absolutely refer to either the column or the row.

Chris Le Roy has available Excel Shortcuts to help you with Microsoft Excel. To get a Certificate in using Microsoft Excel in just 16 hours, simply check out Chris's correspondence course where you can earn yourself Microsoft Excel Certificates issued by his company without evening leaving home - Excel Tutorials . Excel Paystub Template are also Available.