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

    What does DoMenuItem stands for?

    DoCmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70 :(
  11. 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? :(
  12. B

    GoToNew

    DoCmd.OpenForm "frmEvents" , , , , , acDialog, "GoToNew" What do "GoToNew" means? :(
  13. 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...
  14. B

    Copying an Access Report using VB codes to another Database

    I need some expert who can tell me how can I copy a report from one database to another database using a VB code and/or SQL statement using Access 2002 Thank you in advance for your help.
  15. B

    Inserting a new row between existing rows

    To Whom It May Concern I would like to know how can I insert a new row between an existing row in an Access Table For example, I want to insert a new row between line number 122 and 123. Do I need to get rid of the primary key or change it to Number. What I am doing now in order to have...
Top Bottom