Search results

The cool feature Excel has over Access is it's ability to record macros (which are VBA procedures in Excel). Just record a macro (tools menu), do what you want your form to initiate, stop recording the macro, modify the procedure in question to be a little more automated, and call your new...

This has all been done before. If you can't figure it out, why not try one of the fine starter databases that already work? You can modify them to your hearts content. The Northwind database should cover most of the functionality you need. It comes with every version of Access and SQL...

So in your form put the date in when you know it. If you want the system to use the current date, one way is to add an event handler to the date field something like this: Private Sub YourFieldName_Click() YourFieldName.Text = Date End Sub To get to this point, go to your form in...

Yeah, what he said.

Take a look at the attached. You need to step back a little bit and look at this. Keep it simple. Don't re-use stuff that doesn't work (delete it). Please notice that I set the referential integrity flag on my relationships. You should do that, though you don't need to cascade. Also, you...

Date()...same in Excel VBA. I am very confused as to why using Date() or Today() or Now() or Anythingelseyoucanthinkof() has anything to do with the persistence of a date. One might also wonder (as I do) why you're storing the current date and/or time every time you look at a table. If you're...

Can you upload a picture of your relationships window?

Good luck, Merrie.

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're a funny man, Benny Hill. And your political advice is just about as good as all the funny men in the US.

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

People are still delightful here. You're welcome to return!