ACT

922

Solutions

921

Contributors

Act! (previously known as Sage ACT!) is a customer relationship management (CRM) software application which is used to keep track of client and prospect details in a single database that can be shared by multiple users. Act! features include contact, company and opportunity management, a calendar, communication tools, the ability to track prospective customers, "dashboards", reports, and the ability to synchronize data from other applications or other Act! users over the web.

Share tech news, updates, or what's on your mind.

Sign up to Post

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.
0
Free Tool: ZipGrep
LVL 9
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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");
0
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!
0
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
0
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
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.
0
 
LVL 2

Administrative Comment

by:Mr. Wolfe
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
1
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
0
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
0
ransomwareEmail2.png 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.
6
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
0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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
I have a client with Sage 50 accounting and a time clock.  They have successfully exported the time clock data but sage is not able to import.  Indeed, when you try, all the Import Templates under every category is missing.

How can we get them back?!?
0
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
0
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
0
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?
0
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?
0
diagramNeed 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?
0
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?
0
The life of crime is over for 22 year-old Christian Ian Salvador, a student from Isabela State University in the Philippines.
0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Starting up a Project Part 1
Starting up a Project
0
Introduction to Processes Part 1
Introduction to Processes
0
Progress Part 1
Progress
0
I am trying to install SMS4Act on a computer.
We run a network environment with WIndows 2012 server.  The workstation is Windows 10.  Using Act v16.
I managed to correctly install it once and had it working.  It was a normal install.  It installed without changing any firewall or antivirus settings.
Then I made the mistake of updating it (according to their instructions) and it disappeared.  It still shows in Act when I look at Tools > manage add-ins, but is no longer available.  It will no longer install when I run through the install again.  The install completes with no error messages.
When trying to prepare for the re-install, I run their uninstall program, remove all references to SMS in the registry, delete all files/folders starting with the name SMS.  Nothing works.
I also tried installing it on my own office PC where Act is installed and it will not install, even the I can also see it in add-ins in my Act software.

I'd really like to get it to work correctly.  Any help would be appreciated.
0
I have a primary router DSL, and a secondary router in another part of the house. The problem I'm having is after both being online a link the time, the secondary router affects the primary router and causes it to run slowly. I added a gigabyte switch between the primary router and the secondary router, thinking that would act as a diode not allowing the secondary router to communicate and confuse the 1st router. How would I set the 2nd router up so that it did not communicate and interfere with the 1st router? I have to reboot probably 3 times a day, and after I do both run okay for a while, then the secondary router somehow communicates with the primary and causes it to slowdown. This has nothing to do with what either router is doing, they can just be setting static and it happens.
Hopefully gAksland
0
Does anyone know if I can set up PLEX PLUS on two computers on my home network?  If so, how do I do it?  I currently have it set up on one computer but when I turn it off, I loose access to their server.  I read somewhere that I could use PORT FORWARDING but I'm not familiar with this.  The ideal thing would be to have the router act as a host and send it to all network connected devices in my home.  Is this possible? Thanks
0

ACT

922

Solutions

921

Contributors

Act! (previously known as Sage ACT!) is a customer relationship management (CRM) software application which is used to keep track of client and prospect details in a single database that can be shared by multiple users. Act! features include contact, company and opportunity management, a calendar, communication tools, the ability to track prospective customers, "dashboards", reports, and the ability to synchronize data from other applications or other Act! users over the web.

Top Experts In
ACT
<
Monthly
>