Recent content by marsha D. Carpenter

  1. M

    Groupwise Info

    I know how to get the username from groupwise, what I need is to verify whether or not an entered name is a valid groupwise account name. If anyone can give me some assistance here, your assistance would be very much appreciated. Thanks!
  2. M

    Charts/Bar Codes/ and Graphs in VBA

    I need to generate pie charts and bar graphs in VBA reports. I have attacted a copy of the pie chart(s) and bar graph along with the data used to create these charts/graphs in Excel. I have also attached a copy of the tables which I will use to generate these charts/graphs. Three tables. 1...
  3. M

    Please Help - Need up designing a form to capture monthly activities

    need help generating a timesheet applicattion Ok! Thank You! What would the data entry form that captures the data look like? Please walk me thru this! Thank you!
  4. M

    Please Help - Need up designing a form to capture monthly activities

    need help generating a timesheet applicattion Attached is a copy of the Excel files which I must duplicate in ACCESS. Please someone help! This is due on the 29th, Mon. the 27th is a state holiday. I only have dial-up at home. I have looked at several calendar apps and I have gotten some...
  5. M

    Please Help - Need up designing a form to capture monthly activities

    When my boss told me the project could be completed in a day, I asked if he was joking and he replied no. So....... I just started July 1st and I am on probation for the first six months. I don't know if they are trying to send me packing or not.Please help! This is my response to Lagbolt's...
  6. M

    Help me to generate Overtime Report

    Monthly for capturing the daily hours spent on each activity for each month I need help! Do you have a monthly time sheet within your applicaiton?
  7. M

    Please Help - Need up designing a form to capture monthly activities

    I think I have may have already posted something similiar to this. But I cannot locate the post. I need an example that displays how to capture time spent each day per activity for each month. Any valid advice would be much appreciated! I need to capture for each inspector for each day and...
  8. M

    Need Help Changing a record

    Need Help Changing Record I changed the tbldistricts.di field to required and indexed with no duplicates and in tblContactDetails.district, i changed this field to indexed and duplicates ok. I can now update my record! Thanks Rabbi!:)
  9. M

    Need Help Changing a record

    Need Help Changing Record Well! You solved my problem. Thank you so much. I will test it to see if changing the indices works;). I will let you know how it goes. Thanks again and have a wonderful afternoon! Well, it is 11:39am here in Austin, Texas!
  10. M

    Need Help Changing a record

    Need Help Changing Record No, I do not really need the tblDistricts. This table simply has the district number (1-25) and the associated District Name. Since I use district alot, I want to store the district number and not the name into the tblContactDetails table. You have resolved my...
  11. M

    Need Help Changing a record

    Change Routin I ran the following query in the query builder and I cannot add a record to the bottom of the datasheet. SELECT tblContactDetails.EMPLOYEE_ID, tblContactDetails.Status, tblContactDetails.DateReceived,tblContactDetails.TimeReceived, tblContactDetails.TimeCompleted...
  12. M

    Need Help Changing a record

    Left Joins Removed & Still Can't Update. Thanks Rabbi. I removed the left joins and still get the same error. Please assist. Can't update, database or object is read-only. Still cannot update. The query is: sqlstring = "SELECT tblContactDetails.EMPLOYEE_ID, tblContactDetails.Status...
  13. M

    Need Help Changing a record

    Left Joins Removed & Still Can't Update. Thanks Rabbi. I removed the left joins and still get the same error. Please assist. Can't update, database or object is read-only. Still cannot update. The query is: sqlstring = "SELECT tblContactDetails.EMPLOYEE_ID, tblContactDetails.Status...
  14. M

    Need Help Changing a record

    Thank you so much! I'm thinking I should just make a separate form for editing!
  15. M

    Need Help Changing a record

    It is a big mess! I will do better the next time. sqlstring = "SELECT tblContactDetails.EMPLOYEE_ID, tblContactDetails.Status, tblContactDetails.DateReceived, " sqlstring = sqlstring + "tblDistricts.DI, tblContacts.FullName, tblContacts.EmailName, tblContacts.WorkPhone, "...
Back
Top Bottom