Search results for query: *

We have some macros that run silently via scheduled tasks in the evenings. Occasionally, these macros will error in some way and we want to log these errors. I've found code that I can run that will append the error number and text to a table that we can view as a log. However, I don't know how...

I have Microsoft Office 2007 Professional installed and have also installed the 2007 Access Developer Extensions which is supposed to put a "Developer" menu item on the Microsoft Office Button menu that includes a wizard for Package and Deployment of applications. I do not have this "Developer"...

I'm using the TransferText function to export a table from Access into Excel. If I export the file as a .txt or a .csv, it works fine; however when I try to export the file as an .XLS, I get a run-time error of 3027 -- "Cannot update. Database or object is read-only." Here's the code...

Is there a way to link to the primary data stores (those containing the user setup information, specifically) from an Access database? I see how to link an Outlook folder but I need to be able to access the user information.

I'm wanting to check group membership for a user and choose to display or not display various buttons on a form. I have found some code that works fine as long as you are an Admin; however, if you're not an Admin and open the program in Access 2000 or 2003, it will open fine the first time but...

I'm trying to insert data into a Sybase table (set up with an ODBC connection). I can insert data just fine with a pass-through query that I've set up if I manually enter the values for the fields. However, I need to pull the values from a local Access table to insert into the Sybase table. When...

I have put textboxes into the Item Template of a datalist control. I'm using Visual Studio 2005 (vbscripting). I want to control the tab order of the fields on each row of the datalist. However, when I set the tab index for each field, when the user tabs out of that field, it drops to the next...

I'm using Visual Studio 2005 (coding in VB). When I use the MsgBox function, it works fine locally but when I try to run it from the server, I get the following error message: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid...

I am trying to populate a text field on a Crystal report (using Visual Studio 2005 and vb scripting) with the contents of a session variable that I have previously stored. I found a suggestion while googling of adding the following line to my code behind page to pass the session variable to a...

I’m having trouble with a datalist. The default view is the Item Template which has an Edit button. When I click the Edit button, I run the following code (on the EditCommand of the Datalist): DataList1.EditItemIndex = e.Item.ItemIndex DataBind() It errors out with the message “Must declare...

I'm trying to set the focus to a specific field (on exit of another field within a datalist that is set to run a calculation and autopostback). Because the web page does an autopostback after I exit the first field, my cursor history is lost. I'm trying to specify the exact row and field to...

I have set up a server that has Webdav enabled. From a remote client, I am able to open Microsoft Word, use the server/virtual directory url to open the file on the server, make revisions and save the file successfully. I am struggling with how to make the call to open this file using webdav...

I have a problem in deploying an ASP.NET web project with Microsoft.Interop.Word. From the developing PC, my program opens a Word template, replaces bookmarks with some text from the web page and then saves and closes the file. As many others say, it works fine from the developing PC but when I...

I have a page that has a formview (for the parent table data) and a datalist control (for the child table data). For a single check request record, for example, 3 rows of products may be displaying in the datalist control. I have fields for Quantity, Cost and Total Cost. I have code that should...

I've got two dropdowns which are unbound and which I bind the values of when I update or insert. My method works on all of my other pages, but for some reason is not working on this page. When I try to update the record (it's in a formview), I get an IE message saying "Object must implement...

I have code that uses Interop to create Word documents from within a VS2005 web application. My code either creates a document or opens an existing document in Microsoft Word 2003 to enable a user to make changes and save it. This all works fine from my development laptop, however when I copy...

I want to be able to automate a word document from my ASP.NET application and I have to use the Microsoft Word Object library (Interop.Word) which is a COM class. Having refrenced it and all, the application runs perfectly in the Visual Studio 2005 environment and I have no problems at all. Now...

I am using Visual Studio 2005 and writing all code-behind in VB. I'm setting the focus of a textbox after I run some calculations. I want to additionally select all the text in the textbox that I've set the focus to so that the user doesn't have to manually select the text and type. Can someone...

We are building a web app with Visual Studio 2005 and have incorporated embedded Crystal reports. We are opening the reports as pdfs. They open and display data correctly, except for on two machines that are both running Windows 2000 server. When we try to view the reports from either of those...

I have built a web site with Visual Studio 2005 that uses Crystal Reports. I'm trying to load the application onto another server. I do a Publish on the website and the main aspx pages come up fine but when I try to run a Crystal Report, I get an error page talking about an Invalid Class String...