Search results

OK, have a question about a form that I made based on query. I put in the query that you need to enter the Associate name to open the form. However, the query opens nothing when you use the last name. You have to use the employee id number. How can I set this up so that I can enter the last name...

Here is another try at this database. I set this one up based on your suggetions. Let me know what you think. have some queries written but they are really basic. Thanks David V.

Good Morning. Thank you for the suggestions. I do have a few questions though. Should I delete the Supervisor Table all together? Also, what is the differenct from the Issue date and received date. In my case they would be the same, so I don't think I need that field. And one more, I think...

OK, here is another copy of the database I am trying to create. Hope this helps you help me. Thanks David V

Good morning. I found where to remove the replica on the tables, but having problems removing it from the forms. I even deleted the forms and rebuilt them and they still show as replica. Do you know how to remove it from the form? Thanks David V. Sorry to be such a pain.

Thanks for the info on that Replica thing. I deleted that post so it is no longer on the forum. I have attached a copy of my database. I changed the names of the employees though. I also entered "=Date()" into the "Default Value" of the form and it works. Thanks. I worked on a report today, but...

Thanks for your responses and your assistance. This database will basically just count the issues received via written letter (true Pres), phone calls (verbal) and email (CRL). We also track the number of furniture(FBCS) issues completed as the standard for those issues is more forgiving. I...

Thanks Wiklendt, you have been absolutely wonderful. This does make sense and it is easier on my part. However, I am moving this from an excel spreadsheet to access to simplify the process for the people that enter the data. Today, on our spreadsheet, they just tab to the field and enter the...

Thanks for the suggestion, but still not working. I may misunderstand what the smiley face is. Is it DateWeekDatePart("ww",[Sum of TPreceived])?

Maybe this will help. Here is what the excel spreadsheet looks like. Any assistance is greatly appreciated. Thanks David V.

Thanks for the suggestion. I will try this. However, I failed to mention that the issues carry categories, so my main table actually had more fields than what I originally said. I have "written", "verbals", and CBR's as issue types and then categories of Normal and Furniture. I think I might...

Help!!! Please, I have been pulling my hair out for a week now. I and building a database that tracks productivity. Basically I have a table of Employees and a table with fields that list the items we are tracking. To make it simple, the Productivity table has fields of Date, received, and...

Actually, I am having trouble getting the totals that I want in a query. Here is an example. Date Received Completed FBCS Completed 12/1/09 2 1 0 12/2/09 3 1 1...

I appreciate your response, but having problems making it happen. I am using the wizard to create this form, but when it gets to the view part, it lists the Employee id as the main form and the Productivity as the subform. I need to have the date field in the main form. I think it might be a...

Thanks. I thought she was adding this to a field on a table, not a form. Do you know if there is a way to do this on a table? I have a table that I would like to sum the number of benefit days and FMLA days. I cna do it with a query, but woul dlike it to sum on the table. Thanks David V.

This would certainly be helpful to me as well, but not sure what field property you are entering this formual. Please let me know if you have time. Is it Format, Validation Rule, Input Mask? Thanks David V.

Thanks for the reply, but I need to use the time as well as the date. I have a networkdays code, that has the time, but it does not calculate correclty. I found the code I submitted above that works, but it does not include workdays. Thanks, David V.

I have a query for Date/Time Diff and need to tweak it to include only workdays. Can someone please assist. Here is the code: Function ConvertTimeDifferenceToFormattedString(StringDate As Date) As String On Error GoTo Err_ConvertTimeDifferenceToFormattedString Dim newdate As Date Dim ldays...

I have a spreadsheet in excel that tracks a departments productivity. I am trying to build something in Access to do the same thing buthaving problems with creating the form. In excel it is easy to enter the data because all the names are listed and the auditor who enters the data just has to...

Thanks so much. This does the trick. David V.