Search results

I am using this code on a form command button click event trying to make the form disappear while I open another form based on a query. I thought the acDialog was supposed to suspend the code until the new form closes. Maybe I just have it incorrectly placed. Please take a look and advise me...

Thanks again RG

I am not very versed in VBA but I have tried this code on my Preview Report button's click event but it doesn't pause the code for me. Do I have it in the wrong place? Private Sub cmdPreview_Click() Me.Visible = False DoCmd.OpenReport Me.ReportList, acViewPreview, "", "", acNormal, acDialog...

Thank for responding RG, I don't have a problem making the form go away it's getting it back when I close the report preview. Where would I put the code to get the form visable again? You and I were at it at the same time. Thanks I will give a try.

I have a form that lists all the reports available in the database so the user can selectivly preview or print any report they need. My problem in the I want the form to be a pop-up but when I have that property set I can't get the form out of the way of the report preview. I can close or...

I have a form that lists all the reports available in the database so the user can selectivly preview or print any report they need. My problem in the I want the form to be a pop-up but when I have that property set I can't get the form out of the way of the report preview. I can close or...

I have this code in a function to minimize a switchboard while another form opens. But it errors out on .minimize with "Wrong number of arguments or invalid property assignment." Help is not much help as it provides no sample code to look at. Could someone point out my errors? Function...

Adam, I think you are correct. I just looked at my code and I am closing the SB instead of minimizing. When I minimize and restore it comes back to the same form. Thanks for helping me think straight.

Thanks for responding, On my main SB I have four other switchboards (pages) that take me to different proceedures Like Update Tables, Assign Orders, Reports, Table Maintenance. When I run, for instances, Reports for different departments I click the Reports button on the Main SB and select one...

I am using a Access generated switchboard in 2007 and would like to know if anyone knows how to get me back to the switchboard I was using when I closed the main switchboard and opened another user form? I seem to be only able to get back to the main switchboard on the close event of the...

Bob, Thanks for the information.

I have a mess of converted macros and each one shows up as a different module. Am I able to Assign a module name like in Excel and move those into a single module? If I don't change the name of the functions do I have to go back and redirect any of my forms and reports that use these functions...

I just used the manage switchboard wizard and I selected RunCode and typed in the module name the first time. When it errored out I then went into edit mode and copy pasted the module name because I though maybe I had misspelled it. Each way gave me the same halt. I seems the process does not...

Actually this attachment is the halt I get. I rushed to post without finishing the routine.

I think so too, so I made a macro to run the code and attached is an image of the halt I get. Basically it says it can't find a code of that name. It's there in the module window so I don't know why it doesn't recognize the fact that it's there.

I have attached an image of the error. It just says there was an error executing this command. I eliminated the = sign and still get the error.

I am trying to run this function through a switchboard and it errors out. In the switchboard I used the option to run code and I entered UpdateAssignedOrdersTable as a function name. I converted this from a macro originally and added the SetWarning to the function. Do I need to do something more...

Thanks Bob this will work nice for me.

Bob I am trying to use your example of the listbox control. I have one little problem I don't know how to eliminate. This is your RowSource code adapted to my situation. SELECT MsysObjects.Name, Mid([Name],5) AS QueryName FROM MsysObjects WHERE (((Left([Name],3))="rpt")) ORDER BY...

After your help in looking at everything it had to be the report itself. I don't know what caused the problem with the original report but when I recreated the report as a test and ran it with code it printed correctly. There was no conditional formatting involved and I think with the new report...