Search results

It doesn't appear to be a filtering problem. By using VBA to look at the underlying tabledefs and querydefs I'm convinced that Access has lost its way somehow. Those vba queries should have given me a record count of tables and queries - not an error message. I've just tried a compact and...

Hi Mihail I copied the database onto my laptop which is running Access 2010. The queries and tables are not showing in the navigation pane. When I opened the Immediate window and typed ? CurrentDB.TableDefs.Count I got the error 3167 ? CurrentDB.QueryDefs.Count also gave the error...

Yesterday the queries (and tables) were displayed in the navigation pane - today they are not. The users tell me that they did nothing. The database still works so I guess that the queries are "hidden" not deleted. The database options are set to display "hidden" items so they should appear...

I have a combo box on a form who's Row Source is driven from a simple select ( Select SalesSource, CurrentState from tblSource Where CurrentState = "Live"). The LimitToList property is set to Yes. The user can only select one of the valid entries from the list. If they try to type something...

Hi everyone I'm Ray and have been using databases for many years. I've been using Access for quite a while and on a scale of "Novice", "User", "Super User", "Dabbler in VBA programming", "Proficient in VBA", "Expert in VBA" and "Professional developer" I would rate myself as a Dabbler with...