Search results

Holy mackerel Batman! What is the objective of this query? Who are you giving it to and how will they interpret it, and for what purpose (purchase orders, financial reports, etc.)? What do the letters in the BOM fields mean/indicate? What do the sub queries look like?

You can use it at the time you do the evaluation, if you want. Just use Nz(myobjectname, mydefaultvalue) (off the top of my head-your job to look up the syntax) instead of myobjectname.

You create a junction table between the two. I normally name the junction table after the source tables: AthleteEvents, for instance. In this table, you will keep a foreign key (FK) reference to the athlete and an FK reference to the event the athlete is about to participate in or has...

You might want to take a look at how the In() function works in help. I'm pretty sure it's not gonna work this way. Also, you have a space issue, though that doesn't matter since it's not being evaluated anyway. FieldName In(value1, value2, value3, ... valueN) You should assign the string...

Let's try to keep this to the forum so we can all benefit. Merrie, I believe what you are missing is the concept of a M:M (many to many) relationship which is normally implemented via a "middle" table called an associative or junction table. Look up those terms in help and google. You...

Colin is right. And you don't want to copy fields already in one (or more) table(s) into a 3rd table, just the reference to those tables (preferably as an auto-number primary key/foreign key pair). Why not just look at the Northwind database that comes with Access? It probably already does...

Take a look at the Nz() function in help. You can use it in the middle of your expressions to give nulls a default value.

That's a nice trick. I just wrote a little counter on the click event of my text box like this: msgbox(len(mytext.text)) When I see problems like this the first thing I think of is the tens of hours I spent tracking down and then fixing a "feature" of Office that limits text field in an export...

If you need to rely on Iif statements like this, something is wrong with your design. There is absolutely no way to advise you other than that with the information you've provided us. Let us know what the tables look like and what your entire SQL statement for your query looks like and we can...

Please describe how you know this is happening. Are you physically counting the characters in the text box? Or are you depending on an external tool to tell you? If you look at the table's data view, that is not a valid check. If you export data to another Office tool, that is not a valid...

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

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?