Search results for query: *

I have a pass-through query that has two dates as parameters. The problem is those dates need to be changeable. I thought it would be a simple VBA statement to just delete the old query and create a new one as and when needed. It appears it is not, or I am missing a key point. Is there a simple...

I want to programmatically examine every email being sent from my desktop. If certain conditions exist I want to automatically cancel the send. I have searched this forum and have found solutions that I thought would work like the Item_send = false and such, but none seems to work. It appears as...

I want to read the arguments from a shortcut in the favorites folder. In particular I am looking to read the URL and description into an access table. I tried .filesearch but it won't even see the shortcuts. Please give me a place to start. I have been unable to find anything here or on MSDN...

I have need to open an access 97 application from an Access 2002 application and turn control over to it until closed. I thought I was on the right track with the following, but I keep getting an error. ****START CODE Private Sub Command0_Click() Dim appAccess As Access.Application...

I want to call a report over and over while stepping through an array. The problem is that once the first window opens displaying the report Access will not open any additional windows. Is there a way to force Access to open a report and then open the report again without closing the previously...

I have a popup\modal form that is used to create a new record in an application. Basically the user clicks a button it opens a form that allowsadditions. The user puts in the basic information required and clicks save. That closes the input form and returns the user to the view and edit form...

I have a reprot with several sub reports. At times some of these sub reports do not contain data. I want to have a page break after teh sub report when data exist but not have it when data does not exist. I am using Acess(XP) In a different thread I found the statement "me.pagebreak0 =...

I wish to extend the functionality of the "click event" from a control on a bound Access(XP) form. I want to take special action when a user clicks a control while holding the <ctrl> key down. Is there a way do accomplish this? Thanks Much

I think I would like to sequentially number the records within a called recordset. The only idea I have is to read the value from the previous record and add one in the current record. Two questions, are there other, better approachs? If this is a good approach to this problem, how do I read...

I am using a call back function to populate a list box. The items in the list box are subject to a choice made in a previous field. None of this seems to be a great problem except... I can not seem to control the number of items permitted in the list box. If I happen to call for a list that...

I desire to import a table (SQL query) directly from SQL 2000 database to an excel spreadsheet. I must be missing something here. Does any have a simple code sample that would allow me to see what I'm missing. I do not seem to be able to get the connection working correctly. <CODE FOLLOWS> Dim...

I inherited an Excel document that uses a combo box to populate a field. I want to make changes to the list and default values of this lookup, BUT I cannot access the properties or any thing. The only thing I can do is populate the cell. Does ANYONE know what is going on here? I can see the list...

I am using Office 2002 and wnat to lock my toolbars in place. Is there a way that anybody knows to do that. I will except just locking Word if that is possible but would like to lock them all globally if possible. Thanks Much ssecca

I would like to add a blank line to the detail section of a report based on the value found in the report. inv# Amount 1234 $50.00 1235 $50.00 (I want this to be a single inserted blank line when the amount changes) 1236 $60.00 (Blank Line) 1237 $63.00 I...

Is it possible to call a SQL Stored procedure and use it as a recordsource in a report. I am using Access(2002). I am still more fimilar with DAO than ADO, but with some help will try either or any ideas.

If possible would somebody share a sample of how to determine if a query or linked table already exist in a database before being re=linked or created. Thanks ssecca

I need to transfer data From an Excel XP passworded document to an Access XP table. Aceess is doing the calling. Normally I would use something like TransferSpreadsheet to acomplish this, but have never needed the Excel document to be PAssword protected before. I do not if or how to pass teh...

I need to refer to a table on a different server and database for a stored procedure from the original Server/Database. Can someone assist me with a way to acomplish this? Thank You

Below is the code I wish to use to create a text file directly from SQL. It, however keeps giving me the following error... [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]Function sequence error This same basic code has worked for me at other...

sp_OACreate /Method Errors Need advise please I am using sp_OACreate and sp_OAMethod to create a text file directly out of SQL 7. I have used this before at other locations without problems. Here I keep getting the following errors... [Microsoft][ODBC SQL Server Driver]Protocol error in TDS...