Recent content by ssecca

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

This does not seem to work. I have tried .filesearch before and it does not see the favorites as files or something. It will not see them regardless of how I modify the code. If I ad a text file into the directory it sees it but not the favorite shortcuts. Because of that I can not read the URL...

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

Yes, of course. Thank you that works fine. regards

Unfortunatly I can not convert it. All our computers have BOTH Access 2002 and Access 97 installed. Depending on the application being opened the short cuts are directed to open the application using either 2002 or 97 as appropriate. In this case we have a 2002 application that we want to...

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

Three of the suggestions here seem to work well. I thank you all for your help. I chose the "cycle" option as it was the easiest to use when updating about thirty forms. Again thanks for all the input. ssecca

No my understanding of the snapshot viewer is it is not editable by design.

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

This is what I tried, but I get the error refered to in the original post, that is... Access does not support this property or method The syntax I am using in the report open event is me.pagebreak50 = true I'm lost, any help greatly appreciated. Thanks

When grouping ALL of the choosen fields in the query need to have some type of grouping designation. That designation could be "Group By", but might also be "First", "LAst", "Expression", or "Where". All of the options are listed in the pull down on the totals line of the QBE.

How about something like this on the report open event... dim bln_noVal as boolean bln_noVal = false if (isnull(a) or a = "") and (isnull(b) or b="") and (isnull(c) or c="") then bln_noVal = true end if if bln_noval = true then me.nonesel.visible = true me.nonesel.value = "None...

This is untested but how about something like this... Create a global variable Global gbl_sSQL as string On the form button that calls the report use the following... Private Sub Command4_Click() gbl_sSQl = Me.RecordSource DoCmd.OpenReport "report1", acViewPreview End Sub...