Search results

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?

If you look at the backend db you posted, you will see that none of the tables has a PK. Anyway, since you have marked the thread as solved it's a moot point.

As far as I can see, none of your tables have a Primary Key and you have no relationships defined

You could zip it and then post the zip file

I see nothing attached to your post

You could do, but you've already posted everything (forms, queries and modules) from the frontend db

Create a new db, then import the tables from the backend db that your frontend db is linked to.

Your posted db uses LINKED tables but there's no tables in the db file