Search results

I found the simple explanation that I needed, on experts-exchange, of how to use forms instead of tables, as spikepl suggested. This was not my post on experts-exchange: http://www.experts-exchange.com/Database/MS_Access/Q_28134788.html.

Perhaps an expert could take one of my tables in the posted database and set it up with a form the way spikepl indicated so that I can understand how to do what he suggests with the rest of the database.

As far as I can tell, I've set the column widths properly on the subform, but the down arrow on the list box is still outside of the selection area. It may have something to do with lookups or concatenations, but I'm not finding that so in what I can think of to trace down. I exagerated the...

I'm trying to understand how to implement what has been suggested. If I remove the user ID foreign key from the class roster table, where would I store the information of who attended the class? To my understanding, we don't want to build tables of duplicate information, in this case, duplicate...

Hello experts, I appreciate your feedback. I actually laid out the structure of the database in the best way that I knew how. And that is pretty much akin to the only way I know. Most of my database is built with lookups. If, with your advice, you could show me how to do what is needed without...

Galaxiom, I removed the Order by in the query for the field and tried the Grouping and Order function on the report, no dice - still won't alphabetize the names. Would you mind looking at this sample database to see what I might need to change? I don't necessarily need the names concatenated on...

I have a class roster report in which the Employees' names are concatenated in a text box. When I select to sort the concatenated names alphabetically, it is sorting by the Unique ID, which is a letter and four numbers. The letter used to match the last name, but newer IDs are random. So most...

1. Where would I insert the DoCommand code to hide/display the ribbon and QAT? 2. How would I set a keyboard entry/combination to toggle between hide and display?

That would definitely give them an advantage! I would love to see a couple like that in the races. I wonder if that would disqualify them.

I missed the inference about adding the timer that this code then does not have a line to stop it from running if the lock file is open. Thanks for referring me back to the post.

Will this procedure run if the backend is locked (open) by another user on a network?

Duolingo looks interesting. I'll have to check it out after work.

I don't know VBA, but have successfully implemented a public module already and so would like to try on this one. After I backup the frontend and backend of my database, I'd like to test implement this code, based on the instructions you give of what the StrPath and StrName are supposed to be...

Recently hired as staff services analyst for my state agency in California. Microsoft Certified Systems Engineer. Enjoy learning foreign languages: Russian, Spanish, Greek. Perhaps take up Mien. Novice access user.