Search results

Premise: It might be useful to take a collection of forms that work well together and "wrap" them in an outer form that is nothing more than formatting and navigation. I have tblFirstName and tblLastName tblFirstName and tblLastName exist in a 1 to many relationship. tblFirstName is the one...

My thanks. Sorry if I did offend...I love such links! I'm reluctant to have user preferences go with the machine. The implication is that the user has the priviledge of writing to the registry. That's often not the case. Between your link, that link I found and one by Allen Browne, I'm...

If we're throwing links around, there's always this: http://www.databasejournal.com/features/msaccess/article.php/3605656/Implement-User-Preferences-in-MS-Access.htm

I have lots of forms which all look the same as they are based on a template. They look like a website with a header bar, a sidebar on the left for navigation and a body section with the logo in the top left. It may sound silly, but I need to place the colors of form elements (header...

Thanks all. In fact, I've been using a pivot table in Excel for a while. I use pretty much the same, indexing function and at one time I'd filter on a list of unique school names and use a variety of formulas. Even if simplified, it does require an export step. Helen Feddema also has a VBA...

I have login form (frmB) placed as a subform on a parent form (frmA). When a user logs in, the login subform (frmB) opens another form (frmC). I then want form (frmA) having (frmB) to close. frmC opens OK, but... DoCmd.Close acForm, "frmA" does not close frmA. Why not? I'm using...

The Doc Man makes a point I've seen in various books and postings. However, exceptions occur when some of the data elements have different security requirements than other elements, even if they meet the above criteria. In my job with the U.S. Dept. of Defense, we see cases where certain data...

I noticed this listing is from 2004. Is there a more up-to-date listing of great add-ins for Access 2007 and up?

So I guess the best practice on the lookup is to place it in the form, but use a query linked to the table which contains the lookup values. That way you can sort the lookup values to make it more user friendly. If it's a saved query (rather than one that's coded into the control directly)...

I saw the blog at: http://blogs.office.com/b/microsoft-access/archive/2005/10/19/access-12-security-model.aspx but got little out of it. I finally tried to parse it manually. Here's the result for the operative paragraph (I still get little out of it). User level security - old version...

I'm not a guru developer (I'm probably an advanced intermediate), but I know folks and have had to turn down a few assignments because I'm too busy. I guess they like me because I charge so little. I'm worried that if I say no too many times, they'll forget about me. Anyway I got the idea of...

Does anyone know of a Access database for tracking laboratory or clinical samples/specimens? There are stand-alone programs, but I prefer it in Access. It would have to accommodate multiple storage locations (freezers, refrigerators), print barcodes and provide for instances where one...

That database works fine! But I noticed numerous table-level lookups (which I myself tend to use). I've read in this forum that we should shy away from such a table-level lookup design. I wonder what's the best way to do that? PaulWilson

I don't see the USysRibbon table in my NavPane even when hidden objects and system objects are selected under Access Options. What gives? I'm using Access 2007

Of course, the newer versions of Access export the Database Documenter output to Word and to Excel as well as to rtf, pdf and XPS. The only dang problem is that the Excel export is all screwed up. I spent some time trying to get the output into a proper table in Excel so that I could filter by...

Another method to accommodate a heiarchy is described in the queries chapter in the Access Cookbook. It's a self-join concept where one table provides all of the information and you can have many levels of supervisors and supervisees. It's recursive. Don't quote me on the book but it's by...

On the subject of AutoCorrect... I know it's not perfect and folks like Allen Browne have done a good job of describing the problems, but we all need to rename database objects from time to time. I find that AutoCorrect works with Table and Queries. The fun stops there. It won't reach into...

Re: Using the validation rule based on a value of a field in the same table! I have two yes/no flags in a table of phone numbers. One indicates if a phone number is active. The other idicates if a phone number is the preferred phone number for making contact. Obviously, if a number is preferred...

Folks, I have a database that maps students to their schools. I set up a junction table relating students to schools so there is a many-to-many relationship between students and schools. One student can attend many schools and any one school can serve many students. The tables are nicely...

Folks, I made a sample database of authors and books (after getting a bit of help from this forum). It seems to represent the classic many-to-many relationship. It works, but I am under the impression that I did not use the current "Best Practice" in making the form. For example, I used a table...