Search results

If you wanted to be really nasty you could check the machine clock against the server clock and if they were more than a few minutes out dock them say... 4 hours :D

Hi Pat, Thanks for the reply. I'm going to have a play with the silent MSDE install and let you know how i get on - if your interested that is :D - . I think that it would be worthwhile creating some error handling just in case there are conflicts with the recordset routines. Thanks again. TS

Hi, Just a thought, You could import the data into a fresh table and do an append query. An error should be generated if the field names are not the same. docmd.runsql("INSERT INTO NEW_TBL_STAFF SELECT TBL_STAFF.* FROM TBL_STAFF;") If there is an error you could then catch it and know...

Hi Pat, Thanks for the reply. As a matter of interest i found this article on the net. http://www.databasejournal.com/features/mssql/article.php/1494271 The concepts seem to be reasonably straight forward [which is saying something from me :D ] I would be interested to hear your opinion. I...

Try this example: I've ammended the passwords. I wonder if anyone can access the module in Lockin.Mdb or any of the objects in Lockout.Mdb. I hope not. If you use Lockin to open Lockout and you close Lockout afterwards Lockin should also close as well. TS

Hi all, I'm currently writing a DB that uses the FE/BE setup but is only intended to be standalone. I was wondering what the consequences of changing the BE to MSDE would be regarding record locking -with a view to using it in a multi-user environment - and the differences in the SQL language...

OK this should give you some ideas. This will work using a button on the main form. If you are using access 200X then you need the reference for Microsoft DAO 3.6 Object Library. In the visual basic window go to the menu bar and select tools the references Dim Rst As DAO.Recordset '...

Hi all, I've been trying to find a way of creating a simpler access security. In the zip file are two databases. The passwords have been set to the word test Both db's need to be in the same folder. If you want to open lockout.mdb and bypass the form you need to enter the password and then...

___ thanks for the link, i'll give that a look :) Cheers TS

___ That doesn't work either - there is no me to quit as it is a reference to a form yesno SJ I think you are right about instances being linked. Dim retVAL As Double retVAL = Shell("MSAccess " & CurrentProject.Path & "\" & "Lockout.mdb", 1) Would the above code be correct? and how...

Hi SJ, Unfortunately that did work either :confused: :( TS

Hi all, I'm trying to open Database B from Database A and then close Database A using the following code in Access 2000 Function OpenPasswordProtectedDB() Static acc As Access.Application Set acc = New Access.Application acc.Visible = True acc.OpenCurrentDatabase...

:) :) :) :) Thanks very much. TS

Hi, I've had similar problems with forms and the reason was the database had become corrupted. Ken is right when he suggests you should try to import your database objects into a new db. TS

Hi all, I've got a bit of an odd problem. I'm trying to use this code to open a word document whose path is stored in the DB and displayed in a text box on my form. Private Sub CMD_OPEN_FILE_DIALOG_Click() Dim WordObj As Object Dim StrOpenFile As String StrOpenFile =...

Hi Jon_K Thanks for explaining that :) I didn't realise that this was a way of joining. This is certainly the answer to my problem. Cheers TS

Dear Jon_K That is a very interesting solution, forgive me if i'm wrong here; you need all the potential dates in tbl_WorkDays for this to work and the query is a Cartesian product type where the tables aren't joined. Do you know what the impact is when running this query with lots of data...

Hi all, :) Just to be clear i don't mean a Between statement :) I've come up against a problem and i'm really not sure what the correct solution is. :confused: I want to store the leave dates for staff. The most space efficient way seems to be just to store the start and end dates of the...

Yes, Your forms should be based on queries, which are based on your tables. Your queries should be designed to pull the minimum required data for the user. As an example a user wants to view sales they made to a customer. Firstly you could ask the user to select the customer from a drop down...

Hi, As far as i understand it a bookmark is an index that access creates when it opens a recordset. So if you open a form up the bookmark index is created. It doesn't actually relate to specific data in recordset i.e. If you create two identical recordsets by using two identical forms then the...