User Profile

Collapse

Profile Sidebar

Collapse
jayo17
jayo17
Last Activity: Jul 26 '07, 08:40 PM
Joined: Jul 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jayo17
    replied to Separating One Field with Commas into 2 Separate Fields
    in Access
    i will try these 2 suggestions out..thanks for the help
    See more | Go to post

      Leave a comment:

    • jayo17
      started a topic Separating One Field with Commas into 2 Separate Fields
      in Access

      Separating One Field with Commas into 2 Separate Fields

      Hi All (Access 2003/XP)

      I have an Excel file with name information in the form of LastName, First Name in one field. I want to have the name separated into 2 fields, LastName and First Name for Access. I have googled this problem and found th following solution from this forum:



      Is this the right way to do this? If Yes, where would this code be entered?...
      See more | Go to post
      • jayo17
        started a topic Quarters of the calendar year
        in Access

        Quarters of the calendar year

        I have searched the forum and read some manuals but i cant figure the best way to do this.

        All i want to know is what the best way to organize things by quarter. would it be best to use a date and have some code that determines what quarter it should be labeled as? or should i have a table that does this and reference the table through relationships? The format i am looking for is Q107 for example (first quarter and 2007).
        ...
        See more | Go to post
        • jayo17
          started a topic Editing Information in new form
          in Access

          Editing Information in new form

          Hi

          i want to make a form that edits information on the table. the way i want it to be is on the first form have cascading combo boxes (which i have done already) and when the selection is made (which would be a person's employee number), i want to open another form with his/her information it derived from the table. then you could edit it and save the changes upoon review.

          i can figure out the combo boxes, like i said,...
          See more | Go to post
          • jayo17
            replied to Setting a Value in a Table based off of Selection in a Comb BOx
            in Access
            i think i get what you are talking about. But my count isnt going to be a daily count of whether people are working. it is meant to be a reference for a day/month/quarter of how many bodies we have to work. Some people are only considered 1/2 because they might have other duties, while someone might be working full time so we can count them as a full person, or a 1.

            does this still warrant another table you think?

            i...
            See more | Go to post

              Leave a comment:

            • jayo17
              started a topic Setting a Value in a Table based off of Selection in a Comb BOx
              in Access

              Setting a Value in a Table based off of Selection in a Comb BOx

              I have access 2003 on Windows XP.

              So what i am trying to do is edit a record in a table based off of a specific combo box selection. I know how to make the combo box change the values in a table that it is bound to. Whe i am trying to do is have one of the selections in teh combo box enter a value in a field that it is not bound to.

              Specifically, i have employee status (new hire, manager, term, LOA) in a combo box that...
              See more | Go to post
              No activity results to display
              Show More
              Working...