Search results

Many thnaks Doc_Man I guessed it was something i was doing wrong have cracked it now, problem was how i had things set it was only letting me have an Intermediate relationship, which was causing the problems. a few minor changes and now have a many to one relationship which works fine Cheers...

Ok I think I have gone brain dead today. I know this is so simple but it eludes my grey cells today. I am creating a small database to identify tooling and usage. Have one table detailing all the tooling info, and another table will identify usage repairs etc. Am trying on the second table to...

Many thanks, have not worked with ASP before so back to exercising the brain cells once again :rolleyes:

sorry for the delay been away a few days. this looks interesting will try to figure it out and get back with any problems

using access 2000 we want to be able to add date, view data etc. don't really wan tto go back to square 1 by creating all new data entry pages as web pages. we are mioving slowly to putting all our internal info etc as a website on our server. all we really need to do is be able to open the...

Hi i had the same problem a few weeks ago, and ended up using a table which you can set the time to automaticly log anyone out. how it works is say you set it for 30 minutes, it will flash up warnings at various intervals to warn users and at the given time will shut down the database. if it...

I am baffled here, I have 2 databases, which we use on a server, and I am trying to get access to them via a web page hyperlink One database opens fine, while the other goes through the motions i.e. message comes up saying do you want to open or down load. On pressing open nothing more happens...

On the scrounge Hi I am organising a football tournament later in the month and am looking for a programme which will update league tables etc on entering results. I do not really know where to start but was hoping that someone may have created something similar which they would let me have...

Sorry to topic jump however this has been on a few days and no response. This is a serious problem my colleague and myself have been trying to get round. After a serious corruption occurred last week to our database. we are trying to ensure therfore that when all users log out we can compact...

Ok hopefully sorted now found a link in another message for services run by someone conected to this site i believe www.access-programmers.co.uk, they seem to be able to salvage it so i will leave this link here for anyone else who may have similar problems...

Pear shaped database Hi there got a major problem Have a database used by multi users which seems to have gone tits up When trying to open it get a message saying file can not be opened file already in use, however there is no LDb file in the directory Yesterday was getting the problem...

The example Wayne sent still keeps the before update and also puts the code in the default value of the text box. Do not know if this is the done thing, but put in it my database and it work a dream. We only have about 30 users and as the database is mainly for customer complaints etc (...

Last message a bit premature, have created small database attached with settings as I have in my database, still not working could someone take a look and see what I am doing wrong. I got it working once in main database but then obviously somewhere cocked it up again. TIA

Doh ! Silly me. Now sorted i misunderstood yu and put code in form event procedure. removed that and just marked as event procedure and works fine. well you learn something every day they say. Many thanks for you help on this problem.:) Cheers Paul

I think this may be the problem Me.txtNumberField = as when i complete a record an try to move on the new record i get the message. "Method of data member not found error" message. should me relate to something ? probably a dumb question. Also do i put code in form event and feild event...

No, No events are on the form itself

Oh dear oh dear. i do not get any message box, put you code in and aslo tried with square brackets ie: Private Sub complaint_No_BeforeUpdate(Cancel As Integer) MsgBox DMax("[complaint No]", "[customer contact]") Me.txtNumberField = DMax("[complaint No]", "[customer contact]") + 1 End Sub...

Still returning 0 as value:( could it be something to do with the fact that previous records were created using autonumber ? and bususe of this there are gaps

the table is also called customer contact so that would not really make any difference would it.

I know there are several threads dealing twith this issue but i must have mised something. Am trying to change my database for Autonumber to finding the next highest No using the following code Private Sub Form_BeforeUpdate(Cancel As Integer) Me.txtNumberField = DMax("[complaint No]"...