Recent content by fionahl

I started with a beginner's Access course, then I inherited a db, then I started making my own. Along the way I did another Access course. These days I scour forums such as this one and Allan Browne's for help. (http://allenbrowne.com). Somehow I ended being 'the database person' in my...

Have a look at the Properties option for your combo box: List width: Auto Change to a numerical value ie 5 for 5cm width. See if that helps, and adjust for however long you need for your field. This works for me on my Jurassic-era version of Access. Hope it helps with your db.

Thanks from me too! Works a treat.

Old thread, but did anyone actually figure this out? I am encountering the same with Access 2000: External data, select .xls file, import CRASH I've tried with changing to .csv, tried with starting with the file and 'open with', but still crashes. Maybe it just has fridayitis? I rang IT, who...

Fixed it! On the control before my subform, I have the following: Private Sub JobEnd_Exit(Cancel As Integer) Me!frmOccListFillerTable!OccListID.SetFocus End Sub Then, in the subform, I have my control (the combo box with all text), then a small box (unbound) after, with: Private Sub...

I have the tab control set up, so that after the first two controls on my form, it goes to the subform, then to the rest of the controls. Then on the subform, my two items are my text box (with the important stuff in), and my unbound text box with this in On Got Focus: Private Sub...

Thanks for the suggestion SOS I put that in, and it works a treat for the first time only when I tab through. The second time I tab through, it skips it and goes to the next control. I don't understand why it works perfectly once only...

Hi all, I know this is an old thread, but I'm now tacking the same issue. I don't have much programming experience, so any help is greatly appreciated. I mentioned my issue in a thread, and John Big Booty suggested I read this thread for some suggestions. I've tried a few combinations of code...

Thanks for the link John. I've tried a few combinations of code in the On Lost Focus field as suggested by Luddite Lad , however haven't had much success. A few trials that didn't work: Private Sub OccListID_LostFocus() If Me.OccListID = Null Then JobDescription.SetFocus End If End Sub...

I've searched the forums - apologies if this has already been answered. :o I have a main form (patients) with a subform (employment details). On the subform, I have various controls for employment details. One of these is for Job title. This is currently another subform (disguised as a combo...

Hi all, I realise this is an old thread, but if anyone can help, it would be greatly appreciated. I have a db for which I used the above code from Rural Guy (code written by Allen Browne), which works great for locking and unlocking the database to prevent accidental changes. I also like the...