Search results for query: *

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

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?

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.

Thank You Very Much.

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

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

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.

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

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.

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?

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

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

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

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

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

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

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

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.

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

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