Search results for query: *

I wrote this little script to change all of a schema's tables to 'dbo' but when it runs into a table that already has a 'dbo' version, it locks up my entire database until I kill the process. Is there an easier way to acheive this? DECLARE @dbusername VARCHAR(255) DECLARE @tablename...

Alt+F11 does nothing in Outook 2003, nor does Tools > Macros and any of the options (Security, Macors, VBE). It works as normal in other Office 2003 apps. Is this something I need to beat up my network admin about? Is it a registry tweak? TIA The early bird gets the worm, but the second...

What's the easiest way to set a range to variable rows? Rather than: Set xlRng = Rows("1:4") I need it to be dynamic: iStartRow = 1 iEndRow = 4 Set xlRng = Rows(iStartRow:iEndRow) Thanks! The early bird gets the worm, but the second mouse gets the cheese.

Similar to thread782-965562 , I'm using IIS 6.0, Windows 2003 SP1, and CE version 9 (a limitation of our application.) Everything else is fine, but once the first report comes back 'Page Not Found' then the only way to get CE back up is restarting. Our software vendor hasn't been much help...

This is the relevant part of my code that creates the button and action: Set oVal = oOpt.Controls.Add(Type:=msoControlButton) oVal.Visible = True oVal.Caption = oRS.Fields("schName").Value oVal.OnAction = "LoadReport(""" & oRS.Fields("schName").Value & """)"...

I have this in a stored procedure. With the comments, I get a balance of -59.56. When I remove the comments, the toal becomes 0.00. One of the rows (hppty=9) only appears when select the hppty field, it doesn't add up in the sum otherwise. Any ideas? SELECT SUM(sBegin) + SUM(sMTD)...

I found nothing but this unresolved thread after 20 minutes of searching for an answer: thread961-806733 I would simply like the DTS package to know what server it is on, and be able to assign that to the dynamic properties of the SQL server connection. I could make a table that is the same...

I want to store all of my actions for my command buttons in a table, so when a form is loaded, the actions are loaded from the table. The buttons that open new forms (form navigation) was easily accomplished with this code (where menAction value of 1 is open form and 2 is run code): Dim...

I would like to get my query that outputs: 1 1 2 2 2 3 4 To look like: 1 1 2 2 2 3 4 I was thinking I could use: SELECT ' ' INTO #temp [MySelectStatementHere] FROM [MyTable] CROSS JOIN #temp But of course that doesn't work. My limitations are I can not use Cursors or Update statements...

I was given the mission of completely integrating CVS Version Control (like SourceSafe) with our MS Access Database App (2K version). The solution I came up with was to run this code after making any changes to the application. Is there anything I'm missing ... is there an easier way? Option...

I am trying to import data from a Sybase database into SQL server for a list of 400 account numbers (this list can not be derived form the Sybase database). I constructed an ActiveX script to create this list and use it to create the SQL for the datapump but it only holds the first 264...

In SQL server 2000 I am pulling data from a Sybase database through DTS. I also have a text file with ~300 account numbers. These are the two connections on the DTS package. I would like to only pull the data for those accounts. In other words "only pull the account data for the accounts...

I'm working with CR10 with OLE to SQL2K... I have a report pulling maximum noteID for each Invoice as a summary field (for I need the detail to make calcs on the invoice line detail). The report is grouped by invoice. I would like for it to return the text of the maximum (most current) ID...

My first week in Crystal formulas (sorry for the lack of braces ... i'm a VB guy) I am trying to get the lines on this invoice to create a month description in this fashion: The first set of lines displays the description of the next month (a 10/1/05 invoice will display "November 2005") When...

I'm trying to complete a function that will create a report of any differences between two versions of the same database in terms of table structure. It will report new or discontinued tables, and for tables that remain it will compare the tables field by field to make sure the fields and data...

I'd like to create a function that will automatically burn a file to a CD ... like ...I've seen the .NET code and XPBurnComponet.dll but was hoping someone had a simpler approach. Function BurnToCD (strFile as String) as Boolean On Error goto ProcErr Dim objFSO as Object Dim objFile as Object...

It is possible to open an Access Report in Preview mode, choose Print and then select Print to File. I need to automate this in a VBA module and the process of naming the .prn file, but can't find it in Docmd.OpenReport, Docmd.PrintOut, or Docmd.RunCommand acCmdPrint. I hope there is a better...

Ring any bells? Stops client VFP users from connecting to server database. The early bird gets the worm, but the second mouse gets the cheese.

I get an error "can't delete registry key" when running. I can delete it manually. '--------------Main Function---------------- Dim FSo, logFile, objCmd, path, fileName Set FSO = CreateObject("scripting.FileSystemObject") Set WshShell = CreateObject("WScript.Shell") 'Create Log File and...

I have a vbs script trying to alter a boolean field in a FP 8.0 table. At the line: Set oRS = oConn.Execute("UPDATE cus SET cusacco = .T. WHERE cusky = """ & cusky & """ I get the above error. I know cusky is valid because i use it in another query, so it must be the dang boolean. I am...