Search results

Table: Events ID Date Description Etc Table: People ID NameStuff Etc. Table: Attendance ID PersonID (FK from People) EventID (FK from Events) Comments/Etc Table: StuffThatCanBeBrought (a loose categorization just to demonstrate the concept) ID Description Category Etc Table: EventSuppliers...

Welcome, yewagner!

Welcome, Trappergirl!

Welcome, Andrew.

Drag. Sounds like it's broke and nobody wants to acknowledge it. I really appreciate you guy's responses. I'll be able to work around the bug with your help! Thanks!

I think you're trying to do this: http://allenbrowne.com/func-concat.html The first time I tried this, it took forever. I don't know that I'm any better at it now than I was. HTH

I've run into an oddity using a unique index. First let me review the rule. Let's assume a simple thing like a person's name: ID - Surrogate Autonumber key FName - Text MName - Text LName - Text Just for argument's sake (not because I believe it), you should not be able to store information...

I assume you're using a query to get the data to export. Your query should look something like: select format(mydate, 'dd-mmm-yyyy'), myothercolumns from mytable where myconditions = somecondition Take a look at...

Sorry I haven't posted in so long and am showing my laziness by asking this instead of figuring it out myself. I would like for my users to be able to write a query and then assign the query as the recordsource for a form. This will allow the advanced user to re-use already designed...

I can't even begin to wrap my head around BigTable. It looks like that is the ideal way to do what google does and it seems like an ideal way to replace distance algorithms. I actually considered using google earth or google maps to resolve my business problem but so many of the businesses in...

I've tried just about every method known (at least, every method known by me). In the OP's case, he is dealing with something moderately simple (comparing 1 horse name to all other horse names). I am confused by looking at the samples, however, because there is no indication that there is more...

All distance algorithms take a lot of time. Yes, I have use the Jaro-Winkler algorithm in the where clause and it takes forever. I finally decided to do the Jaro-Winkler distance calculations in the select clause (it still takes a long time) and store the results in a table with the primary...

Man, I hate those surveys viruses.

You know what, now that you mention it, I re-read the post again and I see it the same way. That pretty much invalidates everything I've said in this thread, at least for this problem. Thanks for setting me straight.

Ditto, I get a failure when I do a search including the word "form".

If, for ANY reason, a developer is considering overwriting something that is supposed to be unique, whether it is because of a bad design, a misunderstood requirement, or the fact that we just don't know enough about some classes of data to define what is really unique, you STILL need a unique...

That's weird. I cannot post to this site unless Adblock Plus is enabled.

This is a known issue with Firefox. The fix seems to be to run Adblock Plus on Firefox.

In the "On Click" (or whichever you want to behave this way) event of the control, put some code similar to this: ActiveControl.SelStart = 0 In place of "ActiveControl" you could put the name of the control. You can get to the "On Click" event of a control by right clicking the control in...

Really bad idea. There was also no good reason to do it in Access, even if it was available. This is the type of behavior that gives Access a bad name. You should consider the use of artificial (aka surrogate) primary keys at the very least, along with unique keys on the current "primary"...