Recent content by Lehtoant

Hello Matt, My view has both pros and cons. We are using PowerPlay (Windows-client, Excel-client and web-based Upfront) Pros: - great analysis tool if you have TIME to analyze (I'm short!) - new Excel-client (Navigator) is very useful Cons: - providing relevant content takes time and work, as...

Remember to add the last parameter 0 to get exact match (=v/hlookup(<cell with 24 in it>,<table>,2,0) Al

Hi, Do you want 9 between 10 and 11??? If you convert your week# to integer then you have much more power to sort it anyway you want. Week: CInt(YourCurrentFormatFunction) Al

There's a discussion of mapping problems in:<br>Top &gt; Desktop Software &gt; PC Operating Systems &gt; Microsoft: NT Workstation Forum<br>Drive Mappings Ghosting<br><br><A HREF="http://www.tek-tips.com/gviewthread.cfm/lev2/67/lev3/70/pid/621/qid/6434"...

Dw provides uniformity and perspective. Separate datamarts and OLAP reporting systems tend to give snapshots of current situation (life cycle of these systems is normally shorter). Decision makers like to compare things over time and between different business units and so on. This also means...

When printing query or table grid should be there. In File/Page Setup you can choose 'Print Headings' but for me it didn't do anything. In report's Page Setup there's 'Print Data Only' which drops headings.<br> <br> Are your field headings showing up both in preview and on paper?<br> <br> And...

Several reasons: FastFind, UNC vs. drive letters..<br> Check:<br> <A HREF="http://support.microsoft.com/support/kb/articles/Q150/6/04.ASP?LNG=ENG&SA=ALLKB&FR=0" TARGET="_new">http://support.microsoft.com/support/kb/articles/Q150/6/04.ASP?LNG=ENG&SA=ALLKB&FR=0</A><br> <br> Changing shortcuts to...

Dumboy's suggestion (the macro one) could be implemented by using form's On Timer event. If admininstrator wanted people out, he/she would open the database and set certain variable or table field value true or false. On Timer would constantly check this value and if true the pop-up window would...

<br> Use function:<br> FileDateTime(&quot;PathAndFilename&quot;)<br> <br> You can use this in VBA code or directly as Control Source of a form/report field. <br> <br> Good luck,<br> Al

Sorry, no tips cause my refresh macro fine. Do you mean that you need two separate codes to first retrieve data and then manipulate it?<br> <br> I take data from SQL Server through ODBC-driver. My code (recorded) is like this: <br> With ActiveSheet.QueryTables.Add(Connection......<br> ....<br>...

Have tried actually merging unused cells to one big cell? (Format/Cells/Align/Merge Cells) This Excel97 feature is very useful when designing forms and other layouts.<br> <br> Al

Open Option Group's properties and change Border Style from Solid to Transparent or select Transparent from Line/Border Color button (Formatting-toolbar).<br> <br> Al

Question 1:<br> <br> Are you sure that no one has that text file open? Usually when I get this error I'm the one to blame.<br> <br> For your question 2:<br> <br> You can view and modify existing specs as Doug described: File/Get External Data/Import, selct file and start wizard...

Sounds tricky and my solution helps you only to find the right results (integrating them to form or report is tricky as well)<br> <br> Make two nested SQL queries, first one flips your three fields as rows and the second calculates the difference (like in Excel). I'm assuming that you have some...

If you want to keep the fields locked when users are just browsing the records, place the code as well into form's OnCurrent property. It runs every time when user moves between records. OnOpen or OnLoad does the trick only once for the first record.<br> <br> Al