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: *

  • Users: jeffshex
  • Content: Threads
  • Order by date
  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 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. jeffshex

    Use custom paper size for pin fed labels

    I've read through a bunch of posts on this site and others and am still coming up with no luck. As other people have noticed, I need to print one label at a time on an Avery 4013 (3 1/2" by 15/16" size of 5000 continuous labels) using a report. It's being printed ona 24 pin dot matrix panasonic...
  8. jeffshex

    Auto Email PDF Report Improvement

    Hey all, I have this piece of code that I put together that loops through a recordset of emails and changes the reports querydefs WHERE clause on each loop for the particular user. It works and sends out the correct report with the correct info...I'm just looking to do 2 things: 1. I'm not the...
  9. jeffshex

    Multi-Column Combo Box Selection Help

    I need someone to point me in the right direction possibly here. I have a 2 column combo box that holds the the value(ProgramID), but shows the name (ProgramName). It's row source is to select from the programlist table the ID and Name only where Available = True. That way the user can only...
  10. jeffshex

    Click Event for dynamically created buttons

    Hey all, I need some help when it comes to handling a click event for a series of buttons that are created dynamically from XML. I have a LoadXML method that creates rows for the buttons and names them with the "name" tag from the xml. Is what I'm trying to do is have their click event open a...
  11. jeffshex

    Searching records

    I've read a few posts where people build their query string in access via the code and then send that over to get the results. Is that the best way or is it better to come up with a stored procedure in SQL to handle that. I guess is what I'm looking for is if I have an unbound form with a...
  12. jeffshex

    Select smallest date or null value

    Hey all, I have a select statement that I'm using in a query column to return the smallest date using the Min function. The problem I'm running into is I need NULL to be the "smallest" value. For example I have this query: MinEndDate: (SELECT Min(EndDate) FROM tblPlacementData b WHERE...
  13. jeffshex

    object doesn't support property or method on late bind

    I looked at the other thread about late binding and decided to start a new thread. How ever I try to do late binding, I get the error object doesn't support this property or method. and it all starts at the .MeetingStatus line. Even if I comment that line out, it will have the same error on the...
  14. jeffshex

    Multiple relationships on tables...good idea?

    Is it a problem to have relationships set like the following: Table1 has it's own ID PK field (we'll call it T1ID) Table2 has it's PK field T2ID and the FK of T1ID That's the normal stuff, but is it wrong to have another table: Table3 has PK T3ID and two FK T2ID and T3ID I guess why I ask is...
  15. jeffshex

    How to populate date on key press

    Has anyone ever tried populating a date field on a form when a certain key is pressed. For example, if I press "t", then it puts in today's date. I have a way to do it, but I don't like it and I'm looking for advice to better this. Here is the code the form field calls: Private Sub...
  16. jeffshex

    YTD and Monthly Summary

    Hello all! I'm looking for any ideas on the following: I have a query that pulls in Date, Wage, and Staff from a query. There is input parameters, [Starting Date] and [Ending Date], on the Date field. This report will be pulled usually by the first of the year, ie 1/1/2008 to the end of...
  17. jeffshex

    Aggregate Report

    I have a table with about 40-50 fields on it, the majority of them just enter yes or no for the text on it. I'm trying to figure out how to get the same kind of output that a CountIf does in Excel. Do I have to create a report based of that table and add in a text box for each field that does a...
  18. jeffshex

    Advanced filtering for GridView control

    Can anyone point me in the right direction here...> I have a gridview that grabs CategoryID(int), VendorID(int), LoadOS(bit), and Addressable(bit) from my SQLDataSource. I am trying to filter based off of those fields using seperate dropdown/checkbox controls called ddlCategory, ddlVendor...
  19. jeffshex

    Pull list of login names from Active Directory

    Hello, can anyone get me started on how to pull all login/user names from AD in a combo box? It's either something of this solution or create a table w/ all of our employees (which seems like a not so good idea if that info is already in AD). I'm guessing it would be a public function or...
  20. jeffshex

    Display Happy Birthday on Form

    Here's a little piece of code that looks for the date of birth (DOB) on the form and displays a label saying Happy Birthday if it is, otherwise hides it if not. Feel free to modify - I just find it neat. Private Sub Form_Current() Dim dteBD As Date Dim dteToday As Date Me.lblHappyBDay.Visible...

Part and Inventory Search

Back
Top