Search results for query: *

Hey all, Not sure what I am doing wrong with this join for some reason I am unable to link 2 different tables that have a matching linked field. I used the following queries to make sure that there were matching fields.. select * from table1 where cust = 27070 (returns 2738 rows - showing...

Hi all, Recently started up in a new role that is using Pervasive DB to go along with their ERP system. They have a cpl servers running Pervasive fictitiously named ABC and ABCWEB. All of the main data from the ERP program is entered into server ABC Database GLOBAL but reports off of an...

Hello, I am trying to use the following VB macro that works in Excel to encode Barcodes using barcode 128 in Crystal Reports. (Cant use 3 of 9 because I need a space and a comma) Can anybody help me get this to work in Crystal or have a different method of getting Barcode 128 to work in Crystal...

Hello, A friend of mine was using Sage Accpac v6 and now wants to switch to Sage Accounts 50. He is using a SQL 2008 database on a Windows 2008 server. Is there any way to import everything? I tried exporting customer records from Accpac 6 to import into Accounts 50 but I am worried that there...

Heya, Everything taking note of any type of remote IP address, either IIS logs, webpages with Request.ServerVariables("REMOTE_ADDR") or programs like our chat program that show remote users IP addresses are all coming up with our WAN IP address instead of the remote users IP. Everything...

Heya, Our company has an optional field created under AR for "BusinessType". We would like this optional field in CRM so we can create groups based on this field for mass maling, but unfortunately I don't know enough about database administration to make it happen. I guess I am looking to get...

Hey all, At the end of every fiscal year, my company creates a new "Year End" database so if they need to see anything with the way things were at that time, they have a static, different company with that information in it. We have just upgraded to Sage Accpac ERP v5.6 and our Live data, 2008...

Heya all, I have made a subreport with the formula... whileprintingrecords; shared numbervar contractitemprice:= {ICPRICP.UNITPRICE}-({ICPRICP.UNITPRICE}*({@Contract Price Level})/100) it gives me the results im looking for in the subreport, but then when I try and pass the data on to the...

My company has recently purchased a blg that had a Star Talk flash system in it with sw: version 1.7. Right now, if we have it plugged in to a phone box that has "voice mail" written on it, anybody who phones will go straight to an old ccr system setup by the previous tennant. After searching...

Hi, We are coming from using ePOS 5.5 and "upgraded" to the exact same but differently named Acdev POS. We are installing Acdev POS on a different server.(and removing ePOS) Our database is a sql 2005 server, and the os's are win2003 servers. Our problem occurs when installing Acdev POS. When...