Search results

Davebert Can you post a copy of what you have so far and perhaps tell us something about the database you want to create.

Sorry, I didn't notice that the question was in the Excel forum :sleep:

Set the Indexed property of column A to: Yes (No Duplicates) in the table properties.

The combo boxes from which you choose players' names need to be bound to a Recordsource so that the selection is saved somewhere. I've noticed a few of other things that you should perhaps look at; Some of your tables have no PK You have Lookups in tables. You have repeating data in tables e.g...

So which form are you having problems with?

Indeed. So show us a picture of your relationships window or post a copy of the db.

But what tables do you have? Tell us about your tables.

Can you give us some detail of what your data is about and the need of these calculations. Perhaps a screen shot of your relationships as well. To me, your reference to cells smacks of at db designed like a spreadsheet.

Can you post a copy of the db, or at least show us a picture of its' relationship window.

Nor on my A13. When I have a poor mobile signal and I'm calling a mobile number, I make the call with WhatsApp. It even allows me to call abroad for free :)

There's a host of references suggested in this post: https://www.accessforums.net/showthread.php?t=65220

I have no wish to offend you. I am only trying to help. IMHO what you have posted is an Access file but it is not a database; You have some tables but none have Primary Keys. You have no Relationships. There are Look Up fields in tables. Spaces in the Names given to some objects. I think...

Forgive me if I've misunderstood you, but when you create/edit a relationship in the relationship window, you are presented with a dialog box that allows you to set referential integrity.

Not sure about graphics or Active X labels but for native Access controls you can set the "ControlTip Text" property of the control using the Other tab of the property sheet.

Have you tried: DoCmd.Close acForm, "FrmFrontEnd" DoCmd.OpenForm "FrmEmployees", acNormal

I think that the OP is a new member. Perhaps he doesn't realise how helpful it might be ;)

Perhaps try: DoCmd.OpenForm "frmFrontEnd" Also, the "acSaveNo" in the following line is not required DoCmd.Close acForm, Me.Name, acSaveNo

try stepping through the code As far as I can see "stLinkCriteria" has no value

JarryE said: I'm a little bit confused. If you think you have a good and functional design why would you not ask why the comment has been made? The file you posted in post #7 is indeed, an Access file. However, IMHO it can not be argued that it has a good and functional design. For example...

Why not sort it by the appropriate column?