Recent content by jharding08

  1. J

    MS Access Timecard Example

    Thanks. I was able to download
  2. J

    MS Access Timecard Example

    I'm having trouble downloading Timesheet.zip from his Public Database
  3. J

    MS Access Timecard Example

    I am looking to implement a timecard system with invoicing. I have an idea of how I'd like to do it, but am looking for some ideas on the data model. On MS Community, Ken Sheridan has a public Timecard.zip file but I cant download it. Has anyone else been able to get it? Looking to use that as...
  4. J

    Report with records in columns and field data in rows

    I guess if I can get a query that shows all jobs on one line, I can export to Excel and transpose the data. Just wondering the best way to join all the data together to get everything on one line
  5. J

    Report with records in columns and field data in rows

    Hello, I am looking to create a report that has the records in columns and the fields with values in rows. The columns can grow based on number of records that meet filter criteria. The data is as follows: A Job is a record Each job has 5 phases with associated phase level data (revenue...
  6. J

    Dropdown List values different from bound field values

    I'm guessing using the dropdown and a bound textbox and an afterupdate event ?
  7. J

    Dropdown List values different from bound field values

    I have a dropdown that lists employees but only active employees (where inactive=FALSE). The dropdown is also bound to a table that stores the employeeID per record and has historical data (Inactive=TRUE or FALSE.) I am seeing that when an employee is set to false, it doesnt show in the...
  8. J

    Solved Cumulative total in Textbox

    User is storing hours worked and instead of having to calculate and update the field manually, they want to enter the data to be added in the field and have it update the total automatically. Not alot of space to put another textbox for data to be added I figured out a work around
  9. J

    Solved Cumulative total in Textbox

    I am looking do a calculation when data is entered in a textbox. It should add the current value of the textbox + the entered value and store the new total. Doesnt seem like I can use BeforeUpdate event to do the addition and textbox.OldValue field doesnt always have the current value?
  10. J

    DISTINCT values of a Subform Recordset

    Is it possible to take a RecordsetClone of a subform(filtered) and then in VBA, query on the distinct values of that recordset? -------------------------------------------------------------------------------------- Set rs_Clone =Me.subfrm.Form.RecordsetClone /**Set another recordset (rs_Cust)...
  11. J

    Tab Order through Subforms

    Using LostFocus() or Exit() seems to work for forward tab order. I would need to add the programming if I wanted to do reverse tab order, but I've seen the code that works
  12. J

    Tab Order through Subforms

    I have a main form that has 5 subforms with text controls and in those subforms , there are subforms with text boxes. The main form has 8 text boxes that have tab order 0-7, then the first subfrm1 has two text boxes then a subform(1.1) with three textboxes I need to go from: MainForm.textbox7...
  13. J

    Saving a form with subform

    I did it in the subform Before Insert and it seems to work
  14. J

    Saving a form with subform

    Which form event should I set the variable in?
  15. J

    Saving a form with subform

    I have a form that has a subform (subform1) and a subform (subform2) in that. The data is entered in the subform2, but I need subform1 to save a record as well. I default a textbox to the ID I need to save, but it wont save because I dont enter any data in that form. What is the call I need to...
Top Bottom