User Profile

Collapse

Profile Sidebar

Collapse
Stefent Tan
Stefent Tan
Last Activity: Apr 4 '13, 04:59 AM
Joined: Feb 12 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Stefent Tan
    started a topic How to Convert a Textbox from Access Form to Ms Excel cell ?
    in Visual Basic

    How to Convert a Textbox from Access Form to Ms Excel cell ?

    I Have 3 Textbox at access form said Textbox1, textbox2, and textbox3, and I want every time when I click on the clickbutton the data at textbox 1,2,3 will transfer to Ms Excel cell. Textbox1 at Range "A1" (Ms excel), Textbox2 at Range "B1" (Ms Excel) and Textbox3 at Range "C1" (Ms Excel),
    and every click the data should be transfer to the new row at Ms Excel.

    Thank you for your time.
    See more | Go to post
    • Stefent Tan
      replied to How to make a message "data can't double"
      in Access
      thanks, but it still no work, maybe you have another way for my case, all I need is making my application look like a professional. Thanks
      See more | Go to post

        Leave a comment:

      • Stefent Tan
        started a topic How to make a message "data can't double"
        in Access

        How to make a message "data can't double"

        I have a textbox call Staff_ID, I don't want my user to type the same Staff_ID . So I write the vba code like this

        Code:
        Private Sub Staff_ID_AfterUpdate()
Dim SID As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset

Set rsc = Me.RecordsetClone
SID = Staff_ID.Value
stLinkCriteria = "[Staff_ID]=" & "'" & SID & "'"

    If DCount("Staff_ID",
        ...
        See more | Go to post
        Last edited by NeoPa; Feb 20 '12, 05:06 PM. Reason: Added mandatory [CODE] tags for you
        • Stefent Tan
          started a topic How to change Columns to rows at access 2007
          in Access

          How to change Columns to rows at access 2007

          Please help me to do this,
          I have a data table Name : Qry_MH_Tbl_Resu lt as below

          Trading date MB-01 MB-02 MB-03 MB-04 MB-05
          01/02/2011 5000 5000 5000 2000 1000
          02/02/2011 -1000 2000 2000 2000 2000
          03/02/2011 6000 1000 1000 1000 1000

          I want to make a Report that shown like as below

          Trading_date 01/02/2011 02/02/2011 03/02/2011
          MB-01 ...
          See more | Go to post
          No activity results to display
          Show More
          Working...