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 Chriss Miller 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. detgharris

    query by form problem

    Ok, I have a main form that has four unbound combo boxes on it. The first is for date with a pop up calendar, the last three are other controls with dropdown items. This is linked to a query where I do the query by form. Also on the form I have a subform that shows the results of the query by...
  2. detgharris

    One step leads to another

    I'm not sure I understand what you're saying... What I'm trying to accomplish is kind of a table on the fly... instead of having a table with 365 records in it, it would fill up with only the dates between "startdate" and "enddate" and then go away after I've printed the report. That way when I...
  3. detgharris

    One step leads to another

    Dhookom you seem to answer all my questions, and here I am, yet again, with another question. You answered my question about creating an outer join to show all dates, which is the perfect solution, but now I've been searching posts trying to find out how to create a table that will...
  4. detgharris

    How to Get Report to Show Date even if Value is Null

    I am trying to create a report bi-weekly to show days worked, but the problem I'm having is that if I have no entry for the two days, it doesn't show the days on the report. I need the off days to be listed also, but just can't figure out how to get there. Thanks in advance.
  5. detgharris

    frmAutoDate Field

    That answered it, thanks so much, I knew it was something really simple that I wasn't getting. I was trying to find all kinds of VBA code for the solution, you made my day. Thanks again....
  6. detgharris

    frmAutoDate Field

    Ok, in the form, instead of the table, I could set the default value to maximum +1??
  7. detgharris

    frmAutoDate Field

    Ok, another simple question that seems to keep eluding me, I've searched all the FAQ's and looked in the forums, but still puzzled. I have a table where the primary key is the date, only one date per record, no duplicates. I want the table to automatically go to the following date. Example...
  8. detgharris

    Normal Form Rules

    Ok, I see where you're going, I've started this database about 15 times, and just get frusterated and restart because I don't seem to be getting anything that feels right. I am basing the database on an excel spreadsheet that a former employee had created and it's been a pain. I WILL get my...
  9. detgharris

    Normal Form Rules

    I'm working on a database that has, among other things, a time sheet. I'm trying to make my database and comply with all the normal form rules. So far, my table has DateWorked, RegularHours, OvertimeHours, CompTimeHours, CompTimeUsed, SickTimeUsed, and VacationTimeUsed. At this point, since...
  10. detgharris

    Date to Day of Week

    I have a Table with a Date field. The next field is "Day of Week". I'm sure this is a basic question, but I have been beating my head against the wall. How do I get the "Day of Week" field to automatically populate when I enter the "Date" in it's field.

Part and Inventory Search

Back
Top