Search results

  1. D

    New Form cannot be open automatically

    Just redo the cmd button. Maybe the name of the frm is not spell properly
  2. D

    check Boxes

    Is there a way that when I select A ck bx in my form, it will place text in the table current field. Example Admin Transfer = ckbx instead of -1
  3. D

    need subfrms to be nested in main form

    I was able to add a cmd buttom and display my first subfrm, But id does not link to the main frm any ideas will be greatly appreciated dennis
  4. D

    need subfrms to be nested in main form

    Thanks to all. I will look into it. Will let you know how it turns out Thanks Dennis
  5. D

    Sub-Form not retaining data

    Need to link it,go to properties tab data, in design view click the upper left corner of the subfrm (by Id) and linked it.if you need help and your db is not that big e- mail to me
  6. D

    need subfrms to be nested in main form

    I would like to have a main form and various subforms. by click a cmd buttom would like to have next subfrm to replaced previous etc.like frames any ideas thanks Dennis
  7. D

    Does anybody have a sample (cbo Bxs)

    I need to sincronized to combo bxs. Categoties Subcategories. Never done it before. If possible does anybody have a sample DB Thanks Dennis
  8. D

    updating a form

    I have a form that tracks how many people are serviced, after completing certain number of records on a daily basis, would like to see just the ones that are not serviced yet. any ideas thanks
  9. D

    Find Work Days

    Thanks so much for responding David R. I follow your e-mail I just don't know What I did Wrong the query will not even open I have two fields in the tbl_Dates StartDate EndDate Query I placed both fields inside the query plus ([StartDate],[EndDate]) saved and the query will not open, I do some...
  10. D

    Find Work Days

    If I type a Date From Monday to Friday I get the right number of working days. if I type Sunday Date to Saturday Date I would like it to = 5 full working days any ideas thank you Dennis
  11. D

    Time in and Time out

    Thanks to Pat, and Jatfill it works great. and this fine site with all who get involved Thanks Dennis
  12. D

    Time in and Time out

    Thanks for responding so quickly, Is working just fine,.... I just noticed that when I go back to the record, "Time In" changes to the actual time. It should stay static once completed. Did I miss something? Thanks Dennis
  13. D

    Time in and Time out

    I have a form that tracks the following: Date = Date() Time in = Time() Time Out = Time() My problem is with Time in and time out. Need the form to register the "time in" when the record opens in the form. "Time Out" need the form to register the time out on Exit??? The idea is to...
  14. D

    Single date parameter

    I did it on my own =([Date]) It does what I need
  15. D

    Single date parameter

    How do I retrive a single date with a Parameter. I know, Between[] and []. I want to be able to type just a particular date only thanks Dennis
  16. D

    Forms slow to open

    We experience the same problem from time to time, and I know is the network. To proof a point, if you copy the tables from your network drive and placed them locally C:drive then link your DB to the local tables you will see Db move faster.Or just open a local file. I read before that is not a...
  17. D

    Forms slow to open

    Is your database connected to a network? When was the last time you compress the database? Does your computer have enough memory? Dennis
  18. D

    No of days between two dates

    I get paperwork with salary adjustments, dates range between 01/01/99 to 06/25/02. These people are teachers their salary need to be updated and we calculate the difference between the effective date (their adjustment has been granted)to the end of the school yr, (06/25/02) will this help you...
  19. D

    No of days between two dates

    This Q? is for Pat Hartman.(He is the man) Need to calculate the difference between two dates. The trick is. Is based on 21 pay periods in a yr. 10 days per period (210 days total) if someone gets pay on a monday - Friday Sunday date is used for beginning date. and Saturday is used for ending...
  20. D

    Last update

    Have a system date or stamp date =date() would like to know everytime a record has been changed (Last update) If I used system date Is this correct? Private Sub Sys_Dt_Change() [L_Update] = Date End Sub please Advice thank you and last Do I need a separate field for update
Back
Top Bottom