Recent content by hardin4019

Hi Bob and Highandwild, Ok, I got the DB and see what you mean and all looks good, and I understand it now. I get how I could use this to generate dates for a combo box, but is there an easy and effective way to automatically add the dates to this combo box? And now, if I use this to choose...

I'm using MS Access 97 so it doesn't recognize .mdb. Can you save it as access 97 format?

Sorry Bob, I nearly missed your post. Please post a link when your site comes back up. It sounds vary useful.

Hi again, No, sorry, I'm not familiar with the Cartesian Products. Yes, attendance should be entered within say +/- 5 days of the incident. As for the Cartesian Products steps you listed. I get lost in #2, setting up another table. Would you want to use like a temporary table or something not...

Works! Awesome, thanks Pbaldy! I'll book mark their site for future reference.

Hi Highandwild, I agree, and I am working toward the same thing, preventing double data entry. At this stage in the game, this is a single form, each is independently driven on its own (table/query lookup). As for a data picker, I'm not sure I follow. For me, and this DB, there is not wrong...

Hi Guys, Still feeling very much like a newbie. (In case it matters) I am using MS Access 97... So I have a form that has different buttons each to a slightly different report, and now I am going to the extra step of adding a combo box next to each. 1st report, employee attendance grouped by...

Hi Guys, 2 separate questions this time. I know the rest of the universe has moved on to a newer version, but bare in mind, I am using MS Access 97. 1. I am creating an attendance DB, I have forms for entering employee info, attendance info, editing attendance info, and running reports. In the...

Works like a champ stopher! And from the looks of it, I wrongly assumed that it would/should be an un-nested IIF statement. I swear I thought I had used the Between command once before and it didn't work, but most likely it didn't because of how the rest of the statement was setup. Thank you! :D

PS... I just tried this, it returns a -1 after the details for each employee, regardless of if they should have a warning/terminate or nothing. =(IIf([Sum Of PointValue]=(2),"Warning","") Or IIf([Sum Of PointValue]=(2.5),"Warning","") Or IIf([Sum Of PointValue]>=(3),"Terminate",""))

Hi Guys, Bare with me, I'm still new to Access and have limited VB knowlege. And for what it is worth, I am using MS Access 97. Issue: I have a text box in a report for an attendance DB I have made that I want to look at a sum box right next to it, and return one of two strings of text based on...

Fixed it! Used my combo box, set control source to the ForeignEmployeeID, set the other options to lookup the EmployeeName, then EmployeeID from a query that had them sorted in Alphabetical Order, bound the combo box to show only the EmployeeName, but at the same time it chooses the correct ID...

Hi Pat, Good point. I actually understand it now. So I tried it, I removed the EmployeeName Field From Attendance and did a little shifting around so I have this: Employees Table: EmployeeID <== PrimaryKey EmployeeName Employer Shift SupervisorName Department Attendance Table: PrimaryID...

Thanks Pat! The actual creation of the query took a minute or so, and the layout of the report took more time than that. It looks great. I'll start working on totaling up excused and un-excused now and see if I can't get this thing doing the what I really hoped it would do. I got a little...

Hi Guys, I'm really new to Access, and have little experience with VB, but I've managed to make myself a DB with some forms and need some help in layman's terms. I've seen this topic about a million times but nothing seems to be working for me. I have Access with office 97 so that could be a...