Search results

  1. southwestgooner

    Help!!! Update Query to update fields in table???

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

    VB Code to add c.c Email addresses into automated email.

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

    On load form error.

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

    Annoying error message pop up.

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

    Code required to lock/disable all form fields on inputted value.

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

    Training material required.

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

    Question Disable printing of all records in forms !

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

    Record lock when Checkbox (Yes/No) is Yes

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

    Passing data between tables.

    Hi, I am currently working on a split database. The Back_End contains all the tables. The Front_End contains the queries, forms, reports, modules, macros etc, etc. I have a table named tbl_ECNList this contains fields named OriginatorID, FullName & EmailAddress. I have another table named...
  10. southwestgooner

    Hi from South West England

    Hi Guys & Gals, I am an absolute beginner so please bear with me if I ask some what may seem rediculous questions !! I am keen to learn so any help received I can say is very appreciated. Cheers, Steve.
  11. southwestgooner

    Problem taking data from Access Form into automated email.

    Hi All, I hope someone out there can help me resolve a 'Event Procedure' problem I have. I want to send a automated email via Lotus Notes to inform a database user that a record has been updated. I have got the automated email working to send a email to myself and save it into the sent items...
Back
Top Bottom