Search results

Hello to the forum. Beginner using 2010. I wish to play MP3 files from a command button on a form. I would like to avoid third party / ActiveX controls if possible. I am aware that use of "CurrentProject.Path" will be helpful to locate the MP3 file within a directory within the Project Folder...

Thank you Pat H. On first reading I think I already use the method you have described but will read carefully again to check. The database is small but will be used with a large image folder of pdf pages linked to command buttons on the forms. All my forms so far are "display only" upon the...

Thank you for the helpful information. May I ask you to expand a little from the following please? "It is not hard to upsize to sQL Server but unless you have already used good client/server techniques with your forms and queries, you will have work to do to make the application function...

Thank you CJ_London I am trying to have the user able to move between forms at will and had asked in a previous thread about having all open at once but was advised against that. Was advised to use the Visible property. Just tried replacing IsLoaded with Visible and just get error. Am now...

Hello CJ_London Yes that is correct. 8 command buttons including one that is for the FrmHome only so has different code on its own button (Button01) Other 7 have copies of this code just renamed for the appropriate main forms. FrmSubNav is a subform on 8 main forms including FrmHome and the...

Hello. Beginner using accdb2010 with multiple forms for display only (eventually in runtime with maximum restrictions). Have FrmSubNav on each main form with command buttons. These buttons allow selection of another form or closing current form and returning to home form. (The appropriate button...

Thank you Gemma Actually it was the suggestion from Pat that has worked for me. I do not have any modal or popup forms at present - but wish to experiment with them later. For now I have used the OnClick to check for a form loaded and if it is then to make the calling form not visible, make the...

Thank you Pat. That seems like a good way to proceed. I was trying to think of a way of reducing the number of forms but that has so far been impossible. I will use your advice and see if I can make it work. The db is for the presentation of historical information only so there will be no...

To clarify the problem. I want the function of the tabs at the top of the open forms included within my cmd buttons that open forms (with appropriate If,Else to catch one that is not already loaded). Namely that the top tabs merely move between forms without changing status or closing any...

Thank you for the "bang" advice. But getting the same result = focus is correctly set but the target form remains behind the calling form. However - have found and tried "BrowseTo" and have got this far - DoCmd.BrowseTo acBrowseToForm, "NameOfForm", "", "", "", acFormReadOnly Which does...

Hello forum from a beginner with accdb 2010. When multiple forms are open is there a way to move between them without doing a requery or docmd.openform? I have cmd buttons on each form to allow the DoCmd to open the others but when they are all open I want users to be able to move between forms...

And....... See this version for a non ActiveX version. As no links allowed - translate this and you will find. sites DOT google DOT com SLASH site SLASH e90e50 SLASH calendar-control-class Have not tried it but looks good.

And a further update. When transferring to a machine with runtime (and having sorted out the Trusted Location registry). It turns out that use of "Microsoft Windows Common Controls 6.0" causes error with missing/broken reference to "mscomct2.ocx". Apparently the ActiveX stuff causes a headache...

In the absence of any suggestions I have used the Neanderthal approach. Used table list of dates and stuffed values into combobox. Used as a record selector with next/previous/first/last buttons as well. It works and is robust and easy for the "users". Seems as though a lot of people have...

Complete beginner with accd2010. Forms to display historical records, one needs to be filtered by date. I have seen the excellent datepicker from "pkstormy" but want another more compact method. And I am only using a 3 year range. Have created dateserials (in Excel) for the range I am using...

Hello to the forum. I am collating some historical information and trying to present it as a database to a small group of interested people. Absolute beginner with databases. (Functional with PCs and can rebuild a dead laptop - long story). First target is to get a DVD version as a 'accde' -...