Hello All, i'm currently looking into how to create a SCCM WQL Script to Delete machines from the SCCM Database more than 30 days? Ive currently found a way to locate machines in SCCM & AD Which are older than 30 days, an example of this script is below: select SMS_R_System.ResourceId, SMS_R_System...

Hello all, my website's forums built on asp.net give me a problem recently. When new users add a new post, the post does not contain the user's id and it gives an error on the website. Now, I have identified the 2 posts that give me the error. Both have as user id=0 This is the mistake. When...

Hi experts, I'm using SQL 2008 64bit version (developer edition). When I create new query from SQL Server Management Studio, I was able to run SELECT query, the query return 40.000 records. SELECT * FROM MyTable WHERE MyTableId = 60 Then I tried to execute delete command DELETE MyTable WHERE MyTableId...

I'm working on an Database created by a former co-worker which links data from a dbase 5.0 database with Access 2000. The dbase data needs to be deleted from within Access and my former managed to accomplish this in Access 97 using a delete query but with the upgrade to 2000 it now fails. The error...

I have a DB that on the form has a button on it labled "Undo Record" and when i open the for in design view and go to properties of that button it is mapped to an even proceedure as follows. Private Sub Command157_Click() On Error GoTo Err_Command157_Click DoCmd.DoMenuItem acFormBar, acEditMenu...

MS Access 2000 I am trying to delete all the records from a recordset. I've tried scrolling through using ADO and deleting each record individually... here's the code: ***** strKeyQry = "SELECT tblMaster.ContactID, tblTemp.ContactID, tblMASTER.Flag, tblMASTER.[Email] " & _ "FROM...

I'm trying to use the code below to delete a query in MSAccess and it fails on the last line. Dim dbConn As New ADODB.Connection dbConn.Open(CONN) Dim Cat1 As New ADOX.Catalog Cat1.let_ActiveConnection(dbConn) Dim View1 As ADOX.View = Cat1.Views.Item("Query1") Cat1.Views.Delete(View1)

I have MS Access 2003 installed and have been using it on a new computer for the last month. Everything was working fine until yesterday when I tried to delete an object (form, report, macro, any object) from the main menu... I can't delete anything from the UI: the delete button is greyed out, and...

Hello I have an Excel 2003 issue. I want to delete rows based on a criteria. The criteria being that any row which has a number greater than zero in Column D (e.g.). The tricky part is, I want to do this as part of a macro. So basically, if the spreadsheet has 200 rows and only 100 of those rows have...

Windows CE- need to create a dos routine that will run in the autoexec.bat file. This routine needs to simply scan a preset directory for files older than (current date minus XX days) and delete those files. nothing else. simple.