Search results

You haven't given us much to work with so here are a couple of thoughts: Is your combo-box bound? If it is, you will be updating the current record, not searching the table/query. Is there any code behind your combo-box? Look in the properties of the combo-box on the Events tab. If not, and...

The OP didn't tell us his requirement or even mention what his problem (if any) was. He asked if a function works or not (then going on to say he could use something else?). An odd question since it is obvious that it works or Microsoft would not have included it in the product.

Oh, gratz David! Does this mean you owe us $25?

Also, realize that "NOT IN" is notoriously slow. If you have a large data set, you might want to optimize the query. Since you didn't mention what problem you are having, there's not really much way to give you any further advice.

Your text description does not readily convey what you want. Try looking at Pat Hartman's M:M demo on this site.

Also take a look at Wikipedia's normalization articles (difficult read but worth it for the stuff you can understand) and tdan.com (the website for snobby data modelers/administrators).

You need to look into normalization before you even start a design like this. For example, your "MovieLists" table has a place for 5 actors. What happens if you decide there are 6 actors? 7? 200? Are you going to totally re-design all your tables, forms, and reports? A properly normalized...

Start a new thread.

As Adam alluded to, some program must run on the HTML server to convert the data in your POST into the database. That could be CGI (in any number of languages), PHP, Java Servlets (JSP or EJB), etc. etc. I wouldn't think that a teacher would ask somebody who has no clue to do something like...

Where's the freakin' code?

I see neither "Number" nor "Priority" as a field name in your SQL. Are you sure this is the query you are looking at that is sorting wrong? If it is, why don't you explain why it is wrong again, since your first post obviously has nothing to do with this query. Yes, we all keep data in...

nealberk's question is important: how are you attempting to do this sort? There is really nothing anybody can tell you to help without that information, which has now been requested 4 times. If you're just looking at the table (a big no-no), Access can put the data in any order it wants to...

The DOS program you are running is plain jane ftp. As wiklendt said, the letters are permissions. The "d" means directory. The "rwx" stand for read/write/execute. The 3 sections for the "rwx" are for the different people/kinds of people who have that level of access to the files, including...

Oh man, just noticed this. I'm not a game developer. I was just interested in starting a gaming company that designed databases for MMORPGs and was looking for a platform to develop a demo. I gave up when I found out how closed the industry is. The barriers to entry are/were high. I'm...

Sorry, I didn't mean to come off as mean. But it is a good point. Building a database will tax your planning and troubleshooting abilities to the max.

Looks like coach's link got a "v" stuck at the beginning: http://www.databaseanswers.org/data_models/top_ten_data_models_students.htm Building a database is more complex than troubleshooting why an URL doesn't work.

Mike's thought is very interesting. I would think that many of our posters who normally limit themselves to the Access forums would enjoy "censored" political, religious, etc. talk, as long as the rules were well laid out (i.e. no trolling).

An honest mistake. Now if you'll only forgive all the mistakes I make! But on further consideration, I'm wondering why RycherX is posting this? What is Access shortening his condition to? Is it working or not? If not, what are the conditions under which it isn't working and what is the...

I think you've run into one of the reasons none of the "professionals" on this site like macros. We don't like our stuff to be changed. I'm guessing, though, that Access has shortened it for a reason. Most of your conditional statement is redundant. Re-read the rules of "and"ing together...

Not JUST to speed up queries. There are a host of data anomalies that can be prevented by using surrogate keys. I am a surrogate key bigot because of a several million dollar mistake one of my employees made in her design many years ago. It costs A LOT of money/time to fix this stuff once...