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 Rhinorhino 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: *

  • Users: diwin
  • Content: Threads
  • Order by date
  1. diwin

    output command results in file deletion instead

    I have the following line in a module in access 2010. It was originally written in access 2003. DoCmd.OutputTo acQuery, "qryOutputForGIS", "MicrosoftExcelBiff8(*.xls)", sPath, False, "", 0 But now, instead of outputting the query, it deletes the destination file. Any ideas? Daniel Dillon O...
  2. diwin

    find and rename files

    I need to find and rename all .JPG files to .jpg in a folder with subfolders. How would I go about this? Daniel Dillon O o . (<--- brain shrinking at rate shown.)
  3. diwin

    How to tell when bound form is on last record

    I have created nav buttons on a bound form. I would like to disable the "next" button when on the last record. How do I know when that is true? Daniel Dillon O o . (<--- brain shrinking at rate shown.)
  4. diwin

    Display images on a continuous form that lists jpgs in a folder.

    I have to rename a couple thousand pics, so I created a form for this. In it there is a subform in continuous view that displays the names of the image files (from a table). I also want to show a thumbnail of each. So far, I get the same pic in all records and it changes when selecting another...
  5. diwin

    Tab up and down bound datasheet

    I have a data entry form with a subform bound to a (temporary) table. Default Tab and Enter behavior moves focus one field to the right. Default Shift-Tab moves focus one to the left. The code below is my attempt to force those defaults to move up and down one record in same column instead...
  6. diwin

    format time as decimal

    I have a short time field in a table. Is it possible to display 10:30 AM as 10.5 and 10:30 PM as 22.5? Daniel Dillon O o . (<--- brain shrinking at rate shown.)
  7. diwin

    replacement for MS Access??

    I currently code ASP and VBA. I have used Access and DAO to make my databases and Storefront 5.0 shopping cart from LaGarde thus far. I drew the line at DotNet and decided to stay with classic ASP, but now I am getting frustrated. In my view, PHP has taken off, even over ASP.Net. I have...
  8. diwin

    Get records from online database

    I am fairly strong in coding VBA and ASP. I have an ASP e-com site using Access and an offline Access database for managing orders, inventory, etc. which is based on the online database, but deviates a bit with respect to table structure. When an order is placed online, we get an email with a...
  9. diwin

    'Report Grouping' and 'Hide Duplicates' Stumper

    This is a re-post of an unresolved problem. I hope this is a better explanation. I am so stuck! I have developed an Access database for a colleaque to store scientific sample data. My contract finishes in a week and the database is done, except for a critical part of the project. My problem...
  10. diwin

    hide duplicates for same subset of data

    Can I control Hide duplicates in code? I have created a query with a few inner joins for a report recordsource. Main table has Sites Secondary table has Points Tertiary table has Bugs Quarternary table has LifeStages This results in each LifeStage producing its own record in the report in...
  11. diwin

    ignore conditions in a query

    Can I put a condition on these conditions??? The red conditions below only apply when there is 1 or more records in the associated table ( tblPickYearSeason or tblPickBugStage). If either or both of the named tables is/are empty, the condition(s) should be ignored and allow all records to be...
  12. diwin

    can't open recordset based on UNION query

    Set rs = db.OpenRecordset("qryCheckMainFBI3", DB_OPEN_DYNASET) Why does this line in frmSite cause... run-time error '3061': too few paramaters. Expect 3.??? qryCheckMainFBI1 SELECT qryFillTempTables.SiteCode, qryFillTempTables.ID, tblTempYear.YearListID AS CheckYear...
  13. diwin

    comparison misses empty strings

    Hi. I am trying to compare the fields of a record that has been added to an "order" with the analogous fields in the source data table that the ordering process draws them from. This way, I can recognize when one "order" has been created with a different version of the data in the source data...
  14. diwin

    reading the previous record in a report.

    Can you apply conditional formatting on one field in a report based on the value of a field in the previous record? Daniel Dillon O o . (<--- brain shrinking at rate shown.)
  15. diwin

    Code error for non-executing line inside If...Then !!??

    In one subform, the following code is part of the OnCurrent sub and makes another subform update. It works fine all the time, except when the first subform is sorted by hitting 'A-Z' and then I select a record that has subordinate data that would be displayed in the second subform, but not when...
  16. diwin

    Stumped by Complex Query/Filter

    I have backed myself into a corner. I am creating a database that holds data on 'Bugs'/'Life Stages' collected in particular 'Years'/'Seasons' at specific 'Sites'. So I have a form that allows the user to choose Year/Season combinations AND/OR Bug/Stage combinations AND/OR specific Sites to...
  17. diwin

    complex report to excel

    I have a report with a couple of nested subreports, so the subreport data is nicely indented in the output. Can I export that nice page layout to an excel spreadsheet? Daniel Dillon O o . (<--- brain shrinking at rate shown.)
  18. diwin

    ASP.NET learning curve

    Expert opinions sought. I have a new job in a small staffing company that has no digital system for managing their obviously highly information-dependent business process. Because a lot of the jobs we staff are short term and short notice, info changes a lot. My non-tech-savvy entrepreneurial...
  19. diwin

    pubs database not installing for newbie

    I am new to this stuff. Where am I going wrong? I successfully installed MSDE for use with VS.net 2003 using... Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=mycurrentadminpw However, I cannot install the pubs database. When I use the following command, there is a delay...
  20. diwin

    install IIS sp1 over WinXP sp2

    I have Windows XP SP2 running and now I want to install IIS from the installation disk. Since this is SP1, it asks me to insert the Windows XP SP2 disk in to install. I never had one. Is there a way around this? Daniel Dillon O o . (<--- brain shrinking at rate shown.)

Part and Inventory Search

Back
Top