Search results

  1. S

    report to look like form

    Ok I will give it a try and see what I can do I may ask for some assistance
  2. S

    report to look like form

    We have imported several db to one main db and now we want to create a report that will look simliar to one of our forms that we use everyday in the office. It would be split by several subreports but each part has a unique number assigned to each part and we want to see every detail on that...
  3. S

    data entry not valid

    Although they give me the proper data I am receiving an entry that says enter in parameter for tblempjobquals.empjobquals what does this mean?
  4. S

    data entry not valid

    Thank you for your help to all. I do have one other question that I dread to ask and that is when we (jzwp22 and I) created reports back in April I have them all formatted properly with my old EmpJobs form. How hard would it be to convert them to the report layout? If needed I can attach some...
  5. S

    data entry not valid

    Just making sure I have the right DLookup DLOOKUP("[jobqualsID]","tblQualfication") from jswp22 reply
  6. S

    data entry not valid

    Considering that each of my employees have different required training where would I put the description so that we know what they have been trained in? Would it go below the job quals number as a combo box?
  7. S

    I hope you had a wonderful summer, I do have one question you worked with my on my work db and...

    I hope you had a wonderful summer, I do have one question you worked with my on my work db and everything has been going well until I went to enter in dates for the dte Evaluation and Basic. It keeps giving me the value you entered isn't valid for this field error and I cannot enter in anything...
  8. S

    data entry not valid

    The version I have attached runs fine and the fields in question also work.You will also notice that I have made changes to the original format of the sheet. Is it possible that I messed something up or that I am using Access 2003 and this was originally created in 2000. However, is there a...
  9. S

    data entry not valid

    When you click the field for dte Evaluation and go to enter in the date it says "the value you entered isn't valid for this field" and yet I haven't entered in any data
  10. S

    data entry not valid

    sorry about that the main form that I work off of is called tblemployees the individual form is called frm empjobs and tblempqualeval The table in the right hand corner doesn't allow any entries and I have more than the two employees each one has about 15-30 training elements that each have...
  11. S

    data entry not valid

    After a lot of cutting down I was able to get it to finally upload. The area that I am having my problem is the lower left corner. When you go and enter in a date and if it is basic, proficient, advanced it says invalid
  12. S

    data entry not valid

    I have tried to upload it but my zip file is too big for your website any suggestions
  13. S

    data entry not valid

    My problem is that I have several different forms on one document 3 of the 4 forms work. For my last form when you go and enter in a date and use the drop down menu for the basic, advanced, proficient it says invalid entry and it also says "invalid amount of data in field when I have only...
  14. S

    data entry not valid

    I had help with my database that was created and all of it works except for two cells that allow the user to enter in a date and if they are basic, advanced , or master qualified. I cannot post it because it is too big. Does it matter if it was originally created in Access 2000 and now used in...
  15. S

    subreport add numbers to count

    I was able to figure out what I was doing wrong with my statement. Thank you for your help.:)
  16. S

    subreport add numbers to count

    I have attached an updated version the table I am using is called NCLOG the column that I am having issues with is SorNC. This is a drop down menu in excel therefore there is no way that I can have separate columns to tally up how many non-conformances in Scrap, NC and Voids. Any help would be...
  17. S

    subreport add numbers to count

    Data will be stored in excel and transferred to Access into a database as attached. What I am trying to do is just have a total of Void, NC, and Scrap. I have started to create the report as in the NCLOG the part that I am getting stuck on is adding up the three items above and then I want a...
  18. S

    subreport add numbers to count

    Can anyone help me with my problem. I seem to be doing things backwards. I have created my report but the columns will not add up for me.
  19. S

    subreport add numbers to count

    Ok I have things straightened out.
  20. S

    subreport add numbers to count

    I will get back with you. I just lost some of my changes. When I separate the one column into 3 Void, NC, Scrap I will set the fields to text and then the code that has been given should work right?
Back
Top Bottom