Search results

I’d suggest you start off with 2 tables: one for company details, and one for invoices. TblCompany details: CompanyID CompanyName CompanyAddress Skip (Store this with the individual company details) etc. ect. TblInvoices InvoiceNumber BilledTo CompanyID CaseNo Court DateServed...

Thanks for all the suggestions etc. I don’t think that I’ll try the “Mitch” approach though. Although I do wish that I’d had The disable shift key sample beforehand. I’ve got a meeting next Wednesday to justify my actions, and the line I’m going to take is that as the DB is property of the...

I've just got back from the pub, so excuse any obvious missthinks!! Add the lesson date and time to the sessions table and this will populate the list of available sessions on the bookings form.

Have a look at the attached, is this the sort of thing you mean you mean?

SendObject Method Have a look in the help files for the SendObject Method. Rob

Once the shift key is disabled, is there any way to get round it?

No you're not alone, I have the same problem using with win 2000 on my work laptop, sometimes I even get messages asking for the office cd and have to reboot before I can access help.

Assisstance system A while ago I was playing around with similar system for a learning centre with the same budget constraints, Have a look at the attached zipped files. AssessorsDatabase.mdb StudentsInterface.mdb StudentAssistance_be.mdb You may have to re-establish the links between files...

Thanks, but that's one that I did try and it works with Excel but Access isn't supported.

I must admit that I've tried to avoid using user groups / permissions since a bad experience with access 2000 (to embarrassing to go in to details!). But thanks for the suggestion and I’ll maybe have a go. Can you set user level on modules?

Yep! But I spent a whole afternoon trying different downloads (v. time consuming @ 56k) and couldn't find anything which lived up to it's claims and can do the job. Maybe you could suggest one that will... Cheers Rob

Thanks I had thought about keeping master files then creating updated MDE files, but as the applications are updated daily by users on 7 sites, this would have meant loads of work importing tables etc. for each update, but in retrospect, that's what I should have done. Rob

I've found plenty that will crack the DB password, but can't find one for the VBA Project.

Thanks for the suggestion Fire him - It's me that's going to get fired!! No I didn't create a MDE because it's an ongoing project that I have to keep adding to. As far as I know, you can't update the code in a MDE the same as you can't in a .exe Rob

:eek: I recently had the misfortune of one of my ‘colleagues’ downloading some software to crack the password protection on the VBA modules included in a database I’ve built, and then, doing quite a bit of s*** stirring because of a couple of little insurance policies I’d included in the code...

Please do let us know what grade you get for this monster application!!

I think you may be struggling to get this project done and dusted for this afternoon!! However; what I suggest you do, is to look at your tables, and determine which field is the primary key in each table – if you look at the table in design view, the primary key will have a small ‘key’ icon to...

Hi You might like to try creating your own functions to do the job for you. Open a new module and paste the following code after “Option Compare Database”: ‘######################################################## Option Explicit Dim LenField, Start Function getFirstBit(OldValue) If...

Re autonumber / compacting Thanks for your response, and your translation! This is basically how I interpreted it, but I’ve experimented over again using office 2000 and XP and still can’t get the autonumber to reset. (PS This isn’t something that’s critical, but it’s just bugging me that I...

According to Access help re. Compacting a database: “in an Access database, if you have deleted records from the end of a table that has an AutoNumber field, compacting the database resets the AutoNumber value; the AutoNumber value of the next record you add will be one greater than the...