Search results

  1. B

    Change Command Button VBA Help "ASAP" Thanks

    Hello my coworker is having issues with a command button is whenever she sends email to a State, it would stop processing at a particular using the first command button. However, the second button "restart button" she wants me to change the code for that will allow to her should a State at any...
  2. B

    Query Results Issue

    Query results are not showing in my query datasheet. The relationship for all of the tables in my query grid are established. Can you tell me what is wrong. Thanks :confused:
  3. B

    Access Database Certifications

    Hello Are there any Access Database Certification Self Study Books out on the market? Thanks for your speedy response.
  4. B

    SQL Statement for Decimal Data Type

    I would like to know how can I create a field using SQL syntax for a decimal data type? :confused:
  5. B

    SQL Syntax Creating a Table

    Hello I would like to know what is the syntax I can use to create a table field with a decimal point datatype and a field with a memo datatype? Lastly, a field with byte datatype? Thank you in advance for your speedy response.
  6. B

    DoCmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70

    What do this line of code mean? :confused:
  7. B

    Creating an Appointments Schedule in Outlook

    How to create a VBA code for generating an appointment schedule in Outlook? :(
  8. B

    IsLoaded Error

    Private Sub Form_Open(Cancel As Integer) If Not IsLoaded("frmAttendees") Then MsgBox "Open the Payments button on the Attendees form." Cancel = True End If End Sub I received a compile error: Sub or Function not Defined. I check the reference box and the Access 11.0 Library is...
  9. B

    DoCmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70

    What do the above code means?
  10. B

    GoToNew

    Hello, I had to read your explanation over again. Are you indicating that after the "frmEvents" is open, the "GoToNew" string means that a new form is open not the frmEvents? I'm a little confuse. Sorry
  11. B

    What does DoMenuItem stands for?

    DoCmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70 :(
  12. B

    Me! Syntax

    Thanks Ken :)
  13. B

    Me! Syntax

    What does this mean? Me![FeeScheduleID].Requery I know the Me (refer to a form and/or report) I'm confuse with the ! (bang) [FeeScheduleID] (refere to the field name) From my understanding, the band refers to a collection. Is the above syntax a collection? :(
  14. B

    GoToNew

    Okay. Thank you both for the explanation.
  15. B

    GoToNew

    DoCmd.OpenForm "frmEvents" , , , , , acDialog, "GoToNew" What do "GoToNew" means? :(
  16. B

    Runtime error '2465'

    Hello, I need some help I received the same above error in this code when I did a compilation. It stops at the second subformFees under the Else. It is indicating that it cannot recognize this field name. It is not a field. It is the name of the form. :( Private Sub...
  17. B

    Brackets and Exclamation Points

    Thanks DCrake I knew about using the bracket when a field name(s) have spaces and thanks for the clarification on using the ! point as well as the brackets that distinguish a field name and table.
  18. B

    Brackets and Exclamation Points

    I have a question about the below query. I never use brackets and exclamation point to distinguish my table name and field names. Why are the brackets and exclamation point used in this query? :(This query is from a sample Access Database. I look forward to hearing from you soon...
  19. B

    Calling NotInList Function

    NotInList Event Could an expert answer this question? I would like to know how to use the NotInList Event procedure as well Thank You:confused:
  20. B

    Calling NotInList Function

    NotInList Event Could an expert answer this question? I would like to know how to use the NotInList Event procedure as well Thank You
Back
Top Bottom