Search results

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...

I can confirm the checkbox (yes/no) is accesed via a Form. What are my options ? Cheers, Steve.

Hi All, I have a ECN table which contains many fields including ECNID it's related via relationships to another table containing part numbers linked to the ECN record in the ECN table. The ECN table contains a 'Closed' checkbox (Yes/No) field. What I want to do is lock the ECN table record and...

Hi, Many thanks for that shot in the dark. It worked to send form control data into the message body. The last problem I have now is setting the email recipient. I want to take the EmailAddress from the form into the email recipient "SendTo" line of code. This code works to send to a fixed...

Yes an employee can create multiple records. I have also removed the FullName & EmailAddress fields from the tbl_ECNList as they are duplicated and are required in the tbl_Employee.

Hi, Yes its unique in the tbl_Employee assigned to an employee and is added into the tbl_ECNLIst when that employee creates a record.