Recent content by Ksel

Thanks for the input CJ London. When I did that code the next record's TimeIn and TimeOut populated with #Name. Any thoughts on that? Anyways, My thinking is that the user will get confused sometimes when if there is a default value (rather than manually copying the previous record). That's the...

Hey all! When I press ctrl+r I want to copy a couple values from the previous record (on a continuous form) into the current record. I figure you would use the KeyPress event for this, but I want the event to occur when ctrl+r is pressed while Me.TechName has the focus. I'm just a little...

Hey vbaInet, Until just recently, I never had a chance to get around to this after I posted. Thanks for the response! Yea I ended up just making some extra fields in a query with the DatePart function, and got it figured out with your help. Thanks much, Kevin

Hi All, I have a form (frmMetrics) with 2 Combo Boxes: "Year" and "Quarter" These are just number fields (which might be my problem?) I have a date/time field in a query, and I want the criteria to be based off the year and quarter selected in frmMetrics. Seems simple, but I can't seem to...

Thank you both. I'm getting back to work on this a bit later, but I think my question was answered! I'll fiddle around with it. Cheers! Kevin

Hi all, I have a number field called Jobs.SquareFootage, and I want to run a query that categorizes the field into intervals. The intervals I want are: 0 to 50 squarefeet 51 to 300 squarefeet 300+ squarefeet This is the query I'm coming up with so far JobID SquareFootage Revenue 1...

Hi all, I have a combo box control in my form named PayDateID, but I told that control to DISPLAY the associated field PayDate. I now am trying to make a separate control in the same form whose control source is the DISPLAYED PayDate, but it only wants to reference the underlying PayDateID...

Hi all, I suppose I'm a bit of a dilettante when it comes to access, but I'm working my way to perfection! I don't work in the developing or programming profession, but there is such a need for better information at my company, so I've sort of tried to have fun and take on the task of coming up...