Search results

Eventually, the idea is to put this into a SharePoint List. I figured it might be easier to fix it on the database side first before making that transition. Looking for the most efficient solution to the problem. Right clicking and editing hundreds of hyperlinks is not an option.

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

Thanks Kyo. I was just going to ask if it was the workbooks property that I should be using.

That gives some food for thought. I had once written a VBA program that went like this: Dim outobj As Outlook.Application Dim outappt As Outlook.AppointmentItem Set outobj = CreateObject("outlook.application") Set outappt = outobj.CreateItem(olAppointmentItem) With outappt ' 'Enumerate...

sure, 438 is object does not support this method...which is true of excel application object...it does not support the .saveas method what I am asking is there an alternative for saving this? it seems I should declare a workbook and .saveas from that object, but I came away with similar...

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

:o typo in one ID that I used exclusively for the test... Public internet forums: anonymous embarassment since 1995!

The same, both NHD_Name and NHD_Email return blank. The number of records is as expected, so the Where clause is opertating correctly.

Thanks. I was getting 0 records previously. I ran the left join as you suggested on tbl_NHD and now I get the two records I expected, but the NHD fields are blank. I can assure you I have the IDs and records in the NHD table and the data types are the same (long integer on the NHD_SAP_ID in...

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

Great resource! thanks!

Thanks for the tip, but no, that did not solve the problem. I don't have forms that would lock the records (yet), nor were any of my tables open or being utilised in any other way during runtime. I wonder if the join in the recordset creates the lock? I am stumped.

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

my apologies, I made a typo, missed one character It works beautifully, many thanks!!

returns a different error with that placement of paretheses; 'Syntax error in JOIN operation'

SELECT Follow_Up.*, Mentor.EMAIL_ADDRESS AS Mentor_Email, Emp.EMAIL_ADDRESS AS Employee_Email FROM Follow_Up INNER JOIN Employee AS Mentor ON Follow_Up.Mentor_ID = Mentor.Emp_ID INNER JOIN Employee AS Emp ON Follow_Up.Emp_ID = Emp.Emp_ID; I tried your alias suggestion, but I keep running into...

Also are there not potential problems with data types in doing it as such? I mean for this it is just a formatting issues, ($ vs % vs integers), but there could be different data types used for measurement of various kpi, such as the 'good, bad, fair' example that you provided as opposed to say...

I see what you are saying. One question, how do I observe the realtionship that the KPI value belongs to a certain Emp_ID for a certain Period_ID on the other table? Just add those foreign keys?

I see what you are saying. However, I think my mistake is to use the X1, X2...Xn as placeholders in this thread. I did that for privacy reasons. What I actually have is a table that looks like this Emp_ID, Period_ID, Manger_ID, Job_Errors, Revenue,....etc and data that looks like this...