Search results

If I test this in the immediate window, it returns 'Hello', however queries are failing ?Left("Hello World",5) Hello

I have created a new Query with following SQL SELECT Left("Hello World",5) and getting Undefined function 'left' in expression error.

This is my query SQL SELECT Employees.IDEmployee, [empfirstname] & " " & [emplastname] AS Employee, Employees.Folder, Employees.EmpEmail, Left([empfirstname],1) & Left([emplastname],1) AS EmployeeInitials FROM Employees ORDER BY [empfirstname] & " " & [emplastname];

Hello, thanks for reply. All functions (i-e Left, Right, Mid, Nz, Trim) in my queries are failing. However, in VBA immediate window they are working fine. I have double checked and there are no missing references.

Hello, I started getting this type of error in queries. I am using JKP-Ads Pro Treeview controls whose reference is adding in run-time with AutoExec Macro. There are no missing references. Left also works in immediate window, I am not sure but these functions are failing in access queries and...

I am closing this out and the only way that works in this case is to use a monospaced font. I have posted the final output (Dummy Data) that may help anyone having a similar issue.

Thanks MajP, I have tried this for padding and the only workaround that works for me is to use monospaced font suggested by Gasman, I will appreciate if there are still any ways to format the string for non-monospaced font.

Hi Gasman, I have pasted my code below. Please check and let me know your thoughts 'Some Variable Declarations here 'Some Recordset Operations here 'Some Treeview Initialize events here Dim FixedColumnStringArray(4) As Integer FixedColumnStringArray(0) = 25 'Column 1 Width...

Thanks Gasman, I have just tried Trim and the same results so far. Any other directions. I am not sure if something with vbTab that breaks the string formatting.

These line of code does not produces 100% required output as some columns in line got extra spacing compared to other. For j = 0 To UBound(FixedColumnStringArray) strFieldValue= Left$(rstTreeview.Fields(j+1).value, s(j)) strLineForTreeViewNode= strLineForTreeViewNode& IIf(j = 0, "", vbTab) &...

Thanks but this is not what I am looking for, I am looking for something that works in Console App to format strings let say PadLeft/PadRight. I am entirely looking for something that format string so that it should visually look like separate columns. Treeview does not support multi-columns by...

The field1, field2, field3, field4 length also varies so I would like to trim the columns to specific characters to achieve the desired results. I will appreciate if there is any code to concatenate and format fixed string texts.

This is not the requirement, I would like to concatenate and format the string so that it looks like separate column data in Treeview (As treeview does not support multi-columns and I am looking for a way to format the string so that the output rendered in Treeview is formatted as the way it...

Hello, I am struggling on formatting text string which is a result of concatenating multiple columns from a table. Here is the scenario I am using Treeview control (MSComctlLib.TreeView) as Treeview does not support multiple columns, I would like to concatenate string and format in a way...

Thanks, I can see a built-in methods in Outlook 2016 to copy rule from one store to another but did not find VBA code snippet to do that? Can you please advise on property that set rule to be created on all accounts?

Hello, I am working on something to automate Outlook Rules through Access/Excel VBA, if I am to create Outlook Rule for Single Account it works fine. Is there a way to create Outlook Rule for All Accounts through VBA, I can see this option on Rule Creation Wizard but I am not sure that how can...

Hello, I confirm that I have my Windows/Office updated to latest build on non-working PC but Shell32.dll shows older version, Is there a way to update Shell32.dll to latest version? Can anyone confirm if Windows Update latest release was on the latest build...

Thanks @Colin, I have attached Shell32.dll attributes log of Working VS Not Working. I have compared the one with recent Windows Update (i-e not working PC) with your log and it almost looks same except few additional attributes.

This is comparatively a slower approach when you loop through number of directories and open each excel file to read BuiltinDocumentProperties.

Hi @Doc_Man, Thanks, I have checked the following Windows Update on 02 of my PC from June-2017 that are having this issue, https://support.microsoft.com/en-us/kb/4022715, Is this related? I have tried to uninstall this update and it is still not working? I think that Windows 10 updated...