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

    xp_cmdshell run wave file

    I am using SQL Express(2005) I have a visual basic script that plays a wave file when executed. I have tried to call this script using the following: exec xp_cmdshell 'C:\AIRRAID.VBS' It seems to execute ok and returns a null in output but the wave file does not play. When the script is...
  2. JeffAlton

    View SQL SELECT statement from form click

    I want to view the results of an SQL SELECT statement that is in the code section of a form. How do I do this?
  3. JeffAlton

    delete file system files less than 5000K

    I have a form that I want to be able to press a button and delete all Excel files from a certain directory that are less than 5000k in size.
  4. JeffAlton

    Slow Code Problem Exporting to Excel

    Thank You Very Much.
  5. JeffAlton

    Slow Code Problem Exporting to Excel

    The filter seems to be working. I can see the query as it loops. Before I added the last line to close the query their were 65 records filtered in the query. I tried to export from the menu bar and still got 2659 records in my spreadsheet. Sub ExportData2() Dim db As DAO.Database Dim...
  6. JeffAlton

    Slow Code Problem Exporting to Excel

    Runs alot faster but all of the spreadsheets contain all of the records from the table.
  7. JeffAlton

    Slow Code Problem Exporting to Excel

    I am getting an error: the action or method requires a table name argument And the debugger goes to this Line: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, qryOutput, DestDir & FileName I have created the query.
  8. JeffAlton

    Slow Code Problem Exporting to Excel

    I have recently replace queries and lines of code like the following DoCmd.OutputTo acQuery, "L001", "MicrosoftExcel(*.xls)", "\\ntoscar\t-drive\Accounting\UPS\Store Billings\" & Format(Date, "YYYY") & "\" & Format(Date, "MMM") & "\" & Format(Date, "YYMM") & "UPS-L001.XLS", False, "" with...
  9. JeffAlton

    range selection based on text value

    I need to select a range based on the text in cells. For example if I have five cells in a columm that have "Oregon" in them I want to be able to select all five with a macro.
  10. JeffAlton

    Need to Check if ID Already Exists

    I have an access form for adding new vendors. The vendor number is not autonumber it is just a text box. When adding new vendors I get errors if the ID already exists. How can I Check after update of the text box if the ID already exists in the source table?
  11. JeffAlton

    Excel Pivot Table Sorting

    I have an Excel Spreadsheet with a pivot table that is linked to an Access database that keeps track of which databases users enter and how long they have each one open. The problem that I have is when users switch databases the information shows up wherever it wants in the pivot table rows...
  12. JeffAlton

    Returning values “greater than” question.

    I'm not following what the form is used for besides criteria for your query. Does your user set the values for the two fields in each record? For instance would they set the first box to 5 and the second one to 1 for John and then move to the next record for Brad and set them 3 and 4, and then...
  13. JeffAlton

    Returning values “greater than” question.

    If I understand correctly by adding Or is Null should return what you want. Criteria for Score Type 1 >([Forms]![Rpt_Form]![Score Type 1]-0.01) Or Is Null Criteria for Score Type 2 >([Forms]![Rpt_Form]![Score Type 2]-0.01) Or Is Null
  14. JeffAlton

    Returning values “greater than” question.

    Where is the source of the test scores? Are they in seperate fields in a table?
  15. JeffAlton

    Field Calculations

    =Format([Dateto],"yyyy")+([years]+1)
  16. JeffAlton

    Zip and Email

    This will zip your mdb file. First download the winzip command prompt file at http://www.winzip.com/wzcline.htm This assumes that winzip is installed on drive C: under program files\winzip and that the mdb file that you want zipped is in C:\databases by itself. It will create a zip file named...
  17. JeffAlton

    Zip and Email

    Zipping open database is not a good idea. When any changes are made during zip process corrupt files are the result. Especially if you are trying to zip this from a macro or VBA code. Best recommendation is to install winzip, close database, locate using windows explorer, right click on .mdb...
  18. JeffAlton

    design button is greyed in forms

    Keep the shift key pressed when opening the database. Then check the references by opening some VBA code e.g. by opening a module. Check for libraries with a name starting with "MISSING" and uncheck these. When necessary replace such a library with a newer/older version.
  19. JeffAlton

    Event other than BeforeUpdate

    I am assuming that chkAdjust is a checkbox linked to a yes/no field in a table or query. I am also assuming that optWho is an option group linked to a number field in a table or query. and also that if the check box is checked one of the options in the option group also needs to be selected. if...
  20. JeffAlton

    Insert Animation

    Animation In Access - Using animated GIF's faq181-108 Animated GIF's in Access You will need an ActiveX control for this. Go to this location: ftp://ftp.simtel.net/pub/simtelnet/win95/graphics/ Scroll down through the list and download: agv10.zip This zip file will contain 3 files. The...

Part and Inventory Search

Back
Top