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!

Search results for query: *

  1. jeffshex

    Pick Connection String from App.Config at run time and use throughout application

    I'm wondering what the best way to do this would be: I am trying some stuff out and have a server with 2 databases on it, Live and Test. Basically I want to pick a connection on the first form that gets used throughout the program until it is closed. Everytime you run the program, you have to...
  2. jeffshex

    Access 2010 Theme Colors

    I completely agree! I just feel sorry for the poor users who see theme colors, but when they pick that theme, it doesn't use the exact colors that it shows it uses. Oh well.
  3. jeffshex

    Access 2010 Theme Colors

    Maybe I am thinking the themes should work in a particular way, when it is in fact designed to pick colors differently. When I create a new form with my theme applied, the colors come up with the ones I said previously. That being said, if I go into the property sheet of the form, textbox, or...
  4. jeffshex

    Access 2010 Theme Colors

    For example, in a brand new database, I picked my theme which for testing purposes, everything is set to black, except Light 1 and Light 2, which is white. In the form: Header backcolor: Gray 80% Detail backcolor: White (this is what is set in the theme.) Text forecolor: Lighter 50% (seems to...
  5. jeffshex

    how can run micro automatically at perticuler time (ex daily 23:59hrs

    Yep! If you use a split front-end/back-end solution, you can create a separate front end that contains the macro. Just set the macro to run on the form load event and have that form be the one that the front end loads up on startup. After the macro runs, just add another line to quit the...
  6. jeffshex

    Access 2010 Theme Colors

    I have searched high and low on the Google and have not found a suitable answer. It seems that no matter what theme I choose, even my customized ones, the color that it actually uses on my form is not the one I picked - they all seem to be a lighter variation. For example - if I tell it I want...
  7. jeffshex

    Create an "excel like" form

    It may or may not be the next weeks date. He doens't have a set time when he will enter in the dates, so automating that part is not a huge concern for me. The base query (unupdateable), that is bound to my data sheet view form is: SELECT tblClientInfo.ClientID, tblClientInfo.LName...
  8. jeffshex

    Create an "excel like" form

    OK - But in my OP in the first few lines, you will see i'm trying to present the form in datasheet view which is tied to the problematic non-updateable query. Nowhere did I even mention they enter it directly into tables. :( I'm just curious on any approaches/techniques to solve the issue of...
  9. jeffshex

    Create an "excel like" form

    The program record would be determined by their ParticipationDate from the tblProgramInfo which would be asked for on the initial form that brings up the hours form. I usually normalize out, but this is how the user wanted to input it as, he doesn't want to have to punch in a date for every...
  10. jeffshex

    Create an "excel like" form

    Yep, The PK ClientID from tblClientInfo is the FK in both tblProgramInfo and tblHours. Otherwise the primary keys for tblProgramInfo is ProgramID and tblHours is HoursID. All of the PK fields are autonumber.
  11. jeffshex

    Create an "excel like" form

    Ok, here it goes from the beginning: Table fields tblClientInfo tblProgramInfo tblHours ============= ============== ======== ClientID ProgramID HoursID LName ClientID ClientID FName ParticipationDate MonthDate ...
  12. jeffshex

    Create an "excel like" form

    Hey all, I'm trying to present my form to my users that look like an excel form (data sheet view). My problem is that it is a non-updateable query due to a Left Join on one of the 3 tables. The table layout is like -------- ------------- -------------- tblHours <--- tblClientInfo...
  13. jeffshex

    Copy and insert row with certain subrows

    I think this does most of what I need. Just need to figure out how to work in the insert of the related records only those that are backordered. http://allenbrowne.com/ser-57.html
  14. jeffshex

    Copy and insert row with certain subrows

    I have the forms and everything built out, but am looking for a way to do copy a row from an Orders(tblOrders) table along with it's Order Details(tblOrderDetails) and insert them back in. The only catch is that I only need to do this to any order detail record that meets certain criteria. For...
  15. jeffshex

    Compare data between 2 rows

    I think I may have figured it out. I added table that contains the people's scores on again and aliased it. I added duplicate fields for the area and score and put a parameter in for area 1 and area 2 in ther other box. It looks like it is what I need, but not sure what the downsides to doing...
  16. jeffshex

    Compare data between 2 rows

    Maybe I'm misunderstanding, but how can I look at person # 1234 and see if Area 1 or Area 2 are below the score? It would be these two rows: Person Area Score ----------------------- 1234 1 89 1234 2 255 If someone falls within the A range in either of the two areas, then...
  17. jeffshex

    Compare data between 2 rows

    Not sure if this is for the query area or not...but here is my issue: Simply put, I need to compare numbers from 2 different rows. If one number is less than a set value, then a flag should go up, same with the number from the 2nd row...if it is less than a specified value, then the flag is...
  18. jeffshex

    Attendance Layout

    They are going to input other's attendance on a daily basis. No manager approval required or anything else. Plain and simple, just looking for an easy way for them to input anywhere from 5 - 20 people's attendance each day. I'm working on a form now where you select a date and the code runs a...
  19. jeffshex

    Attendance Layout

    I'm looking for any advice on doing an attendance form that's easy for the end user. I would like it to have a grid/excel feel to it since that is what they are used to. I was thinking of having a form populate a list of people who are enrolled in the program and then entering 3 items...
  20. jeffshex

    Use custom paper size for pin fed labels

    Out of sheer frustration, I imported the older version of this report from a previous setup. This same exact label does not push up an inch or more when it prints. This is completly ridiculous because i have fiddled with every aspect of the report and paper sizes only to see that this report...

Part and Inventory Search

Back
Top