Search results

I believe I have solved this. But don't know why. I was reading some related threads and altered a few of the form properties in particular on the form that opens the second form changing "Min and Max Buttons" from "None" to "Max Enabled", I see the connection but don't understand why that...

Hi I have a form with a command button that opens another form (DoCmd.OpenForm "from"). When the new form is closed all the forms behind it have become un-maximised (is there a correct term for that?) As standard on all my forms in the "onload" event, I include a DoCmd.Maxmise. Running the...

Okay, many thanks for the advice. In this case, by far the simplest solution is to roll back to the last working version which I have been using today no bother - so the cause will remain a mystery. The database is split and issues were all with the front end so no data loss just an odd tweak to...

Hi I have a project I use most days, I haven't made significant changes to it in a while but today it's gone odd. On launching while it opens the main form it gives the error "File Not Found" and goes into debugging mode and the main forms code window opens. However, no line of executing code...

Yep, that seems to work. Many thanks.

Hi I have db that produces my school's timetable, we are a specialist school and it changes a lot (almost weekly, it drives me nuts). Each time I make an amend I have a button that I press to output all the timetable documents (of which there are over 100) to PDFs on a shared drive, some are A3...

My understanding of the change is that instead of the "this looks suspicious do you want to enable it" type thing we have now coming up you will be directed to an MS Help [sic] page which will tell you to change something in the settings before VBA code will be allowed to run. My concern here...

Many thanks for all the helpful tips here. Especially useful is the difference between ReportView and PrintView, never really considered it before.

Many thanks, that makes sense now and is obvious (isn't always once you know?) Couldn't get openargs to work, I don't think I have the syntax right, if my control is called "txtBox" and report "rptMyReport" what do I replace "??" with below? DoCmd.OpenReport "rptMyReport", acViewReport, ""...

Hi when I run this code on an open Form the unbound text box called "txtBox" gets filled with the word "bob" Forms!frmMyForm!txtBox = "bob" but when I run this on an open Report Reports!rptMyReprt!txtBox = "bob" I get the error "Argument not optional" (also VBA editor changes "Reports!" to...

Hi I hope I am allowed to ask this on this forum, if not apologies in advance. Some years ago I created an Access db for the school I work for (this forum being my go to support - many thanks). The db has now grown in complexity and the school has grown in size and diversity. The basic problem...

Once again thank you for all the replies, I am now going through all 300+ objects in the FE and tidying them and generally implementing much of what has been said here (along with much advice from the misnamed '10' commandments thread and much else on the forum). For anyone picking up this...

Tah, I thought that's what you meant but better safe than sorry.

Many thanks for this weekend reading. I have scanned all the above and one question immediately came to mind (I'm sure there will be more). Several responses say I should have a seperate front end for each user, can I clarify what that means. Presently after updating the front end I post it...

Hi Firstly apolgies for the rambly-ness of this post - I not really after solutions just general pointers and links to materail that could help. I have (by my standards) a complex database which is split between a FE and BE, it has about 30 users who all have a copy of front end and access the...

Welcome I wish I had read this old thread before I started my first Access project. https://www.access-programmers.co.uk/forums/threads/the-ten-commandments-of-access.172363/

This forum has been ace for me, the regular contributors give good understandable advice and have helped me greatly either in response to my idiotic posts or through finding someone else with the same problem. Just in case I haven't done so before Thankyou to you all, my school has a better...

okay I think I have to go on for now, the only problem I have with our network admin is that I run it alongside about 2,000 other jobs - at most for the foreseeable there will be no more than 5 remote users requiring a few minutes a day. Inputs from remote users will not be time critical, any...

Many thanks for all inputs, I think I am now in firmly in the RemoteDesktop with software VPN camp, I can live with the restrictions and can set it up quickly (and I understand how it works which is always a bonsus).

I like the use of the word I don't doubt you on this but I'm interested what benefit does the VPN give me (I presume it's a security thing) Many thanks