Search results

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

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

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