Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Lehtoant

    Customer Satisfaction???

    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...
  2. Lehtoant

    Excel 97 query

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

    Queries and storing variables

    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
  4. Lehtoant

    Where did this drive mapping come from?

    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"...
  5. Lehtoant

    data warehousing

    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...
  6. Lehtoant

    Query Printing

    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...
  7. Lehtoant

    Drive Mappings Ghosting

    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...
  8. Lehtoant

    See who is logged on your database

    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...
  9. Lehtoant

    File Date Function

    <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
  10. Lehtoant

    Refreshing Querytables in Excel

    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>...
  11. Lehtoant

    skipping over certain cells in Excel 97

    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
  12. Lehtoant

    Can i make the option group "frame" invisible?

    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
  13. Lehtoant

    Read a text file automatically

    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...
  14. Lehtoant

    Problems with Dmax-Dmin

    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...
  15. Lehtoant

    locking all fields on a form based on a field

    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
  16. Lehtoant

    Data type error when using datediff

    Shouldn't your criteria be like &lt;-1 cause the difference is negative for future dates? And respectively &gt;120 for older than 4 months. I also use now() function in DateDiff to find out the present date.<br> DiffInDays: DateDiff(&quot;d&quot;;[transdate];Now())<br> <br> Al
  17. Lehtoant

    copying the previous record into a new record with a hot key

    No coding, just press CTRL+APOSTROPHE (')<br> <br> Al
  18. Lehtoant

    Default values for fields

    You can use also add Dlookup function into QuantityWanted field's Default Value property to get the default quantity:<br> <br> Something like =Dlookup(&quot;[YourDefaultQuatityField]&quot...
  19. Lehtoant

    Major Brain Fart! -need help me with a time expression in a query

    You're already halfway there, but here's the whole procedure:<br> 1. Make a query based on calllogs table<br> 2. Include all fields needed including your dateReported<br> 3. Go to next empty column and type this formula on the first (Field:) row <br> DiffInHrs...
  20. Lehtoant

    Queries and storing variables

    If you just want to use results of a query as criteria of the next one, try nested queries. Use SELECT clauses as criterias:<br> <br> SELECT Field1, Field2 FROM Table2<br> WHERE Table2.Field1 IN (SELECT Table1.Field1 FROM Table1 WHERE Field1 LIKE 'Something')<br> <br> Be careful with huge data...

Part and Inventory Search

Back
Top