Search results

Hi it's me, the original poster. I've read the thread with interest, but can't claim to have fully understood all of it, as some of the more technical discussions took me beyond my comfort zone, in programming terms, that is. What I've decided to do is abandon any idea of simply using a...

Hi Pat, Thanks very much for that helpful reply. I'll give it go. Prof.

Actually, I believe you're right - giving them access to a Table isn't really a good idea. I think I can probably achieve the same effect by using a Query. Thanks. Prof.

Hi, I want to be able to open a Table as Read Only, so that a user can browse etc., but neither alter nor enter data - I want them to use the Forms for that. How then, using VBA code, do you open a Table as Read Only? Many thanks, Prof.

Hi Lagbolt, Thanks for that. This worked well for me, did the trick. I had assumed (perhaps rather naively) that I would be able to set opening position in the Form Properties Sheet. Anyway, appreciated the help. Prof.

Hi, I have a modal, pop-up Form, that I'm using as a dialog box. But, when it opens, I want it positioned on screen in a certain place, but I'm struggling to work out how to do this. What properties do I need to alter/set, to achieve this? Thanks in advance, Prof.

Hi, The option group wizard won't start and I can't work out what's wrong. The 'wizard icon' is activated and all the other wizards are working OK. The Option Group had been working, but now it's not. Not aware of anything I've done, and no updates recently, either. I've run the Office Repair...

Thanks for those who offered help with this problem and I'm pleased to say that the issue has now been fixed.

Hello Big John Once again - thanks for that, did the trick nicely and I learned a bit too! Great. Cheers.

Hello Big John, Thank you very much for that - very helpful, worked a treat. I've now put a second ComboBox in place on the form. In this second box I've hidden the key, which doesn't need to be shown here, because the ComboBox lists Post Codes - but how do I get it to list the PostCodes in...

Hi, I have a ComboBox on my form which was built using the wizard. When the drop down is activated, it will list from the Customers Table all the Customer IDs, and allow the user to jump to a particular record. It does this job perfectly. However I want it to do more than this, two things in...

Hi Pat, Thank you for your reply and appreciate your help. All the controls (txtboxes & their labels) have absolutely identical formatting and I have indeed used the format Painter to make sure I've missed nothing. By default, when the form is loaded, all controls are both enabled and...

Hi, I've created a form and placed various fields with their associated labels on it. Under certain conditions VBA code will disable some fields along with their labels, which is fine, and all is well, except for one thing - the appearance of the labels. Some labels take on a flat, mid-grey...

Hi, I'm a new to this forum - so hello to you all. I'm a hobbist programmer from Cambridgeshire in the UK. I've used Access regularly for over a decade now, albeit on a casual basis. I've also used VBA to a limited extent, to help customise Access and improve functionality. Although I...