Search results for query: *

I'm new to Actuate and want to be able to allow the user to select all or an individual product from the dropdown parameter box and filter the query accordingly Any help would be appreciated Angie Angie www.millardconsulting.ca

I have a bookmark field that needs to be in currency format ie 25000 needs to be displayed as $25,000.00 I have tried {MERGEFIELD Amount \# "$,0.00; ($0.0)"} and that is not working. Any help would be appreciated Thanks Angie

I need to run an update statement to fill two new fields call minvalue and maxvalue (both floats) with values that are stored in a string field as "A $0.00 - $1000.00" So that the minvalue would be 0.00 and maxvalue would be 1000 Any help would be appreciated

I need to do a validation on a text box for the range from A to F plus characters ()-*/+ This is what I have tried function ValidFormula(obj){ var Formula = /^[a-fA-F][\-\(\)\*\/\+]$/ if (Formula.test(obj)) { alert("VALID Formula"); } else { alert("INVALID Formula"); } } Thanks in...

Hi I have used Response.ContentType = "application/vnd.ms-excel" to export to excel which worked ok for versions lower than 2007. Now some users are running 2007 and are receiving the error message "The file you are trying to open, is in a different format than specified by the file extension"...

I've added a photo using the shapes.addpicture method objWordApplication.Selection.Shapes.AddPicture(filename:=strFullName, LinkToFile:=False, SaveWithDocument:=True) but I want to display text aligned left underneath the photo showing the photo's name. I've tried using the insertafter and...

I am importing a number of photos in a word document. The photo's are a mix of portrait/landscape. I have some code to try and rotate the portrait ones but it doesn't seem to work can anyone help please. objWordApplication.Selection.InlineShapes.AddPicture(filename:=strFullName...

Hi I have an app that opens and inserts a photo into a word template. The problem is inserting the photo the photo resides on a storage device attached to the network. I'm using a mapped drive and I get an error message saying it is not a valid file name. this is the code Dim...

Hi I have a asp.net app that opens and inserts a photo into a word template. The problem is inserting the photo if I use 'C:\sunset.jpg' this works fine but if I use a mapped drive it doesn't. I get an error message saying it is not a valid file name. this is the code Dim...

I need to run a query over multiple databases and across servers. I'm using sp_addlinkedserver and sp_addlinkedsrvlogin and the code I'm using is below currently it's only bringing back the results from the server where the query resides and not the linked server how do I tell it which server...

I am trying to count the records on the same table but on different databases then I want to put it in another table and read the results from there. The code I have at the moment is this declare @cmd1 varchar(500) set @cmd1 = 'if ''?'' like ''abcd%'' Select ''?'', count(*) From tablename...

I need to update a date/time field with a number of hours held in another table(appconfig.apptime) I have tried this code but it errors about the other table. UPDATE customer SET appdate = dateadd(h,appconfig.apptime,getdate()) Thanks Angie

I have a database password set and I am using this code to compact and repair the database when it finishes it asks for the password again. Is there a way to get round that. CommandBars("Menu Bar"). _ Controls("Tools"). _ Controls("Database utilities"). _ Controls("Compact and repair...

Hi I'm running excel from access and I can run the spreadsheet once and it works fine the next time I run it I get runtime error 1004 method sheets of object _application failed and it debugs to this line of code Set ws = xl.Sheets(1) in this function Private Function FindLastRow() As...

I have an asp page that loads a jpg file and displays it, if however you choose the wrong one and reload a new one the new image is not being shown it still shows the old one. The only thing that seems to work is either a manual refresh or by changing the IE settings of Check For new versions...

I need to be able to add a user to a database and grant them permission to that database using SQLDMO.

I am adding a user to my database and grant them access using OSQL, no problem with adding user but this statement doesn't work, what am I doing wrong -E -d database -Q \EXEC sp_grantdbaccess \username,\userpwd\

I am trying to create a web project and get the following error The web server reported the following error when attempting to create or open the Web project located at the following URL: ‘http://localhost:8080/webapplication1’. ‘ A connection with the server could not be established’. I have...

I am trying to create a web project and get the following error The web server reported the following error when attempting to create or open the Web project located at the following URL: ‘http://localhost:8080/webapplication1’. ‘ A connection with the server could not be established’. I have...

I recently upgraded from XP Home SP1 to XP Pro SP2 since then on boot up I get your system has recovered from a serious error and this message BCCode : a BCP1 : 000181AA BCP2 : 00000002 BCP3 : 00000001 BCP4 : 804E2CC6 OSVer : 5_1_2600 SP : 2_0 Product : 256_1...