Search results

I would like to be able to update a hyperlink such that I can specify text to display and the address, but whenever I update it only changes the text to display. Basically I have a table that is just an ID nubmer (Doc_ID) and the hyperlink and I want to update the Hyperlink so that Text to...

Trying to create loop to save a bunch of workbooks. I keep getting runtime error 438 on the .saveas method. Any thoughts as to a resolution for this Option Compare Database Private Sub query_loop() Dim mydb As DAO.Database Dim rs As DAO.Recordset Dim i As Integer Set mydb = CurrentDb Set...

I have a query which essentially joins names and email addresses out of several tables. The query joins correctly if you do not include the final join and I can't figure out why. SELECT tbl_Session.*, tbl_agent.Agent_Email, tbl_team_mgr.TM_Name, tbl_team_mgr.TM_Email, tbl_NHD.NHD_Name...

Problem: I want a button in Word to update access table with a value set by a drop-down field in the same Word document. The drop down field is to set the Status_ID field in the Access table. It has an integer value (1-9) that corresponds to text drop-down selectons for things like 'cancelled'...

I have this segment of code which creates an outlook appointment for a session. I implemented a 'Status_ID' field which I want to update in the recordset after sending the appointment. The Status_ID field indicates whether things like cancellations, reschedulings, but also whether or not the...

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 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...

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...

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...

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...

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...

I have a table FCData with the following fields FCData ------------ ID ----> auto assigned primary key Emp_ID DT ------------ On any given day an employee, represented by Emp_ID, can be recorded multiple times. I want to know if I can query to show how many times per month an employee is...

I have a table (Session_lst) which is a list of appointments. It has the following fields Session_lst --------------------- Session_ID Session_date Session_time Session_duration Agent Agent_mgr Appt_booked --------------------- I want the table to book the appointments with myself and the...

Hi, I am having issues with the following code: Private Sub AddAppt_Click() On Error GoTo AddAppt_Err ' Save record first to be sure required fields are filled. DoCmd.RunCommand acCmdSaveRecord ' Exit the procedure if appointment has been added to...

Two months ago something happened to a server that caused a bunch of data collected by an application to corrupt a field. The database is a collection of information about employees, some served from another database (where the problem originated) and some collected in a form. To simplify...

I have a table of accounts with the following fields Account_ID First_Name Last_Name Institution Account_type I have created a form that allows me to enter in new records via text fields (list box in the case of Institution). What I want to do is to have a query search an existing record as...