Recent content by eggwater

thanks fella that is really useful info. I'll track down the culprit... I'm pretty sure i know who it is. My problem is doing work on a database I haven't dicked around with for about 6 months. cheers have a nice weekend.

I have a number of users using a database. They input data using a form. The database is split into Front End, Back End and i'm pretty sure that the record locks are set correctly and the users should not be able to delete records unless it was by accident evn so it would have to follow a number...

and that goes where? will that close access before the new application opens? sorry to be a pain

hey that works and I have no idea why?! cheers anyhow one more thing - can I do a command that closes the database with the switchboard: something like DoCmd.CloseCurrentDatabase ?? god I wish this programming gubbins would stay inside my brain! cheers

sorry I'm not sure what's going on with that code anychance you could explain it a bit to me? I was using this: Dim stDocName As String stDocName = "N:\NewDatabaseTest\Yr2k2test2004.mdb" DoCmd.OpenCurrentDatabase stDocName

I thought this'd be simple but I can't figure it out. For reasons of laziness and the need for a quick fix I've had to make a copy of my database - FE and BE - so that all records for this year are held in one and last year in the other - (extraneous info: My users need access to this year's...

cheers mile o!! i knew it was simple enough

Hi there I've done this before yet can't remeber how I did it. I need to change the location of my backend data tables can anyone point me in the right direction? cheers in advance

eggwater I think you may to to activate a .dll components file in VBA - open up the VB editor, go to Tools menu and chosse references then have a look at the image I've attached and see if any of your components are different to those checked.

fantastic how much do I owe you? thanks

type mismatch I've used your code and set the field types to text shortdate longtime longtime I'm getting a type mismatch error - what are the field types meant to be in the table?

thanks I'm gonna give your code a try anyway cheers

I know stability is being compromised I'm under orders not to add security, change to FE and BE etc - I think the powers that be think I'm gonna do one and they'll not be able to figure out where my database is and what it does etc... I also know about the ldb file - another reason I want to...

thanks it looks good but for the moment I've been instructed by higher powers not to have password controlled access - hence users do not log in - they just open up the database over the network - security is being administered with trust and lots of hidden objects and only the magical shift...

is there anyway of seeing how many users are using a database at anyone time and if so is it possible to show their individual IP address or something?!