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 derfloh 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 frankcpl

  1. frankcpl

    Pulling parameter data from access and export to excel

    Thanks for the thought, I will look into it though. Might be a way for Excel to access the sharepoint and pull in data. At least it is worth looking into.
  2. frankcpl

    Pulling parameter data from access and export to excel

    Is that possible with the database being on a sharepoint site?
  3. frankcpl

    Pulling parameter data from access and export to excel

    I have run into an issue that has me really confused. I would like help if anyone is able to help. I have a sharepoint site with an access database one it. I am able to create a query that ask for parameters and it works great. The problem I am having is when I am trying to print the query. The...
  4. frankcpl

    Form Creating ghost record and updating record

    I see the confusion there. That last part was an weak attempt to find only the record in the table that matches the Combo box selection that has a null value. I have created a subform and that seems to be a solution for the issue at hand. Thanks for ya'lls input.
  5. frankcpl

    Form Creating ghost record and updating record

    The second form record source is the table and has an unbound combo box. The search is done by the following code. Dim rs As Object Set rs = Me.Recordset rs.FindFirst "[Student ID] = " & Me.Combo5 Me.Bookmark = rs.Bookmark If [Time Out].Value <> " " Then rs.FindNext "[Student ID] = " &...
  6. frankcpl

    Form Creating ghost record and updating record

    I have a table that has 7 fields ID(key), Stud ID, Stu Name, Subject, Time In, Time Out, Date in. I have a query that pulls only records that have blank "time out" field. I have a sign in form, that creates a record with all the information except time out. Form two has a combo box that pulls...
  7. frankcpl

    Form Creating ghost record and updating record

    I have 1 table and 1 query and 2 forms. I want 1 form to update have of the table and another form to update the rest of the table. Right now I have everything working properly, except the 2nd form. When it is used to update the table through the query, it creats another record that contains...
  8. frankcpl

    Form Creating ghost record and updating record

    I have run into a problem with a database I am working on. It is a simple log in and log out database. The way it works is a form creates a record for logging in. Then another for updates that record when you log out. The problem I have is that everything is working, except I get a record with...
  9. frankcpl

    Information on building a program

    Thanks again for the help. I think I understand it now. I am going to try and work out the coding for it. Again thanks a lot.
  10. frankcpl

    Information on building a program

    Thanks for the clarification. I am working with java, so classes is what I am after. Thanks again for the help. The next thing is, anyone explain how to randomly pick from a list without having duplicates. I am confused on how to "scratch" an array item from the selection list. Really do...
  11. frankcpl

    Information on building a program

    I am having trouble understanding how to create a script on creating a schedule with conditions. I am not asking for anyone to provide code, unless they just want to, just help me understand the concept so I can learn to code it. Thanks for any help
  12. frankcpl

    Excel Problem

    Everything you have supplied works just as you state and fullfills what I am needing. I have to mail each individual a letter, inside which will have the roommates with a phone number for each roommate. I don't want it concatednated with anything else because the address is a home address for...
  13. frankcpl

    Excel Problem

    Skip you make it look easy. One last question. How do you control where to start coping the information from for the roommates. The only reason I ask is because I have the address I have to insert after assignments for the mail merge, but don't want it concatenated with the other data. Thanks...
  14. frankcpl

    Excel Problem

    My apologies. I like the comma between the last and first name only. As for other columns of data will I will be concatenating the only data is the address of each person, but it isn't concatenated. It is just for the use of the mail merge. Thanks again
  15. frankcpl

    Excel Problem

    Skip, I was able to step through you code and found where it was entering the comma. I like to have the comma between the last name and first name only, but after looking at the code, it will put the comma behind all the data present. I don't see an easy way to change it so I am just going to...
See more

Part and Inventory Search

Back
Top