Search results

  1. M

    I wanna share this code that create PDF file

    found thru researching the net
  2. M

    Security..Is there another way?

    Hi banana, I have found this article http://support.microsoft.com/support/access/content/secfaq.asp?SD=gn&LN=en-us&gssnb=1#_Toc493299663 it talks about containers and document objects and it provide codes on how to manipulate thru VBA. can you assist me on this one?
  3. M

    Security..Is there another way?

    can anyone stand up for this challenge?
  4. M

    Security..Is there another way?

    i guess i have cleared out that i have no idea to code that one. neither in the web I have searched for code or any topic for that matter. i guess i may never find solution for this one.
  5. M

    Concatenating using +

    i see. let me test again.
  6. M

    Two fields in one table relate to one in another

    can you post your db here.
  7. M

    MsgBox Cancel Button

    If Len(Me.Counsellor & vbNullString) = 0 Then <<<<--this really have &vbnullstring? MsgBox "The Employer Liason Field can not be left blank." Cancel = True Me.Counsellor.SetFocus Cancel = True End If If Nz(Counsellor, "") = "" Then Cancel = True 'if necessary MsgBox ("The Employer...
  8. M

    Concatenating using +

    how about this one... i have made modification on the said query.
  9. M

    Concatenating using +

    what do you want to achieve here?
  10. M

    Concatenating using +

    whats the problem?
  11. M

    Security..Is there another way?

    Dave thanks for the reply and for the property code you gave me. I want you to know however that I am already using that code as part of my security in my project. Banana, I know, probably, the you will have nothing or less incentive in developing with ULS. And I know that ULS is deprecated...
  12. M

    Security..Is there another way?

    ideas anyone ?
  13. M

    Enable/disable controls of one form from another form

    that should work! how do you know it did not work?
  14. M

    sync combo boxes

    i have this one for you. study it.
  15. M

    checkbox

    Private Sub Form_Current() If Me.QTY.Value = Me.TQA.Value Then Me.POSUBMATLSTATUS.Value = True Else Me.POSUBMATLSTATUS.Value = False End If End Sub ============== is the above exactly your code?
  16. M

    Running a query from a form to create a report

    wow, i cant think of anyway for you as a beginner but to learn the basics thru templates.
  17. M

    Running a query from a form to create a report

    welcome here! first of all you can always use the templates provided in ms office for your reference examples how things are done. secondly, you dont need a query to save a form but rather a code to save record you input in the form to the table you wanted it to be saved. i have started...
  18. M

    sync combo boxes

    Private Sub CustomerID_AfterUpdate() Dim strSource As String strSource = "SELECT ProductID " & _ "FROM Product " & _ "WHERE CustomerID = '" & Me.CustomerID & "' ORDER BY ProductID" Me.CustomerID.RowSource = strSource Me.CustomerID = vbNullString End Sub...
  19. M

    My combobox is not updating the table correctly

    when you join the two tables on Area_ID, just try to link the two together with out any referential integrity rules
  20. M

    Two fields in a table referring to the same field in a lookup table

    well, when you relate the two fields, it must have records because your query will evaluate if it has the same record. if not, eventually no record will be shown. your companynameid is a number field with number records, your CompanyNameXRefID is a number field with some no record and some text...
Back
Top Bottom