User Profile

Collapse

Profile Sidebar

Collapse
hardcode
hardcode
Last Activity: Feb 23 '07, 07:45 PM
Joined: Oct 26 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • hardcode
    replied to Turning Columns into Rows - Any easy way?
    Thank you, this will make my life quite a bit easier, I do crystal reporting and it's pretty difficult in that realm, appreciate it !...
    See more | Go to post

    Leave a comment:


  • hardcode
    started a topic Turning Columns into Rows - Any easy way?

    Turning Columns into Rows - Any easy way?

    I can't do it in Crystal Repots either without making a formula for each field so I thought about using 'copy an existing table structure wo/the data' (like to make a new table and append records to eliminate duplicates) to an increased field element table but that did not work even adding a qry...
    I just want to take a random number of rows of patient id's containing lab data and as the qry reads the rows, post the lab data from each row...
    See more | Go to post

  • Put this code behind a conrtol button on your form:

    Private Sub Command148_Clic k()
    On Error GoTo Err_Command148_ Click

    Dim stDocName As String
    Dim stLinkCriteria As String
    Dim strForm As String

    strForm = "frm_Passwo rd"
    DoCmd.OpenForm strForm, , , stLinkCriteria, , acDialog

    If strPassword = "reviewer" Then
    stDocName...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...