Recent content by peted

Thanks, for volunteering, Ken. I can't even save it as a .mdb for you to have a look at, because in order to do that Access needs to close all open objects, which it can't because of this blasted code in the On Unload event. So, is there anyone else out there who thinks they know what the...

Cheers, Ken. Here it is, although it's not .mdb as it's Access 2007. The data is just test data, not real patient info! I noticed when using explorer that there's an associated Access Record-Locking information file. Would that be anything to do with the problem?

I'm not getting that error message. I can make a copy of the form, but I can't open that in design view either.

I just typed it into the On Unload line of the prooperty sheet for that form.

I've got a bit of a problem with my database. For reasons I won't go into I set the unload event of my main menu form to "Cancel = True". I thought that's what I wanted to get round a problem I had, but it turns out it isn't. Anyway, I now can't change that Unload event as this form no longer...

Actually, I've just worked it out. The term Me![HospNumber] in the code was wrong, and should have been Me![combo0]. As I said I'm new to this and had tried to work the code out form another database that someone else had set up. So now it works and I think I understand why.

I had a look at the thread that RexesOperator pointed me in the direction of, and I'm afraid to say I couldn't undertsand it. Has anyone got an idea of where I'm going wrong with the code I've posted? Thanks

I'll have a look at that. In the meantime, here's the code that I've been using (please bear in mind I'm new to this and have butchered it form another dbase): Private Sub Open_Audit_Proforma_Click() On Error GoTo Err_Open_Audit_Proforma_Click Dim stDocName As String Dim stLinkCriteria...

Thanks, Curtis. That didn't seem to work, but I did change column count in the properties, and I can now see both name and ID when I click on the combo box. So that's problem number 1 sorted. Anyone got any ideas for the second issue?

I’m working on a database which stores information on hospital patients with neurological disorders. There are currently two tables: 1. Audit_Proforma (which stores info on the patients and their medical history), and 2. AED (which stores info on their drug regimes). What I would like is a...

I've tried setting up the one to many relationship, and that doesn't automatically take the data across. I'm afraid I haven't got a clue about form/subform set-ups so will start delving into my Access for Dummies book to see if I can get it to work.

I’m sure this is really simple, but I can’t figure it out. I’ve been working with Access for a few months, but have been playing around with forms, reports and queries on pre-existing databases. Now I’ve got to design my own from scratch and have come up with a problem. I’ve been asked to...

Thanks for your replies. Prior to receiving them I decided to start my form all over again. This time it worked (using the conditional formatting method rather than writing code). I didn't appear to be doing anything differently, but presume I must have been. I am using v2007, so it may be that...

Thanks for your reply. I have tried putting that code in the On Current, and it still doesn't work. By which I mean the boxes remain disabled no matter what is entered in the PartialSz_combo_box. Everything is spelled corrrectly,too. I'm not entirely sure what you mean when you say ensuring it...

I have got 3 combo boxes (named SP_combox_box, CP_combo_box and Partial_evol_combo_box) which I only want enabled if another combo box (called PartSz_combo_box) is filled in as “Yes”. I’ve tried two different ways to do this, neither of which works. The first was to write the following code...