Search results

[SOLVED] Updating a "Hire Count" with a Macro Hi all... I have a database with two tables. I want to have a macro run when I set a certain value on a new record in one of the tables, and I want the macro to update a value in the other table by increasing it one. The tables are linked via...

JHB: Okay, I see where I've caused confusion. Let me try to explain another way: MAINFORM control source: Schedule table (which has dates/shifts for each schedule created. SUBFORM1 control source: WORKING query (which filters tblEmployees by only returning records who's assigned shift...

Because I may not be adding all the names. It depends on the day. I just need the NAMES list to turn a name green if I've added it to ASSIGNED. And anyway, as I said, that's not the part I'm having issues with. It's the conditional format that I'm struggling with. For reasons too complicated...

[SOLVED] Conditional Formatting based upon the presence of a record Hi folks. I hope you guys can help me solve this issue. I have a subform (called NAMES) on a main form (called MAIN) that lists names. Elsewhere on MAIN, I have a second subform (called ASSIGNED) that lists people that have...

I want to set a table field's default value to whatever is displayed in a certain field on a certain form at the time. Can I do that? In other words, say I have a database with a table called TABLE1, and two fields called NAME and SCHEDULENUMBER. I have a form called CreateSchedule with a...

Thanks Bob Fitz... but I solved my own problem. What I had to do was this: 1. I created another date field, and set the Control Source to "Format([DATE], "dddd"), and I called that "WEEKDAY". This copied the data from the DATE field into the new field, but changed it to the name of the day...

Hi, geniuses! You guys were such a big help to me last time that I thought I'd pose the next question I have to you, in the hopes you can answer that too! I have a database with a table of employees, and that has a column named "DaysOff", into which I type a couple of days like this: "SUNDAY...

ARGH. Okay, I've solved the first problem. I used a SetValue command in the AfterUpdate property of the first combo box (cmbCategories) to set the value of the cmbProducts box to the most recently entered product. It works perfectly... except... it's not updating the form's displayed data...

Hi folks. I wonder if anyone has some insight that could help me. I've got a form (frmMain) with two combo boxes (cmbCategory and cmbProducts). I have set the combo boxes up to be cascading, so that when you select a value in the cmbCategory box, it influences what is visible and selectable...