Search results for query: *

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...

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...

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...

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.

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....

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

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...

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...

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...

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.