Search results

Cheer up, chin up! Everybody loves a happy face!

You'd think there would be a free piece of software from google that would do that for you.

Las Vegas? Is that the 56th or 57th state?

Re-read what Galaxiom said and do that. Don't design your table that way. What happens if you get a new complaint? Are you gonna totally rewrite your entire system to accommodate the new value as a column? If you insist on going down the road you're going down, you would be better off using...

IMHO, don't do it. There is something wrong with your design if you think you need to.

I don't know what the word "appear" means. My assumption is that you are using a bound form (I hope). I believe what you are trying to do is to filter your bound form (I hope). Start with Access' built in filtering. Right click on the field you want to filter on, and type in your filter...

I think the links in the post are still valid: http://www.access-programmers.co.uk/forums/showthread.php?t=153307&highlight=2007+command

Yeah, so do I. Which is why I know it's a virus. DEP is one of my favorite virus features.

And you're running it on an OS that is a living virus.

Oracle Designer (top of the line but has been replaced with a newer product). ErWin (Meh, it's OK). Visio (sucks). Dia (sucks). Dezign (dunno). More than you'll ever want to know: http://www.databaseanswers.org/modelling_tools.htm And yes, it is common and necessary for large projects with...

You can do it using DML in a Query window.

"Data Entry" should be set to "No" (see help for Data Entry Property). "Allow Additions" should be set to "Yes". Oh, and it should be a bound form, right?

What happens if 2 people push the button at or near the same time?

It takes somebody like Banana, or maybe Leigh, to even follow along. I just wrote the words 'cause I though they sounded cool.

I wish. It's been 10 years because I'm too lazy to finish it.

Remember, I said "may" (I always leave myself an out). I've been working on an example for 10 years that you and I have discussed before. When it gets down to it, I'll discuss it with you then and try to remember to update this thread.

Actually, this may be useful if your design utilizes polymorphism with a multiple table implementation.

I wish. But Excel and Access do two different kinds of things.

I hope you're ready to learn: http://www.databaseanswers.org/tutorial4_data_modelling/index.htm I don't imagine most members here would be willing to give you their work for your school work.

I'm not sure that people would bother looking before they ask their cookie cutter questions anyway. You know, people would do well to just go through the Microsoft Office tutorials before they even begin (I did). That would eliminate 50% of the stuff we see on here daily. But that is a free...