Search results

Thanks Thanks very much I'll give your ideas a go.

Is it possible to run a query to find out when (ie date and time) another query (or report) was last run? If it isn't possible to do this by a query is there a bit of clever visual basic I could use? I'm fairly OK with queries but a complete novice on visual basic. The reason for asking this...

I have several queries looking up products from a table. I use a simple form to access the query and in the criteria of the field I use [Forms]![EnterCroft]![ProductName] to filter by name. (EnterCroft is the name of the form). It works fine but doesn't like the asterisk (*) for all products...

Thanks yes that will do fine. Thank you very much

This is going to sound really stupid but I urgently need to have one form, where people can enter a product code and the description automatically shows in another field. I have two tables, one for the form and another with all product codes and descriptions. Presumaby I would need to make a...

In either a label or text box I know it's easy to centre align the text horizontally but can text be centre aligned vertically, as can be done in Excel? :confused: Thanks in advance

Thank you, you were absolutely correct, phew! I was worried I'd done something really stupid. Thanks again, much appreciated!!!

I ma going to sound a complete idiot with this question, but I have been working on a database for some time now, successfully putting buttons on forms with the wizard, jumping from form to form, form to report, basically the button wizard used to work now it doesn't and I don't think I have...

Sorry to be a pain, is the workgroup setting in the registry H_KEY\CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\10.0\ACCESS\JET\4.0\ENGINES\SystemDB This seems to show the path to the workgroup file, so does this explain The_Doc_Man's answer? If so I have another question - assuming a user has the...

Thank you very much indeed. Being a complete novice on Access (it was banned at the last company I worked for as it was deemed to be insecure), I have much to learn. What I am trying to do is create a simple database of customer complaints on a shared folder on the network, but I want to use...

More question? Here's another stupid question of mine - assuming a database has been secured (and I clearly have a lot to learn here) isn't it possible to simply create another database and import all the tables, queries and so on from the original. I'm sorry to be a pain in the arse but...

I'm always happy to stand corrected. Thanks.

Thanks Peter, that's what I thought. I've created a simple database on a network drive, as you say you have to give the users sufficient permission to get into the database. It's quite frustrating after spending hours on the damn thing to be told that the security can be easily bypassed...

Security? Im with Blindrhino here - it seems to me that all you have to do is delete the "secured.mdw" file and you're into the database with full administrative priviledges. Or you can open Access, go to "File/Open", select the required database file and you're in again! After hours of...