Recent content by JMHScot

Damm! I have spent the last couple of hours looking at that, an extra space - take it away and it works. Thank you, theDBguy.

Hi Gasman, All folders are already created and populated, but confused to why there should only be one picture in each folder, in fact if that is the case, then I am stumped as all the folders contain multiple jpg files alongside of map.jpg

Hi, I have 2 buttons on a custom form containing onclick event procedures to create a hyperlink which use a variable named “Gallery” to deliver a numerical value, variable depending on what data is being viewed, to complete the webpage name. All webpages are sequentially numbered, e.g...

Ok, so that works, but I am feeling exceedingly dumb. I don't see any difference in my Even Procedure, or am I missing sometheing, or did you change a setting elsewhere? Can you please point/explain to me to what you have done so I know for transfer to master database and future use. Thanks

Okay, so here is a test version I was using, just a few records, forms and reports. On the frmPrimary, which will launch on opening, the Blue buttons are those linked to forms, click any they automatically open selected form, and if a form is already open, close it, including the Search option...

No. Unload event is empty/blank.

Hi, I have database with a form, frmPrimary, which is designed as my Switchboard of sorts. The database contains mountain classifications and reports. If I want to view the data for any classification in form view, then I have a button for each classification, eg, btnMunros, btnCorbetts which...

Updated all and everything works fine. Thanks

Thanks Arnelgp, Have tested on one query only, as busy now, but it works, so will do others later. Thanks for prompt reply. John

I have a DB of reports, each report has a Status field– with one of either Open, Active, Archived as the status type. On my customised switchboard I currently have 3 buttons, Open, Active, Archived which when clicked will open the report for whichever Status I have clicked – this via 3 separate...

Hi All, I was well into Access in the late 90s early 2000s, but have since retired and now just keep my hand in with DBs of various sorts, keeps the mind active. Usually manage to solve problems by reading multi help sources, but, thought I might as well re-join a forum specific to Access...