User Profile

Collapse

Profile Sidebar

Collapse
Sigma7
Sigma7
Last Activity: Mar 29 '12, 02:25 PM
Joined: Aug 15 '09
Location: Illinois
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Sigma7
    replied to Excel VBA
    in Access
    Thank you very much for the quick reply to my question. I will definitely read the link provided. However, line 7 is the culprit. I placed the <> in front of the code and it return a Syntax error. I literally copied this code from a youtube video "create a userform in excel part 3 of 3." Thanks for the other code abbreviations (awesome).
    See more | Go to post

      Leave a comment:

    • Sigma7
      started a topic Excel VBA
      in Access

      Excel VBA

      Good afternoon, I am trying to transfer information from my Excel User Form into the database table. After searching vigourously on the internet, I came across this formula to find the next empty row:
      Code:
      Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("DocumentFiled")

'Find First Empty Row in Database
iRow = ws.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row
      ...
      See more | Go to post
      Last edited by NeoPa; Mar 28 '12, 10:27 PM. Reason: Added mandatory [CODE] tags for you.
      • Sigma7
        started a topic How do I right a code in utilizing VB for Excel?
        in Visual Basic

        How do I right a code in utilizing VB for Excel?

        I have placed a checkbox in one cell and if the check box is checked I would like to have another cell backcolor to change color. Thanks James
        See more | Go to post
        • Sigma7
          replied to Updating Subform using Mainform
          in Access
          Thank You, I will re-write the form to do just that.
          See more | Go to post

            Leave a comment:

          • Sigma7
            started a topic Updating Subform using Mainform
            in Access

            Updating Subform using Mainform

            This is my issue- I am a true novice to DBMS. I would like to accomplish the following feat: I have created a mainform and subform, and I would like to have the users to input information into the mainform and have that information populated into the subform.
            See more | Go to post
            • Sigma7
              Sigma7 posted a Visitor Message for Sigma7
              I am very happy that I stumble on this site. I look forward to working with everyone to learn as much as I can.
              See more | Go to post
              No activity results to display
              Show More
              Working...