Search results

You definitely forgot to remove the rights for both standard Administrator and User (attention: Individuals and GROUPS as well!!) Since the standard SYSTEM.MDW contains these two (four) accounts, everybody has full access to your data.

You are victim of a tremendous syntax error, since variable fieldnames have to be put in brackets as the following code demonstrates. You should also omit the []-brackets and change your code as follows: Dim i As Integer Dim CompCost As Integer for i = 236 to 265 CompCost = Me("TextID" &...

What do you mean by "copy of a database"? I think that you just should analyse your form in design view for the existing events. I think that deleting the load-event will repair the situation. If you should not find the solution, then you should create a new MDB, import all objects (besides the...

You could simply use a query instead of a table as recordsource for your form. Simply create a new field in this query like follows: FullName: [Name] & "," & [FirstName] and display it on your form.

I once had the same problem and I feared that it was a bug: If you place one or two CommandButtons inside the frame of a option group, the CommandButtons do not work - sometimes. After hours and hours I found the -simple as always- solution: The Commandbuttons have to be in the foreground and...

For various security issues I use the Windows registry. It is easy to hide entries (even encrypted) in it and it is very fast.

I think that the aggregate functions of the query will do exactly what you need.

Sorry, but Access will definitely not change the rowsource on its own. I suppose that there is a "forgotten" function in one of the form's events that modifies the rowsource.

There is some kind of quirk in A2K if you copy controls in EMPTY tabs. It just does not work because the empty tab does not get the focus. The workaround: Place a dummy-control in the empty tab Copy your controls set the focus to the dummy-control Paste the controls Delete the dummy-control...

If you want to use the same keys throughout your application, you need to use the AutoKeys-Macro (with the AutoExec-Macro all you need to know about Macros). The technique is as follows: Write {F2} for the F2-key, {ESC} for escape-key EXECUTECODE SubAutokeys("F2") SubAutokeys("ESC") Then...

If you only want to store the complete Word-Documents inside an Access table, then you could use the Document Administration Wizard.

You should consider using the JPG Administrator Wizard. It stores Grafik files inside of Access without bloating and uses the explorer to manipulate the files.