Search results

Because the forms close and open all the time as my application runs normally. I dont want the application to quit every time one form closes and another one opens. If there's no way to put any code behind the close button I may have to create my own close button as suggested above.

Hi My application has many forms that close and load when you press 'continue' or 'back' buttons etc. Each form has the close button in the top right but when you pressed the access application stays open. I need a way to trigger the 'Application.Quit' when they press the form close button...

Awesome thanks for such a thorough set of responses :D I should have everything I need to get it working as I want to now. Thanks again!

One problem that I maybe didnt make clear enough in my original post. I cant actually delete the target folder, I need to keep the original files in the target directory, and add any new files from the source directory. There may be some duplicates that can either not be copied or can...

Can a batch file take variables when called? The name of the folder I'm copying will change every time the code is executed.. Dan

Hi I need my code to copy a folder of files into another folder of files. Sometimes the file names may match, it doesnt matter if these files are not copied, or are copied and overwrite the orginal. The CopyFolder method doesnt work because some files in the target directory are read only...

Hi On the main form of my software I have about 20 subforms all layered in the same position, and my code switches which form is visible. Not ideal apparently but its what I've got to work with. This format makes adjusting the position of these subforms an absolute nightmare. I was...

Ah I see, thanks! 303

Hi I have a form linked to a table. One of the text boxes on this form needs to trigger a function when updated, a function that updates the same table the form is linked to. So the text box has the following code: Private Sub ExhibitLocation_AfterUpdate() Call AddExhibitNote("Location...

I see, so given that the access window is hidden when my application is running this custom made menu is no good to me.. ah well worth a shot tho thanks peeps :) ill just set some time aside to create lots of buttons that sort queries. 303

I'm a little confused here. I've used these instructions to create a custom menu, and set it in the Other/Toolbars property of the form, and yet it doesnt appear whent he form loads. How would I decide where on the form it appears etc? The only place I can actually see the toolbar is in the...

I was considering doing it that way.. however there are about 20 forms, each one with about 10 different fields.. it's going to take aaages to set up the buttons and code to let the user sort by any field ascending or descending.. it would be a lot easier if there was an easy way to switch on...

Hi My application has the main Access window hidden wth ShowWindow(Application.hWndAccessApp, SW_HIDE) The problem is that in datasheet view the user cannot sort the results by any particular field because the right click menu is disabled. Is there any way to allow sorting of datasheets with...

Actually one further question: I've done as I mentioned above, set a combo box on my subform with the control source as 'status' (text field) and the row source a list of available statuses from a different table. When it loads the combo box is blank instead of displaying the value from the...

I see.. So I should have the status as a text field in the tblExhibitInfo instead of a lookup, but keep the row source of the drop down box from the tblStatus? Let me know if there is a more elegant solution! Thanks for your help

Very helpful thank you! got it working now :) Dan

Hi I have a table with a field that is on a lookup to another table. So the field 'ExhibitStatus' on table 'tblExhibitInfo' is on lookup to table 'tblStatus', linked by ID, where tblStatus is: ID Status 1 Open 2 Closed 3 In progress Etc. Now this works fine when you open up...

Hi I have a form with a subform that displays results from a query. I'm trying to udate which query is used as the recordsource, using code. I've been trying to use the following code: Forms![frmResultsCase]![subfrmExhibitList].RecordSource = qryOpenExhibit Where the main form is...