Search results

  1. G

    New to microsoft access, need help!!!

    I'm not sure what you're trying to do either. If you only want to see records from one supplier, the best way to do that is to create a query. All of your suppliers are in the same table, but the query filters them by supplier. If you really, really need another table, you can use a make-table...
  2. G

    How to change controlsource of multiple textboxes with public function

    Yes that's exactly it. The reports are different from each other in ways that are not important for this question.
  3. G

    How to change controlsource of multiple textboxes with public function

    No, I'm saying I have three reports that have the same textboxes on each report. I want to show all of them always when I open up a report. Nothing is ever being selected on a form or hidden. Report A has txtInquiryColor, txtDesignColor, etc. Report B has txtInquiryColor, txtDesignColor, etc...
  4. G

    How to change controlsource of multiple textboxes with public function

    I'm trying to change the controlsource of the textbox. I have reports A, B, and C, and I have the same four textboxes in each report with almost the same controlsource. Right now, if my manager says "You know what? I changed my mind, I want it to say X instead of W" I have to change it in twelve...
  5. G

    IIf statements with AND (multiple criteria)

    Turned out that a nested IIf statement works just fine with "AND". There are three states (Red, Green, Blank) so Steve's example would not work. IIf([PercentComplete] < 100 AND [ReportDate] < [EndDate]), "Red",IIf ([PercentComplete]< 100 AND IsNull([EndDate]),"Red", iif([PercentComplete] = 100...
  6. G

    How to change controlsource of multiple textboxes with public function

    I have multiple reports that use similar IIF statements as the controlsource for four textboxes. Naturally, I don't want to have to update twelve controlsources if any of the calculations change, so I thought I'd make this a public function. However, I don't know how to pass along multiple...
  7. G

    IIf statements with AND (multiple criteria)

    I have a list of projects and I need to display their status (Red or Green) in a text box. My fields are [PercentComplete],[StartDate],[EndDate],[ReportDate] There are two ways a project could have a red status. 1. [PercentComplete] < 100 AND [ReportDate] < [EndDate] OR 2...
  8. G

    Using datediff in a non-normalized database

    Okay, thanks, you did do precisely what I asked for. :) For future searchers, this is how I would have structured the data in a perfect world, alas, I'm hamstrung by needing to use SharePoint. Tbl_orderinfo OrderID UserID RegionID CountryID Tbl_users UserID UserName Tbl_regions RegionID...
  9. G

    Using datediff in a non-normalized database

    Yeah, that's the same SQL I had before. The problem is that if no PO is created, then the next step (PO_Purchasing) is 0. So it could take three weeks from DateSubmitted to DateApprovedPurchasing and we would have no idea from the report that there was a delay. I attached a sample database to...
  10. G

    Using datediff in a non-normalized database

    plog I have a table with the fields OrderNumber (primary key), DateSubmitted, DatePOCreated, DateApprovedPurchasing, DateApprovedFinance, DateApprovedExec, DateSent, DateDelivered Every record has an OrderNumber, DateSubmitted, and DateDelivered. But not all orders have to be approved by...
  11. G

    Using datediff in a non-normalized database

    Surely someone has done this, but I am having a lot of trouble figuring out the correct keywords to search for. I have a SharePoint list that tracks the date/time of each stop of an order from its origin to its destination. The number of stops varies depending on the type of order (you can use...
  12. G

    Stop generating message boxes on form close

    I thought of this, but there are 10 possible queries the user can run from this form, and repeating the same code for all ten buttons seemed unnecessary. I thought there must be an easier way to do it. But maybe I'm wrong and it does need to be coded for each button? Seems like a pain if I have...
  13. G

    Stop generating message boxes on form close

    I have some code (see below) that checks if the start date text box is blank or greater than the end date, and if so, generates a message box and sets the focus back to the start date textbox. There are command buttons on the form that open queries based on the date fields. This all works fine...
  14. G

    Need to display dates no one worked on a project

    If we're ever in the same location, I owe you a beer! (Or beverage of your choice.)
  15. G

    Need to display dates no one worked on a project

    I've seen that solution on other forums, but it doesn't give me any results because there is no exact match between StartTime and a table of dates. I would have to generate a table with every possible time in order to get matches. Even if I did that, the giant list of times that had no match...
  16. G

    Need to display dates no one worked on a project

    I have a table that records when someone has started and stopped working on a project. The fields are Project, StartTime, EndTime. The start/end time fields are Long Dates. The sample data is something like Walk Dog, 2/22/2013 11:00, 2/22/2013 11:30 Walk Dog, 2/22/2013 19:00, 2/22/2013 19:30...
Back
Top Bottom