Installation, Updates, Technical Issues

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.
URL: http://www.almyta.com/forum/forum_posts.asp?TID=5663
Printed Date: 14 Jul 2020 at 11:17pm
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com

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!

Replies:

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

Hello?

Anyone?

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

http://www.almyta.com/downloads/acs_static.zip" rel="nofollow - http://www.almyta.com/downloads/acs_static.zip

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 http://www.almyta.com/downloads/zipped_upd_312_37Z.exe" rel="nofollow - http://www.almyta.com/downloads/zipped_upd_312_37Z.exe 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.