Search results

It think it is 2000. I've adapted it to work in another database with many records, and it still works great.

Teiben, Sorry for all the trouble you're having. The code I gave you works perfectly in Access 2000. There is no way the user gets out of the textboxes with a wrong newly entered date. I also converted to 97 format, but I'm not sure it is a perfect conversion. Did you check every letter in...

You can even make a different front-end for yourself on your computer, referring to the same back-end tables as the users and edit it from there in a completely open application.

Why don't you just copy the users' form, make it editable and give it a password? I don't know where I got the following database, and I don't know how it works when the list gets big, but I think it might be the best way of searching. You can also convert the list box to a combobox and it...

Are you opening Word documents from outside Access on the main form?

The following thread shows how to use a combobox to open specific forms. Could this be adapted as a better solution than opening another form with a search function? Let me work on it. Opening form from combox

Bauer. What you could do is to create another object exactly in place of the disappeared object, which appears when it disappears and disappears when it appears. You could even write a small message in it, or an icon, or anything you can imagine. Pierre.

The second part of the post may be nonsense. Guess-work. I seem to like my own verbiosity. But try it anyway.

Try toggling the Visible property, and not the Enabled property. The Visible property apparently disables a control less intrusively.

I include this very small download of the example I worked out. Tell me if it acts up the same way. It might help hone in on the problem.

Teiben. Could you please clarify what you mean when you say that the user can still save. It does not appear to be the case in the very similar example of that code in attached zip file.

Is it correct to use an equal sign in the coding? not DoCmd.SetWarnings = False DoCmd.SetWarnings = True but DoCmd.SetWarnings False DoCmd.SetWarnings True

Sorry guy. Your explanation is not logical, or else people would be glad to help. It does seem to be a Case Select or If Then ... Else If .... situation.

Could it be that you should put the date text boxes outside the Option Group?

Stacey. I converted the file to 97 format with Access 2002. Hope it is still functional. Pierre.

... Except that I got the broker's fee and the price per share mixed up in the summing calculation! But you'd be able to see how it works anyway.

I've got an interesting zipped alternative with all kinds of neat coding in it for you, Nightwing. Of course I picked up neat tricks from your database too. Thanks for that. Pierre.

I just added another subform. But this is kind of spread out, especially if you want to have set groups doing several different investments. Maybe your relationships were good, for what you want to do. See the zipped file.

Nightwing, I'm preparing to become a freelance Access db designer, and helping others is part of the process. I struggled with your database for a while, and I think the problem is that you need an extra table for a many-to-many-to-many setup. As you have it at the moment, it is impossible to...

I really want to answer, but you are unclear on how companies, investors, groups and investments interact (in the real world.) From there I would gladly work out a solution. Pierre.