Recent content by southwestgooner

Hi All, I have a form that creates new records without any issues whatsoever. The form contains four fields that have linked ID's that won't update in the source player table! I have a tables for Category with a autonumber for CategoryID with a list of Categories selected from a Combo Box in...

Hi all, Back from holiday in sunny Spain ! Have added the Array for the c.c. addresses but still not working ! Current code below can anyone see why the email goes to the 'To' address but not to any of the 'c.c.' addresses ??? :banghead: Private Sub SEND_CC_Click() ' Set up the objects...

Hi, Thanks for the replies. I'm not at work due to holiday for next couple of weeks and will look into your resolutions when I return in a coupe of weeks time. Hope the array will resolve my problem will thank if it does and reply if it doesn't ! Cheers, Steve.

What's wrong with this current code ? It seems to be going to the first c.c address but not the other two ! Private Sub SEND_CC_Click() ' Set up the objects required for Automation into Lotus Notes. Dim Maildb As Object 'The mail database. Dim Session As Object...

Hi All, Hope your all having a good day. This newbie to writing VB Code is in need of some help. I am a quick learner so hopefully this will add another string to my bow ! I have an automated email system (Lotus Notes) in a Access database I have created and am looking for the code needed to...

I had some vb code linked to the on load that wasn't required on that form so removed it from the on load in the form properties and bingo. It was some code I wrote to enable/disable some of the controls ages ago but is no longer relevant so not required ! Cheers, Steve.

Your brill pr2-eugin !! Sorted. Many thanks, Best regards, Steve.

Hi, I am relatively new to this database building so please bear with me ! Can anyone help me get rid of an annoying pop up relating to a sub form. I have built a database which has a number of forms with a frm_PartNo subform in. When ever I click a button to load one of these forms I get the...

Hi pr2-eugin That was quick. All sorted many thanks. Cheers, Steve.

Hi, I am reasonably new to this database building and have built one at work which was all working fine until recently. We have all recently been upgraded from Office 2003 to Office 2010 and in doing so I now have an annoying error pop up every time I try to edit/enter data into the form fields...

Hi, Can any VB Code writing experts help ? I am looking to completely disable a record when a specific Yes/No tick box is checked. By that I mean all form fields are locked and disabled when the Yes/No tick box is checked (Yes) Can anyone reply with a chunk of VB Code I can add to my database...

I am looking at getting some training or training material reference books/manuals to enable me to write VB Code from scratch. To date all the code I have needed has been grabbed from somewhere else and tweaked to suit my needs ! I have used this forum, VB Code websites, other colleagues and a...

Many thanks Pat.... Will give it a go !

Hi Guys & Gals, Hopefully this is a straightforward one for one of you clever Access people. Is it possible to disable the printing function in a form ? We are getting people clicking the print icon when viewing a single form record. This results in the printer printing all records ...

Hi, I am sorry to say that didn't work as I want it to ! Let me give you some more info on the database I am trying to administer. The database is a multi user database and the user access is controlled by the first 2 digits of their allocated login username. The 'Closed' checkbox (Yes/No) is...