Recent content by ConneXionLost

The resources available for text formatting in an Access query SQL window are primitive at best (no tabs, etc.). What method do you employ to overcome this?

Hi CC, Based on your example, I think this might work: SELECT Cases.Case_ID, Cases.CustomerName, Cases.Cost, Cases.Initiated, qsub2.Event_ID, qsub2.Event, qsub2.Date FROM Cases LEFT JOIN (SELECT Events.Event_ID, Events.Case_ID, Events.Event, Events.Date FROM (SELECT Events.Case_ID...

A solution similar to AccessBlaster's but with a different arrangement/structure. Cheers,

The source query for that combo box returns three columns of info, but you've set the combo box to only show the second. Either change the source query or change the display of the combo box. Cheers,

Here are a couple of references: Microsoft Tek-tips Cheers,

Sadly, this and many stories like it are true. This is generally known as the hazard of "Confined Spaces". Also, it isn't just onions. Many things, when they decay, can give off large amounts of CO2, or just push out all the available Oxygen. It isn't always that easy to notice when you've...

My apologies Vassago. When I glanced at your post, I thought the link had something to do with "the origins of the word F**K", as per your first sentence. I will endeavour to examine all your posts with greater scrutiny in the future. :rolleyes::D Cheers,

The story is entertaining, but the physics and the history don't support it: Brass Monkey Cheers,

In Excel, a data validation list (named range) must be a single row or column. Sorry,

If you're looking for software outside of Excel for this, then try: Dundas; or, FusionWidgets. Cheers,

Hi, Some things about me? Aikido, Guinness, Computers, Access, Excel, Web Design, Wine, Blues, Science, and a good cup of coffee. (Not in that order.) Last but not least, Happy to find this forum! Hope to get to know you. Cheers,

What you're referring to is a many-to-many relationship. You'll need to create a third table (child or associate table) to resolve the problem. Cheers,

What happens to the size of your file after you do this? Compact & Repair. Cheers,

Hi, Actually, Excel sees the colon ":" and attempts to interpret your time values as cell/range references. For example, Excel interprets 5:32 as everything in rows 5 to 32. It is possible to enter times in a formula, but you'll need to use the TIME function to do it. For example...