Search results

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...

Thanks so much both of you, trying that code now.

Dear All I'd be very grateful for a steer on the conundrum below. My table logs episodes of care in particular health services, so each record has (amongst other things): - a patientID (denoting the unique person), - a sequenceID (denoting the uninterrupted sequence of episodes of care for...

My apologies, total idiot - typo in the Format line! It works! Thank you

MsgBox (DCount("[ID]", "[tbl]", "[datefield] = #" & Format(Me!Textbox.Value, "mm/dd/yyyy") & "#") ) returns Run time error 6: Overflow I'm attempting to compare time as well - both the textbox and table field are date and time, does that make a difference?

Dear All I'd be very grateful for a steer on how to get the DCount function working with date critera. The idea is to have a function on a form that checks that the user isn't entering a record that already exists on [tbl], by comparing the date being entered on a form with dates that already...