Search results

I had a similar problem. I believe that the appropriate DoCmd is BrowseTo, rather than OpenForm. This seems to work directly on the Navigation Form and its associated buttons. One caveat - if you are doing any manipulation of the controls on the target form before browsing to it, you will open...

I have a most curious situation. My application is using a Navigation Form (Top buttons = Major Area, Left Hand buttons = minor area), and all of a sudden it has stopped working! All of the forms used as sub-forms in the Navigation Form are also 'available' as independent forms, and they are...

I'm trying to create a navigation control on the fly. When a user logs in to my application they have the possibility of accessing several parts of the application at several levels. Specifically there are seven main areas each of which has up to 10 sub-areas. Depending on the capabilities of...

Thanks, Galaxiom! It worked like a charm. Of course it's only documented if you know to look for it, and most of the examples I've see use simple .Connection. Tony

I have a code snippet that I am expecting to return a valid recordcount from an ADODB.Recordset: Private Sub cmdGoToPrevious_Click() Dim FindCriteria As String Dim SQLCommand As String Dim SegmentedBrowse As Boolean #If TraceLevel > 1 Then Debug.Print Time(), "STUDYDESIGN", "GoToPrev"...

Thanks for your response. If I understand you now, the 'relationships' are more like this: Scout => Field =>Pest || || => Note (We can have more than one pest entry for a field, and more than one Note entry for a field, and there is NO RELATIONSHIP...

One thing is not quite clear form the 'specifications' that you gave. (Well, two things, actually). First - you seem to have a bunch of scouts who are going into a bunch of fields to find a bunch of pests, and then create a bunch of notes about what they've done. In other words we have: Scout...

I'm learning to use the new Navigation Form control in Access 2010. I think I like it. I have, however, run into a small problem. I'm using the options/sub-options capabilities, with major options lined up across the top, and sub-options down the left-hand side. At one point I need to be able...

I'm tryingt to persuade a tab-control to honour the request to make itself a multi-row control. Environment is Access 2010, and I have been adding pages to a tab-control,. and now discover (as I get into useability evaluation) that the form has been pushing back the boundaries of the right-hand...

Some additional information. I can track the form's activity through the Load event, but then it never makes it to the Activate event. (This matches, as far as I can tell) the visual symptoms, where the form is seen to be available, but there is nothing there. I'm nowhere close to the limit...

I have an Access 2010 database with a form containing a tab-control. I've slowly been adding several stand-alone forms as pages on the tab-control. I just added 2 more, and all of a sudden the form does not display in Form mode. It doesn't even get to the Activate event. I removed the last two...

Thanks to Isskinnt and John Big Booty (love those user names!) for the pointer to the solution using the ReQuery method. This led to a runtime error 2118, which seems to want to save a record before doing a requery. Of course, because I'm simply looking at values there is no record to save. Nor...

OK - I'm past the problem from earlier. If I change the underlying table design I can now make the fields visible and available to the form. Here's the next issue (and I suspect it'll be a doozy). I'm using several fields as look-up paths into the database. Among these are Publisher, Label...

Hello - I have a set of tables and a form that I'm using to design an application to track my CDs. Part of the "Learn How to Use Access 2010" process. I'm designing it iteratively, and I now need to update the underlying table design for one of the tables in the form. I can no longer 'get to'...

Thanks, Missing! Especially this bit: "The Access guru, Allen Browne, once stated that the learning curve for an experienced Access developer, moving up to 2007, was twice as big as the learning curve for a complete Access novice+ learning 2007, simply because there was so much stuff that...

Hi Kristen Two things come to mind - both based on your description, and which may or may not be helpful. If you have "a static set of skills that all employees are rated on", then this sounds like a separate table - EmployeeSkillRatings, with a layout something like this: EmployeeID...

Hi Jon First off, thanks for a great community! It's nice to have a section for newcomers to introduce themselves, and even nicer when you get a welcome to that introduction! However, because I tend to be literal minded at first (I prefer to assume that people say what they mean, and mean what...

Problem solved! It was, as I suspected a newbie problem. Hunting around to see if there was a toolbox that I could open up, I checked the View pane on the ribbon. Lo and behold, there was an option for Design view. Silly me thought that I was already there because I was able to design a new...

Thanks for the response, Spikepl. Short answer to your question is "I don't know"! Whatever the default clipboard is, I guess. For example, Microsoft Access 2010 Bible (p. 281) says: "You can create copies of any control by copying it to the Clipboard, and then pasting the copies where you want...

So, this is obviously a newbie problem. However, I can't find any help using such searches as "Copy control to clipboard", hence this thread. I'm trying to copy a control to the clipboard. It isn't working! I have an otherwise empty form with a single label (lblUserID) which is not bound to...