Recent content by choaspes

Thank you that's very kind but I'm happy enough just to add the setfocus each time.

Yep, all the forms in the db slot into the same master navigation form. Most in the same first level tab even

The answer is: DoCmd.OutputTo "Whatever" STUFF Forms!NavigationForm.SetFocus DoCmd.BrowseTo "Wherever" Not seemingly necessary on any of my other forms in which I do exactly the same thing, but is necessary on this one!

It seems to be this simple: DoCmd.OutputTo "Whatever" STUFF DoCmd.BrowseTo "Wherever" "Error '2046': The command or action "BrowseTo" isn't available now" DoCmd.OutputTo "Whatever" 'STUFF DoCmd.BrowseTo "Wherever" "Error '2046': The command or action "BrowseTo" isn't available now"...

Hi All Tearing my hair out with this one. My access db front end is based around a navigation form and on lots of the hosted subforms there are command buttons that trigger code that does "lots of stuff" then navigates to a different form. On many of those forms the "lots of stuff" includes...

Thank you Minty, really helpful

Hi All I'm currently running a db with an Access front end linking to a SQL server back end. I'm fairly new to SQL server and it's been a steep learning curve but I've got past the immediate hurdles of learning elementary T-SQL for my pass through queries and using "dbSeeChanges" for my DAO...

I would rather not, but I will defer to you on the language that best describes my 'achievement'

I have finally, finally, finally found a proper workaround for this. My temporary workaround above didn't survive first contact with real life and unfortunately in various scenarios my navigation sub-bar still grew without invitation and made my form look rubbish. I still have no idea why the...

Duh. Solved. Thank you. End of a long week.

Hi All I have a very large collection of reports serving as template letters for different scenarios, which I want to update to use a new record source query returning different fields. To do this I would need to update the record source for each report and for each of the relevant fields...

An update. I didn't manage to solve the problem but I took arnelgp's suggestion of using the .enabled property and adapted the sub to keep more tabs visible but disenable some of them, and for whatever reason keeping more tabs on the screen means the navigating sub-bar no longer resizes itself...

Because there are far too many to fit, and for most of those tabs there are in fact two tabs for different situations but those tabs are designed to look the same to the user. That means that dependent on the situation the sub is making about half of the tabs width 0, right padding 0 and...

Thanks George, here they are. White bits contained info that needed to be redacted. You'll see in the "after shot" that the spacing of the tabs seems to be different and the navigation subform has been pushed down 110 twips. The only value that I can identify as having changed is the height of...

Hi All My database front end is structured around a navigation form and each tab on the "main" navigation bar has its own selection of tabs on its respective "sub" navigation bar. For one of my "main" tabs I have a public sub that determines which of its "sub" tabs are visible in different...