Search results for query: *

Please note also, that I also had to change parameters used by the report, to not pull from the unavailable database. Fortunately, for the reports I have, this wasn't a huge deal.

Well -- I think my problem was a phantom. I am seeing separate between the subscription processing (which I want) and the report processing (which I'm trying to prevent, when the source DB is restoring.) My subscription is now holding up the show, or returning zero rows such that the report...

Hi, Any nifty ideas on how I can hold up a report's data driven subscription until the data source (a SQL Server Database) is restored? My data driven subscription (DDS) is blowing up if it runs while the DB is still restoring. The DDS reads a separate database, invoking a stored procedure...

Thanks! I will try this tonight when I get back to the problem, and let you know. Stg

Hi, Once upon a time there was a form, based on a multi-table (but updateable) query, that includes a "check-box" on each row and a button on the form buttons that is labeled "Check All". Clicking "Check All" spins through all the rows of the recordset (until eof) marking each check box as...

Hi, Sorry if this isn't the best forum for this question, but I know some very smart folks hover here, so I'm giving it a try. I have a MS Access 2007 data base with 3 "linked" SQL Server tables. When I open the database via a tool (like WinSQL) through an ODBC connection, I see the Access...

Thank you both for the help. These were pretty much the answers I was finding elsewhere, but I was hoping against hope for some other angle. Thanks again. Stg

Hello, I have bound checkbox on a continuous form. It is bound to one of the tables in the underlying query. I am able to check and uncheck the boxes at will and with code like the following: DoCmd.GoToRecord , , acLast RowCnt = Me.CurrentRecord DoCmd.GoToRecord , , acFirst...

That seems to be the problem. I've got it working now. Thanks! Stg

I must be stupid!!! Basically I want to use a function as in the criteria for a query. I've found a few examples on the net and believe I'm very close. The Function is Public Function GetPkgName() As String GetPkgName = strPkgNamePublic End Function My query references GetPkgName()...

Great Stuff -- Thanks! Stg

Hello, Is there anyway to export all of the VBA code behind a MS Access 2007 database? (The code behind the forms is what I'm after.) The File-> Export File only seems to want to export the form or code you are currently looking at. Here's my real problem. I have a semi-large Access 2007...

Found it. On the advice of a friend, I went to Access Options, Trust Center, and (1st enabled all macro's - somewhat dangerous, so I undid that and just added the path of my MDB to the Trusted locations.) Sheesh. The buttons seem to work now.

I can even put garbage in the click event, like asdfkjhsdfopiau and nothing happens when I click the button on the form. Arg!!!

Hi, I'm working with an Access database developed under Access 2003. I'm using 2007. I have a form, with a button. The "On Click" event has one line in it - a message box. It doesn't work. None of my formerly working buttons seems to work. Any tips on where to start? I don't even seem to...

Thank you! Works great! :-)

Hello -- 1st time poster and MS Access 2003 novice here! I've adapted a bit of VBA code that gives me nice Save and Undo buttons. These buttons are correctly enabled/disabled as follows: Private Sub Form_Current() Me!cmdUndoChanges.Enabled = False Me!cmdSaveChanges.Enabled = False End...