Recent content by CharlesWh

  1. C

    Hide cmdButtons based on Variable?

    I've Created A Module Called "Globals" I've put the following code in the module Option Compare Database Public Function Init_Globals() GBl_student_ID = 0 End Function Public Function Get_Global() Get_Global = GBl_student_ID End Function On the Close Event of my login form I have the...
  2. C

    Hide cmdButtons based on Variable?

    In my Db a user belongs to a company, a company can belong to various PrimaryDataTypes. TblPrimaryData TblPrimaryDataTypes TblLinkPrimaryData2Types The last one is basically a many to many relationship link table which stores the PrimaryDataID along with the associated Type On my splashscreen...
  3. C

    IF Statement Against Check Boxes

    I'm trying to warn a user if no check boxes have been selected but this code doesnt seem to work. Am I wring somewhere? If Me.chkCommercial = "0" And Me.chkDomestic = "0" And Me.chkHotSpot = "0" And Me.chkReseller = "0" And Me.chkVoip = "0" Then MsgBox "You need to define enquiry interests"...
  4. C

    Docmd.Close Closes Wrong Form??

    Thanks all, I found setting the focus solved the problem.
  5. C

    Docmd.Close Closes Wrong Form??

    Here is a snippet of some code on a form. User in the main form (frmPrimaryData) that form contains among other things clients name and address a user who wants to change or update it clicks a button which opens up an unbound form, clicking save triggers a SQL UPDATE... Once thats done I want...
  6. C

    cdo email with attachments

    the solution was to remove the = this one works objmessage.AddAttachment ("file://c:\test.txt")
  7. C

    cdo email with attachments

    Also, email sends fine until I try to add the line with an attachment?
  8. C

    cdo email with attachments

    I think thats already done with the line Set objmessage = CreateObject("CDO.Message")
  9. C

    cdo email with attachments

    No, not sure where to add that?/code
  10. C

    cdo email with attachments

    It's the following line: objmessage.AddAttachment = ("C:\test.txt")
  11. C

    cdo email with attachments

    I'm trying to modify the following code to allow attachements but keeps erroring "object doesnt support this propery or method" when I can see thatothers are using the same? Private Sub cmdEmailProductSpecs_Click() Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup...
  12. C

    Writing an effective MS Access developer resume

    did you get a template? I'd like one too.
  13. C

    DLookup Versus SELECT???

    Many thanks for your reply and information. As a newbie am just beginning to understand what recordsets are for!
  14. C

    DLookup Versus SELECT???

    I am using some code to retrieve a value to become the value of a text box. Am i right in thinking that when using DLookup NULL values have to be handled whereas by using a SELECT statement I dont have to worry about NULL throwing up an error? If so, having constructed the following code, how...
  15. C

    Retrieving User List From Active Directory

    I'm using the following code I've found to try and populate a combo box with a list of users from Active directory. I get a runtime error "Table Does Not Exist" and fails at the following line: Set objRecordset = objCommand.Execute Any advice most welcome :o Private Sub Form_Current() Set...
See more
Top Bottom