Search results

perfect! that is great, many thanks indeed! must not be so pessimistic in the future!! ta John.

cheers IMO have done that too... even when the box is locked there is nothing to stop the user clicking on the box, although access wont allow any updates.. this is really a cosmetic issue, but it would just add a nice touch to the form. what i think I need is a way to place a transparent...

hi thanks for the advice, have already tried that I am afraid. What I seem to need is a way to stop the user from selecting the Textboxes, but still able to use the scrollbar.. I think this could be an impossible dream!!

right! I am not sure this is possible but will throw it out to the forum in case I am just being pessimistic! I have a form with a subform. This subform is purely for information purposes. The only interaction I want the user to have with it, is to use a the scrollbar if neccessary. Therefore...

the end of that! well dont really know what it was in the end.. I remade the database as a basic table, 1 query and a 1 form, no modules or extra background code at all, and the problem still remained. I took off the autonumber, added it in again, and the dbase stopped producing the error...

grand! Thanks Pat, that works a treat. It really helps speed up the data entry times for entering Date of births.. many thanks John.

hi there was an old ldb file in the directory.. did not think of that affecting it.. so have deleted that.. fingers crossed this solves it.. many thanks for the help. john.

I have a simple data entry database, but the users are encountering the error relating to 'this database is locked by admin "PC number". this appears when one user is in design mode, and therefore access 2000 does not let others access the db. but no one is in design mode. all users are...

cheers mark & ghudson Thanks for the code and your help. we always have our date of births split into dd mm yyyy, so this code works a treat. many many thanks John.

I have a form where the user enters the date of birth into thre seperate text boxes. day, month & year. what I am trying to do is get the form to jump from one textbox to the next where the user has typed in i.e. 01 for the day, the focus jumps to month, they type 08.. the focus jumps to year...

try this! my colleague put this code into one of our databases, I do not know a huge amount about it, but I tested it out and it seems to work. although you may need to find a way to specify/limit the fields you want to autofill.. also in the form in question in the on current event you must...

Hi, I am having a problem with my email code. I have up to 10 different projects which are included onto the bulk of the email message. I previously had 10 forms which populated a final form. the code below then grabbed the data from each txtbox. that was quite clumsy though, so I now have a...

I'll give it a go! thanks fizzio for the advice, will give that a go. Hopefully i can finally get this problem sorted!.. cheers John.

I have been struggling with this Filelen problem, and was then happy that I work out what the problem ws, but unhappy because I am still unclear on how to sort this out! I previously had a problem with filelen, I was running a search on a directory and returning a count of files which matched a...

I assume you have a user-id with the password.. therefore when the user types in their id you can use a form and visual basic to email that person.. you can store the names of your user so that outlook can pick up the recipient... have a search on this forum for docmd.sendobject or for...

thanks for the amended version... I have tried it, but still get a error with the filelen.. runtime 52, bad name or number... it just does not seem to like the process of giving mysize the value of filelen... maybe it is due to the fact that filelen seems to be only used with a specified...

sorry I also meant to add, yes, at present I am filling text10 with the value of thelength... but as a final product I want to be able to return the amount of files over a certain size.. so that the routine only counts the files that are eg.. 50kb or bigger.. ta John.

cheers! a big thanks for your help, I feel very stupid about not realising that I needed to assign the variable! have put in the changes to the code but am still having a runtime error 52, bad name or number. relating to the filelen line... its all very strange... do you need to define the...

hi, I am stuck on the filelen() command within access.. within vb I have the path stored and then I need filelen to tell me the size of the file which the path depicts.. I have : Dim intcount As Integer, varFile As Variant, objFileFind As Object, mysize As Long, mylength As String Set...

apologies... I should have put that in my last post. the report is based on a query... on the query is a field (projectscode) I am using this to tell the code where and what to look for.... ie.. findfile projectscode & ".sav" look in "h:\" & projectscode so for each row on the...