Search results

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"...

What's a joinery company?

Not at all. As a matter of making your life easier, you should probably go with artificial (AKA surrogate) primary keys (with autonumber type). Make your current primary keys into unique indexes, then use the number type as your FK in the related table. Second, there is absolutely no reason...

No problems with the links. Looks like the problem is on your end.

You haven't really told us what you're trying to do. Referential integrity is there for a reason. If you don't need RI, turn it off. For a better answer, give more information. What do your tables look like? What are you trying to do and why?

We are updating our SQL Server this Wednesday night and a last minute issue has cropped up to threaten our implementation. We are changing all of our Access front ends to use DSN-less connections and won't be updating the DSNs on the client machines. We did a pretty thorough check of all the...

I think that's the word we were waiting for, Jon. Seems there is an issue with propagating the new IP address, I guess. The IP address I have is 64.57.208.119, which seems to work just fine.

Jon, you might want to hold off on taking any action. Further PMs from Rookie may indicate that at least one of their domain controllers had the old IP address in their hosts file. I don't really know the details so I suggest you wait until one of us hears back from Rookie. If this turns out...

MSAccessRookie tells me that he has not been able to access AWF since last week from his work. Here is one of the PMs I received from Rookie on my FB: BTW, the thing I recommended he do is to put AWF in his hosts file. This might explain why the traffic on AWF seems to be lower than before.

Odd; when I hovered over this topic, the popup never went away (until I moved the cursor away). In the past, I found the hover timeout to be too short. Somebody must have already fixed this. What about you? Has it changed for you, too?

Or store your "autonumber" in a different table with a FK from the table that references it.

You need to put your aggregate functions in your query, not in the text box. Then bind your text boxes to the aggregated fields within the query.

It is in common usage in the US, also.

Music Performers unknown Legend of Zelda: Ocarinia of Time Medley Composed by: Duncan Blickenstaff http://www.youtube.com/watch?v=0guFHIGxvmc&feature=related Notes: Nintendo, Zelda, Ocarina of Time, OOT, string quartet

I really like the "Hallelujah" versions. I especially like how that song just keeps growing. Here's one I've recently "found": Music Kansas Byzantium http://www.youtube.com/watch?v=QO2BJOadcjo Notes: orchestra/rock fusion