Print Page | Close Window

fSupplierFilter Error

Printed From: Almyta Systems
Category: Almyta Control System (ACS) and ABC Inventory
Forum Name: Installation, Updates, Technical Issues
Forum Discription: Dedicated to any technical issues of the application.
Printed Date: 23 Jan 2021 at 4:31pm
Software Version: Web Wiz Forums 10 -

Topic: fSupplierFilter Error
Posted By: jrozek
Subject: fSupplierFilter Error
Date Posted: 31 Jan 2014 at 6:37am
Good Morning.  

I receive an error when I try to filter my assets by Asset Type. 
Pulling the error logs, I see the following:

Syntax error in string in query expression '((Asset.DC = 0) And ([AstTypID]="2)) ORDER BY Asset.AssetTag;'.

Note: Computer-Name-user.adm, Assets:fSupplierFilter

Error #3075.

I'm pretty sure I see where the problem is---it looks like a double quotation is missing in the [AstTypeID]. However, I cannot find where this expression is to fix it.

Can anyone provide assistance?  Thanks!

Posted By: jrozek
Date Posted: 04 Feb 2014 at 12:16pm


Posted By: Debra
Date Posted: 04 Feb 2014 at 2:14pm
Yes, the bug it there. I have just checked it. What version are you using?

Posted By: Debra
Date Posted: 05 Feb 2014 at 7:23am

you can close Almyta, download this file" rel="nofollow -

and unzip into C:\AlmytaSystems folder.

This will fix the problem.

Posted By: jrozek
Date Posted: 05 Feb 2014 at 10:00am
Great!  Thank you!  Perfect!

Posted By: jrozek
Date Posted: 11 Feb 2014 at 10:28am
I am having this same error again.  We had to replace the machine this was on, so I installed on a new machine.

I copied your accdb file into the c:\almytasystems directory, but when I try to filter by asset type, it is once again giving me the "3075 error:"

Syntax error in string in query expression '((Asset.DC=0) And ([AstTypeID]="1))ORDER BY Asset.Asset.tag;'

Posted By: jrozek
Date Posted: 18 Feb 2014 at 8:02am
Not sure if anyone saw this?  

Posted By: Debra
Date Posted: 19 Feb 2014 at 6:35am
If you have version 37Z or older, you can update your software manually.
Close all instances of Almyta Control on the PC.
Download this file" rel="nofollow - into C:\almytaSystems folder.
Run the file or change the extension from .EXE to .ZIP and unzip manually.
Start Almyta Company Selector, high-light your company, click Maintain, click Update Now.

Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 -
Copyright ©2001-2011 Web Wiz Ltd. -