ACT Help

Hi Experts!

Is there a way I can have a proper invoice number on my invoice report , my invoice report is generated from the following tables :

(1) tblInvoice
(2) tblLinedatails

Currently I'm using PK number to act as an invoice number from tblinvoice, what I want is something like "Year & 000000 & PK number ) example something like ( 2017 000001) assuming the 1 represent the tblinvoice PK

Regards

Chris

5 Comments

[Webinar] Lessons on Recovering from Petya

LVL 10

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

I'm writing a batch file that needs to read In a text file with multiple lines (2-3 or more) and assign them to variables (i.e. Line1, Line2, Line3). which will then act on those to run jobs based on the variables read in. What is the easiest way to do this preferably without for loops or delims. etc.

Thx,
Brian

1 Comment

LVL 1

Question by

unrealone1

2017-09-07

Advice on RDS server

Hi Experts, we are looking to introduce a remote desktop server , RDS 2016 , this will provide ACT and Office ,
their setup is as follows 1 x server 2008 (will upgrade eventually) ,20 users in house and 5-10 users remoteing in.
Their main applications are ACT on premise and office. They currently have hosted exchange but we will move them to office 365 eventually. Some of the users access from Africa and even a hotspot in Africa.
Just wondering what type of HP rack server I should be looking at, ideal Raid configuration, memory ?
thanks in advance.

4 Comments

I have a device (piece of equipment) on a local LAN that i would like to connect to our LAN remotely. If i have a laptop connected via VPN over a WiFi connection, can i connect this device to it's extra LAN port and somehow bridge the adapters and have this device act like it's on the LAN? the laptop is win10.

2 Comments

Can someone convert my database over

0 Comments

We are planning on standing up 2 Exchange 2016 servers. One in the Americas and one in Asia that would also act as failovers.
How can I setup the 2 IronPorts to differentiate between the two locations? Both would be serving the same domain.

6 Comments

I would like to demote RODC server (Windows server 2012) to disjoin the domain and act as a local file sharing server only. Please give a brief actions of what I could do? step by step in short brief only would be okay.

Many thanks.

1 Comment

Question by

jegajothy

2017-08-03Solved

Act for SAGE

My OS is win 10 pro 64 bit and I have a stand alone Lennovo M72e PC. I also have Office 365 the Business Essentials license and use Outlook the owa version for my msn email.
I have used previous versions of ACT but due to pc changes, I lost it and the program too. BTW what is the new version and will it work with my OS and my present pc set up. is there a trial version for me to check it out again.Thank u.

3 Comments

Question by

Rupesh Nagarkar

2017-07-19

Excel to access database

Hi,

I am Rupesh & I am new to this forum.

I am trying to build a tool in excel which can update database maintained in access.

There will be 3 to 4 user for this excel tool which will be connected to one access database.

The excel will act as the front end tool & access as a backend tool.

I want excel VBA to perform 3 things:

1. It will update data in access based on 2 column which will act as a unique code.
2. It will add any new row if the data doesnt match with previous unique code.
3. If the user wants to delete perticular row / range then it will be deleted from database also.

Below sample of table:

Country      Product code      Sub-Brand      Mfg Base
Russia      SRU030008869020137      Syrups      Own
Russia      SRU030008869020141      Syrups      Own
Russia      SRU030008564220158      Tablets      Own
Russia      SRU030008564220258      Tablets      Own
Russia      SRU030008564220558      Tablets      Own
USA      SRU030008869020137      Syrups      Own
USA      SRU030008869020141      Syrups      Own
USA      SRU030008564220158      Tablets      Own
USA      SRU030008564220258      Tablets      Own
USA      SRU030008564220558      Tablets      Own

1st two column will act as a unique key.

We cannot use a replacement code since there will be multiple user working on different region, replacement option can change or erase others database.

Thanks for the help in advance.

Regards,

Rupesh.

4 Comments

The following code connects only when ODBC is set up with Windows Authentication instead of specific user account. I have set it as User Defined. Is there a difference between User defined and Systen DSN in my case? Here is code the snippet :
OdbcConnection DbConnection = new OdbcConnection("DSN=NRFUsers");
string UserId;
string fullname;
string email;
string Act;
string EmpNum;
string Loc;
string sDomain;
try
{
DbConnection.Open();
OdbcCommand DbCommand = DbConnection.CreateCommand();
DbCommand.CommandText = query;
OdbcDataReader DbReader = DbCommand.ExecuteReader();

while (DbReader.Read())
{
UserId = DbReader["UserId"].ToString();
fullname = DbReader["Full_Name"].ToString();
email = DbReader["Email"].ToString();
Loc = DbReader["Office"].ToString();
EmpNum = DbReader["Emp_Num"].ToString();
Act = DbReader["Action"].ToString();
sDomain = DbReader["Domain"].ToString();
WriteLog("User: " + EmpNum + " " + fullname + " " + Act, "NRFUser.log");

3 Comments

Enroll in September's Course of the Month

LVL 10

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Hi,
We experience a problem with Outlook room booking in the following case:
1. I book a reoccurring meeting every Thursday for 5 weeks and add a Meeting Room to the invitation.
2. The meeting room is occupied 1 Thursday out of the 5 Thursdays in question
3. When I send the invitation, Outlook (the meeting room) declines ALL 5 Thursday meetings
What I would like:
4. Instead of Outlook (the meeting room) declining ALL 5 Thursday meetings, I would like the meeting room to accept the 4 thursdays where the meeting room is available and only decline the 1 Thursday where the meeting room is occupied.
In my old company, they had set up Outlook to act as bullet 4. But in my new company no one knows how to set up Outlook correctly, so meeting rooms will not dismiss all meetings in an reoccurring event, but only the one(s) where the meeting room is already booked.
I hope, you can help us with the problem :) Thank you!

ACT
Outlook

2 Comments

I have a subdomain that I want to navigate directly to the login page of my ACT website. However, when I type in the domain name I get the IIS7 landing page from the server. Also, I want to redirect from port 80 to port 443.

In essence, my goal is to have the sub-domain land on the ACT login page and route all insecure traffic to the secure ports.

Please help

ACT
iis7

3 Comments

Which Database Choose?

This Article about choose the NOSQL database based on application requirement. Different NoSQL DB’s available, there are three primary concerns you must balance when choosing a data management system: consistency, availability, and partition tolerance.

* Consistency means that each client always has the same view of the data. * Availability means that all clients can always read and write.

* Partition tolerance means that the system works well across physical network partitions.

Chose the Database system based on your application requirement.

Example Comparing MongoDB and CouchDB.

As you can see in the diagram, MongoDB and CouchDB are built with a slightly different focus. Both scale across multiple nodes easily, but MongoDB favours consistency while CouchDB favours availability.

In the MongoDB replication model, a group of database nodes host the same data set and are defined as a Replica set. One of the nodes in the set will act as primary and the others will be secondary nodes. The primary node is used for all write operations, and by default all read operations as well. This means that replica sets provide strict consistency. Replication is used to provide redundancy - to recover from hardware failure or service interruptions.

CouchDB uses a replication model called Eventual consistency. In this system, clients can write data to one node of the database without waiting for other nodes to come into agreement. The …

0 Comments

Add Comment

Post by

Melinda Burns

2017-06-06

Does anyone know about this ADA Website Accessibility regulation?
The U.S. Department of Justice (DOJ) is currently working on regulations regarding website accessibility for visually impaired individuals. The regulations would apply to state and local governments described in Title II of the Americans with Disabilities Act (ADA). On April 29, 2016, the DOJ issued a Supplemental Advance Notice of Proposed Rulemaking (SANPRM) titled “Nondiscrimination on the Basis of Disability; Accessibility of Web Information and Services of State and Local Government Entities.” The DOJ plans to extend rulemaking to all public websites sometime in 2018.

1 Comment

LVL 2

Administrative Comment

by:Mr. Wolfe2017-06-08

Hi Melinda,

I know this may be confusing, but you posted a "Post" rather than a question. "Posting" is for sharing information where asking a question is for getting answers.

Click the blue "Ask a Question" button and ask that way. I suggest selecting topic for Web Development.

Mr Wolfe
EE Moderator

Add Comment

Question by

racepro

2017-05-31Solved

message box

Hi,
I have lost an Excel file several times for not disconnecting an API program.
Therefore I would like a message box saying "Have you logged off?" that appears when I try to close the Excel workbook. This will act as a reminder and save me from hours of file reconstruction.
Many thanks
Ian

10 Comments

Question by

John Ellis

2017-05-17Solved

Excel: Adding a "Permanent" Formula Column

Hello:

I have created an Excel spreadsheet that pulls data from SQL through a T-SQL query that I created and placed in the Excel "Data" menu's "Connections" section.

I just found out that I need to add a column, to this spreadsheet, that will act as a formula column to eliminate a case sensitivity issue.

Anyway, this column will be a permanent column in the sense that the formula in each row for that column will need to be automatically "copied straight down" the column every time a new row is added to SQL and therefore to the spreadsheet.

How do I go about doing this?

Thank you!

John

3 Comments

LVL 10

Post by

Experts Exchange

2017-05-16Edited

Friday, May 12th, a new Ransomware threat named WannaCry came onto the scene, affecting organizations in over 150 countries. Damage includes more than 200,000 people infected with the malware and roughly $28,463 paid in bitcoin to decrypt files. That number may only rise unless companies act to mitigate the threat.
Though WannaCry wasn’t a targeted attack on any particular company, institutions using Microsoft operating systems no longer supported by Microsoft security updates found themselves affected by the fast-moving malware.
For a more in-depth look at this attack, check out the following resources:
1. Learn how to prevent this threat without paying a dime.
2. Explore ways to plan ahead and prevent against possible future ransomware attacks.
3. Mitigate damage with these tips if your organization has been affected, and more.

0 Comments

Add Comment

Question by

DaveWWW

2017-05-15Solved

Using Outlook 2016 with ACT 2012 Pro

I have a client who will be running ACT 2012 until his company merges with another early next year.

I've just installed ACT 2012 Pro on a Windows 10 Machine running Office 2016. With a little tweaking the program works under Windows 10. However, in the ACT 2012 email setup, Outlook (2016) does not show up as a choice. I've seen this before with other programs such as old versions of Simply Accounting, and that sort of thing.

Is there a workaround for this? (Actually I'm not sure what's causing it). I can install Outlook 2007 back on his machine for the time being, but I'd rather not.

Thanks.
Dave

2 Comments

Question by

Nicholas Salomone

2017-05-10

Input Over If Statement

Hello!

I am designing a template that sales people will use to log their activity. I want to make it so that, for example, cell D3 changes to "someone@example.com" when email is selected from the drop down list in E3 or "(XXX)-XXX-XXXX" when mobile phone is selected. This is easy to be done, however, when a sales person goes to log the data they will have to erase the formula to put in the info. Is there any way it can display the data I want but then act like an empty cell when a user goes to input data?

0 Comments

Free Tool: Path Explorer

LVL 10

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Our domain controller is down for good. We have 2nd DC which act as backup. Active directory is there but no DNS and when i tried installing DNS, it gives me an error

2 Comments

LVL 1

Question by

unrealone1

2017-03-22Solved

GPO to Load Add-ons for MS Office?

Hi Experts,

I want to find out if there is a way I can control the load behaviour of certain MS Office Add-ons via GPO. In specific terms the ACT! intergration add-in which adds historical records into ACT! when a user emails the client via outlook.

I'm also engaging ACT! support resources on this however I wanted to know about the Add-on to see if I could control it that way and could potentially fix?

If anyone has any ideas or advise, would be greatly appreciated.

Thanks,

J

2 Comments

Question by

Mark Lewis

2017-03-20Solved

Mail servers: Smarthost to primary relay?

I'm used to setting up mail hosts with a secondary which is actually a smarthost in case the main host goes down for a while.
In this case, I have a primary mail server but it's on a network that sometimes has issues and for a variety of reasons, we cannot move it.

Therefore, I want to build a server in one of our data centers that can be highly reliable but it should basically act as the sender and smarthost.

Meaning, it should authoritatively send outgoing email from hosts inside the LAN but it should also act as a smarthost should any of that email be bound for the primary host. If the primary is down, then hang on to the email, keep trying until the host is back online.

I'm not sure how something like this would be set up since I don't want to make the smarthost the primary in the MX DNS records. Kinda confusing no?

4 Comments

LVL 7

Question by

David Needham

2017-03-18

ACT 2009 migration from SBS 2003 to SBS 2011

Has anyone out there every migrated ACT! 2009 from SBS 2003 to SBS 2011? Old software I know, but I'm trying to help a friend who still uses this.

Essentially I've successfully installed and registered ACT! On the SBS 2011 server and moved all data across from the SBS 2003 server. I can connect to ACT on the SBS 2011 server locally, but cannot get it working over the network. Any ideas?

35 Comments

Question by

MJB2011

2017-03-10Solved

Xenapp storefront config design question

Need some assistance with designing the best soultion for the storefront servers that will offer both the most efficent conenction for users and resilience. I have a diagram that show the network layout where users and app servers will be situation.

Zone1: Has local storefront server. Users access application hosted locally on site and also application deployed in Zone app servers.

Zone2: Storefront used to service users connecting from European sites to access apps on Zone 2 servers.

Question. What is the best way to configure the storefront server at each site? Ideally I want them to act as a failover. I also want to them to a zone so that users connections are serviced by the closest storefront server.

In the past I have used a round robin connection. but i dont think this is best for this setup, or is there some other way I can achieve this?

I think the problem is that I want to use a single unique name for the storefront connection. This works fine with a round robin setup, but i dont see how i can use this method with zones as well.

I could have both servers in zone two using round robin, this is the center of this MPLS network and the connection to zone 1 is 100MG.

Your thoughts?

2 Comments

Their primary location, here in xxxx, has a new server up and running with a single Windows Server 2012 R2 Standard VM that is acting as their domain controller, primary DNS server, and file server for their xxxxx office. In xxxxx, we have an identical server that we are spinning up a new Windows Server 2012 R2 Standard VM on. This server will act as a file server for their aaaaaa office, but I also want it to be a domain controller and DNS server for their office. Now, here's the thing though. I want them to BOTH be on the same domain. In other words, I want to setup xxxxxx to be the primary domain controller, and aaaaaa as the secondary domain controller. All of the workstations will point to the xxxx VM as their primary DNS and the aaaaa VM as their secondary DNS via a site-to-site VPN connecting the two networks. In aaaaa, it would be just the reverse, with their workstations looking at the aaaaa VM as their primary DNS and then xxxxx as the secondary DNS.

[10:30]
In practice, this was working fine when we had it setup working in the lab. However, from an actual deployment and production standpoint, what do you think? Are there issues with having basically a "child" domain controller of a primary domain located in a different location connected via Site-to-Site VPN?

1 Comment

COURSE of the MONTH

ACT

Related Topics

ACT

Related Topics