Search results

You have again saved the day! Thank you so much! I REALLY appreciate it!

For some reason if I do an INSERT statement it performs the insert on BOTH my linked SharePoint table as well as the local Access Table. It's very peculiar as if I do an insert from local access table to local access table only the destination table receives the insert. I've come up with a...

Problem with brackets I needed to use quotes only and no brackets in the table name One issue remaining tho, I did this as a make table query and the query is setting the comments field as short text so data is truncated

If I specify “[account name] = 231” For the where Clause the query will execute as expected. But I want to generate column history for all results the select query returns.

Okay, maybe I’m mid understanding. At the moment I’m just wanting to run a straight select query from my share point table - [animal tracking] Field name - comments And for the where [account name] = [account name] (both from the SharePoint table I changed the alias to a different name than...

They are not smart quotes in the query. Agreed, spaces in field names is horrible but that is how they are set up in SharePoint and I am unable to change [account name] is number data type

I have this as the SQL for my query but it produces #error for comments Select [animal tracking].[account name], [animal tracking].[parent animal], ColumnHistory(“[animal tracking]”, “Comments”, “[account name]=“& [account name]) As Comments From [animal tracking] Where [status] = “Active”...

Local tables being out of sync is not an issue (I know it sounds crazy but its not). What would be the VBA code to alter my table to add a column to house the comments, and then back code to copy comments from the SharePojnt table to my local table?

Thanks everyone for the links and insight!! I may be thinking of using this in a way not so good... I have my linked SharePoint tables, and am creating 1 Local Table of ONLY the records that are relevant to me (essentially cutting the SharePoint Table from 3K records to 200). --> Now I was...

I am linking in multiple tables from SharePoint into an access database, I have no control or access to the back-end SharePoint tables. My issue is that in SharePoint there is a field that is a memo? Or super long text, and append value is set to true, so that you see historical data "stacked"...

For my beginner self, I see the difference in the code syntax, but what exactly does doing this actually "do"?

Hi - I found a post from @June7 assisting another member here and my issue is quite similar, so hopefully not much mofidication is in order. I am in need of creating an email draft for each row in my recordset. So if the recordset returns 3 then I need 3 drafts created. This is the code I...

That was perfect! Thank you kindly!

Unfortunately not. It’s a linked sql server table into access and I am unable to modify the source table. I could create a local access table and put the data into a more friendly format if that would help.

I need to query my access table to determine which review each employee needs completed. We have 6 fields Empreview1start Empreview1finish Empreview2start Empreview2finish Empreview3start Empreview3finish What I am after is a query that will show this: If empreview1start is not null and...

Okay, I took it back to basics and all of you above are correct the function works as it should. My issue was with variable scope.... Let me illustrate further... I have a Module where I have Public contactName As String Public Function ValidateInput (contactName As String) If...

What do you mean?

Those are the real data I’m testing with. I’m posting from mobile so it is messing up the quotes.

I am working on a function that will scan a string to see if it has a comma. If I use Function CommaCheck() If InStr(“Bob, Frank, James”, “,”) = 0 Then Debug.Print “No comma” Else Debug.Print “At least one comes” End If End Function This properly identifies the comma - however I’m...

Hi - thank you for the continued support!! Okay, so I have created the SQL for my join - which I believe should be set as the Row Source for the combo box. Now, I have only used a combobox for one field, which leads me to my question of how do I capture the EmployeeFolder based off the...