Almyta Systems Homepage
Forum Home Forum HomeAlmyta Control System (ACS) and ABC InventoryInstallation, Updates, Technical Issues
  New Posts New Posts RSS Feed - fSupplierFilter Error
  FAQ FAQ  Forum Search   Register Register  Login Login

This site is dedicated to Almyta Systems Inventory Software

fSupplierFilter Error

 Post Reply Post Reply
Author
Message
jrozek View Drop Down
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: buffalo, ny
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jrozek Quote  Post ReplyReply Direct Link To This Post Topic: fSupplierFilter Error
    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!
Back to Top
jrozek View Drop Down
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: buffalo, ny
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jrozek Quote  Post ReplyReply Direct Link To This Post Posted: 04 Feb 2014 at 12:16pm
Hello?

Anyone?
Back to Top
Debra View Drop Down
Senior Member
Senior Member


Joined: 22 Aug 2011
Points: 593
Post Options Post Options   Thanks (0) Thanks(0)   Quote Debra Quote  Post ReplyReply Direct Link To This Post Posted: 04 Feb 2014 at 2:14pm
Yes, the bug it there. I have just checked it. What version are you using?
Back to Top
Debra View Drop Down
Senior Member
Senior Member


Joined: 22 Aug 2011
Points: 593
Post Options Post Options   Thanks (0) Thanks(0)   Quote Debra Quote  Post ReplyReply Direct Link To This Post Posted: 05 Feb 2014 at 7:23am

you can close Almyta, download this file

http://www.almyta.com/downloads/acs_static.zip

and unzip into C:\AlmytaSystems folder.

This will fix the problem.

Back to Top
jrozek View Drop Down
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: buffalo, ny
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jrozek Quote  Post ReplyReply Direct Link To This Post Posted: 05 Feb 2014 at 10:00am
Great!  Thank you!  Perfect!
Back to Top
jrozek View Drop Down
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: buffalo, ny
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jrozek Quote  Post ReplyReply Direct Link To This Post 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;'


Back to Top
jrozek View Drop Down
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: buffalo, ny
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jrozek Quote  Post ReplyReply Direct Link To This Post Posted: 18 Feb 2014 at 8:02am
Not sure if anyone saw this?  
Back to Top
Debra View Drop Down
Senior Member
Senior Member


Joined: 22 Aug 2011
Points: 593
Post Options Post Options   Thanks (0) Thanks(0)   Quote Debra Quote  Post ReplyReply Direct Link To This Post 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 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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

This page was generated in 0.219 seconds.