Search results for query: *

It took me ages to figure this one so I said i would share. Just a note its much better to avoid using sql directly from asp e.g. “select * from table 1 where name =’” & name & ‘” or “insert into table1 (name) values (‘” & name & “’). User Stored procedures and parameters Problem When passing a...

I deployed the site to Test Web Server 2003 IIS 6.0. However when I try open excel through the web page I get this (in event viewer). Note all works fine on development machine. "The machine-default permission settings do not grant Local Activation permission for the COM Server application with...

I have a webpage with a filter invoked by a javascript function - <script type="text/javascript"> <!-- var theForm = document.forms['form1']; if (!theForm) { theForm = document.form1; } function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() !=...

I have a webpage with a filter invoked by a javascript function - <script type="text/javascript"> <!-- var theForm = document.forms['form1']; if (!theForm) { theForm = document.form1; } function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() !=...

If a session value is true how to disable the entire delete button on the gridview. e.g. If session("AllowDeletes") = false then me.gridview1.Allowdelete = false End if Thanks!

Hi, I have an access program that 6 people use. However when 2 users open a form and click on a column and sort it sorts fine but when they close the form access crashes and asks to "send or don’t send" standard Microsoft reporting error. It works fine on the other 4 PCs. I reinstalled access...

Hi, If I try a simple updated e.g. update referrals set notes = '' I get the following error Msg 121, Level 15, State 1 The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns. If I try a similar...

If using an Microsoft Access frontend linked to SQL backend and in the event that the SQL server is down the user would like to look at the data (or as close to the current data as possible). Solution - Create a DTS package in SQL scheduled to run daily exporting the information to a local...

Hi, Have a webpage that 5% of the time the text and text box overlaps and the user needs to hit F5, which refreshes the page and rectifies the problem. Has anyone come across this problem and a possible fix? Help appreciated, T111!

I got a database and cannot view the database window. When opened it displays a switchboard window. I tried to hold down F11 but nothing happens. I tried to import to a new database but its password protected(and I don't know the password). Can anyone tell me how to turn off compact and repair...

Hi, I have a VB.Net program that copies files from one directory to another and a status strip bar along the bottom that displays the current file name being copied. Works fine until I click on a different window (e.g. open explorer) and then return back to my program. It hits a lag screen and...

I need to get this function out of excel and into ASP.Net(VB). Anyone know how to do it? Thanks, T111!

Hi, I have a user who is unable to delete a comment. Even when they open a new spreadsheet they are allowed to Insert/Edit a comment but the "Delete comment" button is visible but disabled. Does anyone know the code to put back in this functionality? Thanks, T111!

format("THEDATE", "dd/MMM/yyyy") e.g. 01/feb/2008

Hi, I got a program working to send mail through exchange servers on a windows 2000 server - http://msdn2.microsoft.com/en-us/library/aa562998.aspx. However when I went to the customer site they use Novell 6.5 and GroupWise 6.5 and they have an SMTP server but the program crashes out. Help...

Hi, The code below sends the email to the outbox folder in outlook which in turn sends the email automatically. Is there any way of sending the email to the drafts folder which will allow the user to revise the email before its send. Set out = CreateObject("Outlook.Application") Set...

Hi, I need to export an access report with an image. I got the report out to snapshot but as you may know most people who try to preview snapshot are prompted for the installation disk. The other alternative is to export to PDF. I have it working for Adobe acrobat 7.0 pro perfectly but they...

I have customers that can use up to 5 products. I have 5 tick boxes and each product being used by the customer will have a tick box alongside it. I need to print a report with the products that they use and not to display any products they don’t use e.g. Customer A uses Product X and Product Y...

Have a program that 1 - converts a EXCEL to a text file using vb.net, if no excel file exists then it creates an empty text file with correct name - current date and time. So my VB program first Shell's the vb.net program. A special shell that waits for the process to end before proceeding. 2 –...

I have to ftp files to a location, but the user wants me to be sure I have exclusive rights to the folder. A dummy file exists called Test.txt. If I can open that file for input then I have exclusive rights to the folder. I tried to open it as follows Dim FilePath5, strbuffer As String...