Search results

Can you elaborate? I had thought of building it with 8 tables, one for each KPI, but I am a bit limited, both by time and the way the data is sent to me. However, I am curious from a learning perspective. Are you able to illustrate an example of how you might structure it differently? Let's...

I have the following query, which gathers a set of kpi for an employee across two reporting periods. PARAMETERS [Enter_ID] Long, [first_period] Long, [second_period] Long; SELECT * FROM kpi WHERE PERIOD_ID in ([first_period], [second_period]) AND Manger_ID = [Enter_ID]; What I hope to...

I had thought of doing it that way, and perhaps it highlights a limitation in my knowledge of queries. I understand the join on one of the ID's but I am dealing with 3 IDs in that table, the employee, the mentor, and a manager (which I have not included for simplicity of problem solving). How...

The idea behind these recordsets is to keep the db as normalized as possible. For the session table I just have the ID's of the various employee's involved in the meeting and the intention of the additional recorsets is to query the email addresses for these employees from an employee table...

I have this code (below) that loops through a recordset and sends appointments. It executes the queries correctly and sends all appointments in the table, but sends them only to the contacts listed in the first record of the query. How do I get it to loop the contact details? Can you point out...

Suppose you had three tables in an employee database, 1 for a frontline employee, 1 for their direct manager, and 1 for their manager's manager. If a frontline employee then becomes a manager and is in both employee and manager tables, does this violate normalization if the manger id is a...

Do you think it is necessary to create a table for each KPI?

Hi, I have been tasked with putting together a database for 8 KPI. These KPI are measured on a weekly basis and the purpose of the database is so that it becomes easier to measure change in KPI amongst employees on a week-over-week basis. I struggle to figure how to fit this into a relational...

I deleted the MoveNext by accident when modifying it to put up on the forum. The Excel object libarary 14.0 was turned on. I already figured that may have been the problem, but it still does not want to recognize the object.

Is is possible to generate a workbook for each record in a recordset, and title it using the unique identifier for that record? I created the following code, but it does not seem to work. First of all it doesnt like the string and secondly it does not like the declaration of wb as...

resolved the problem. It seems an AppointmentItem by itself will not send to the recipients. It needs to be declared a meeting using: .MeetingStatus = olMeeting

That's the funny thing. It doesn't send to the outbox either. It only places the appointment on my calendar as the originator.

Hi, I have a module in my database that creates an appointment based on a table of sessions. The module works in all respects, except two: 1) When I declare optional attendees it sometimes shows them as required attendees in the actual meeting in outlook, but not always 2) The .Send method does...

supposing that I create a workbook and export a query to excel that is a table of information about a particular employee is it possible to generate a pivot table and modify the pivot table in that same module, or does one need to open excel and create this? any hints

I have a form template in Info Path that for each employee in an access table I would like to save an instance of the template to a form library in SharePoint using the employees name and ID as a file name. Is this possible?

I have a query that basically pivots some data. I want to get the result of this query into a table of its own, but I can't figure out why INSERT/UPDATE statements won't work with the TRANSFORM. The query is currently this: TRANSFORM Max(tbl_Caller_tally.countof_empID) AS MaxOfcountof_empID...

Currently the query (posted above) executes like this: CallerEmpID_Count___Mth_Yr 9094________21____05_2013 9094________25____06_2013 and I would like it to look like this: CallerEmpID__05_2013__06_2013 9094__________21_______25 and I want to do it without the extra step...

I have a table that I want to count the employees by the number of times they call in a month. The table has the following fields that are relevant: CLL_ID CallerEmpID DT I have made this query which returns my answers, but I would like to make each "month_year" a column field and return a...

:banghead: Thanks!

Still having issues with this code. I attempted to run the code and it created 6600 appointments before it crashed on a dummy database with 3 records in it, one of which it should have ignored due to the recordset query. Any reason this is not picking up on the EOF? I also had the intention...