Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mjm2001

  1. mjm2001

    separating text to column

    i have a list of names in Excel and need to separate them into firstname, lastname, middle. However, the name is listed LastnameFirstnameMiddle Ex: SmithJohn DoeFrankJames BeckJoel BlankJefferyE Is there a way to search the cell on the next capitalized letter and separate it that way?
  2. mjm2001

    creating forms from normal tables

    Sorry about that. It looked better on paper until i started changing things. its suppose to be awards awards_recipients recipients awardsid <---> awardsid title recipientsid <---> recipientsid date fn amount...
  3. mjm2001

    creating forms from normal tables

    i've been trying to create forms for this simple database and have no luck.. so been entering info manually. the problem is.. i have three tables awards-projectsid,title,date,amount recipients-recipientid,fn,mi,ln projects_recipients-awardsid,recipientsid i cant seem to get all the forms to...
  4. mjm2001

    table of contents in subreport

    i've been reading through the posts and couldnt find a definite answer so i will ask again. i am trying to create a table of contents using a subreport in a header of my main report. in doing that i am having problems linking the information together. i want to pull from the main report the...
See more

Part and Inventory Search

Back
Top