Search results for query: *

Actually, you can trap for errors in Access 2007 -- it's new to this version. I.e., you can put [MacroError].[Number] <> 0 in the condition column and trap for specific error numbers. Then there is an additional Action available of "ClearMacroError" which clears the error number in case you're...

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"...

No, the file isn't open. I'm even deleting the file if it exists first.

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...

Success! I used dhookum's restructuring but it still failed on the Execute with the same error "Cannot execute a select query." So I commented out just the Execute line and then added pbaldy's OpenQuery and it now loops through and adds my records! Thank you both so much for your help!

When I add this, I get an error message that says "Runtime Error 3065: Cannot execute a select query. Here's what I have: If Not Myset7.EOF Then Myset7.MoveFirst Do Until Myset7.EOF Myset7.Edit sSQL = "INSERT INTO CONTACTS ( Title, LAST_NAME, FIRST_NAME, ADDRESS_NAME...

Does anyone know how to actually run a pass-through query with VBA? I've got code that I've modified that should update the SQL string, but I'm not seeing how you actually execute the query? Here's what I've got: Dim sSQL As String Dim dbs As Database Dim qdf As QueryDef MyStr7 = "Select *...

Thank you both. I'm not seeing a way to link my Access database with a linked-server type option in Sybase (although Sybase certainly isn't my specialty). I may work on the suggestion of looping through an Access-based recordset and running a pass-through query with each loop. Thank you both...

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...

Does anyone know of where I can look at some sample code to implement this client-side?

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...

Unfortunately, I don't know enough javascript to do this. Thanks for the input though.

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 tried unsuccessfully for a couple of months to deploy an application that uses Interop (Word) from a client-based PC where it works flawlessly to a Windows 2003 server. It does not work on the server. I have posted in forums (including here) and have tried all recommendations but nothing...