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.

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 have a Windows 2000 server network with about 70 users. Somehow file attributes are being changed to hidden. I have asked the users of these files if they changed them and receive no answers. The files being changed are mainly ".xls" and ".mdb". This wasn't much of a...