ACT

949

Solutions

959

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

I am not new to ms access databases.  I have developed quite a few, but its been a long time since I have done this and need some help.  Maryland has a new Sick and Safe leave act where you have to give your part time employees one hour of leave for every 30 hours worked.  Right now, we are tracking this on a spreadsheet.  I wanted to make this easy on our HR lady and develop a db (my comfort zone) to track this.  I have a table of part time employees, not too many, maybe 10 employees.  I wanted to:

1 display the employees in a form.  I did this as a subform.
2. On the unbound main form I wanted to change the payroll date to the current payroll date by calendar picker
3.  After selecting the new date it would create a new record for ALL part time employees with the new pay date. and still list all employees.
so when she enters the hours worked she is only on one form updating each employees hours worked (similar to an excel spreadsheet) where all employees are listed on one page and she just tabs and enters the information.  

On the unbound main form.  Where you change the paydate, I wanted to create a new record in the subform for ALL employees.  Right now, It changes the date for the first employee but does not create a new record.  I want a new record for all employees with a new paydate.  I hope this makes sense.
0
Introducing Cloud Class® training courses
LVL 12
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

I am unable to access our Cisco ASA 5505 via ASDM because we don't know IP address. We were setting up the ASA to act as a DHCP server and made a mistake and changed the IP address. We have the credentials to access it via the ASDM but without the password it won't work. I've tried to access it using Putty but it's asking for a password we don't have.  Is there a way to figure out what IP it is set for?
0
I am working in Access 2010.  I have a main form with subform1 and subform2 (this is a continuous form) on subform1.  The problem is with the tab order of subform2.  There are only two fields  on the form.  They are phone, with an input mask, and phone type.  The tab order is correct and it should go to phone but the tab moves it from subform1 to the phone type field and completely bypasses the phone field.  The next tab takes you to the phone field.  This only happens on the first record.  Once the phone and type are filed in it advances to the second record's phone field first.

I set up forms like this a lot and have never seen it act this way.  Any ideas why this is happening?
0
My client lost email history and notes within his  Goldmine Premium Edition version 2017.1.0.422. I have image backups running. If I grab an earlier copy of the data base, he will lose data he has entered for the last 7 to 10 days (since he noticed the issue). Is it possible to just restore the missing email history/notes without having to resort to an older GB DB copy?
0
Hi
singleparentmeet.com is a really pitiful dating site. I want to unenroll, but their site is truly pathetic.
They don't have tech support and their help page requires 3rd party cookies.
Dating is a hotbed of scammers. Enabling 3rd party cookies doesn't appeal to me, especially from a crappy site that might have vultures, or Nigerians waiting for idiots to allow them access to info. Nigerian vultures!? How can I safely unenroll from this  site? Can I get VISA to read them the riot act? They will probably charge me soon, month end!

Thanks
0
Hi Experts

What is the Best Practice re IIS & RDS services?

We have 2 VMs on a HyperV: DC + RDS (both WIndows 2016)
Our CRM, ACT! from Sage,  is currently installed on the RDS but is only used internally.
We need to install a IIS / Web Server to give remote access to ACT! via the web

Can I use the RDS to install these additional components? My instinct is to build a new VM and install ACT! on that VM.

What says you?

Alex
0
Hi - We are running a terminal services/Citrix server 2016 with about 25 users, and use the CRM software ACT version 20 (latest). When we launch ACT, after about 10 seconds, we get the error "The requested performance counter is not a custom counter, it has to be initialized as read only"  (pcerror.png - attached) . Of course, this being a terminal services/Citrix environment, happens for all users logging in and using the software. I've contacted ACT support, and they are claiming its a Windows problem. ACT Support did send me an article that has instructions on how to replace/reset the performance counters on the server, but it hasn't fixed the issue. Also, when the error occurs, there are about 6 or 7 miscellaneous events that show in the event viewer, which I've attached as well. I'm just not sure where this error is coming from, and any help with this would be greatly appreciated.
pcerror.png
perf1.png
perf2.png
perf3.png
perf4.png
perf5.png
perf6.png
0
Below mentioned script fine. I am trying to sort-object -descending the lastlogondate but output not getting as expected, getting output in  generic   .

Can any one assist to sort the lastlogondate in to – descending.

Thanks in advance


$DCs = 'DC01','DC02'

$ADObjects = @{}
ForEach ($DC in $DCs) {
	Write-Host "Processing logons at $($DC) ..."
	Get-ADComputer -Filter * -Property lastLogon -SearchBase "DC=test,DC=com" -Server $DC | ForEach-Object {
		If ($ADObjects.ContainsKey($_.SamAccountName)) {
			If ($ADObjects[$_.SamAccountName].LastLogon -lt $_.lastLogon) {
				$ADObjects[$_.SamAccountName].LastLogon = $_.lastLogon
				$ADObjects[$_.SamAccountName].LastLogonAt = $DC
			}
		} Else {
			$ADObjects.Add($_.SamAccountName, ($_ | Select-Object SamAccountName, Name, LastLogon, @{Name='LastLogonAt'; Expression={$DC}}))
		}
	}
}
$ADObjects.Values |
	Sort-Object Name, SamAccountName, @{Name='Last Logon Date'; Expression={If ($_.lastLogon) {[datetime]::FromFileTime($_.lastLogon)} Else {'None'}}}, LastLogonAt |
	Export-CSV C:\temp\LastLogonReport.csv -NoTypeInformation

Open in new window

0
Hi,

I just wanted to create a batch script which should act as a watch folder, whenever a pdf file is landed in a specific folder it should open automatically and if possible it should get delete on its own after 2 days exactly...

So whenever the new file is created it should open on its own to the viewer..

thanks in advance

Logesh S
0
I currently have an SBS2011 running domain1.com in native mode (i.e. mx records domain1.com->public IP, ptr -> domain1.com) and I have another two domains which I've added as authoritive domains and use SBS POP3 connector to get email for them.

Lately one of the domains has been losing email and I want to make it native with the current host as a backup using mx records. To do this I've thought of the following:

1. mx records domain2.com -> public IP priority 0
    mx records domain2.com -> current host priority 100
2. Change current host to act as backup in case public IP goes down and forward email to it once it comes back up.
3. Make PTR changes.

Now my main issues are 2 and 3. Will I need to use cpanel to create the exchange email accounts in the current host or will it keep the email in a general store and send them to the correct recipients once the public IP comes back on. And will I need to make any changes to PTR? Some say yes others just say that I need to make changes to the SPF to allow sending from public IP. Will multiple PTR pointing to one public IP mess things up?
0
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Few days ago users start to complain that nobody can connect to the database located on the server.
So I start with the basics.
Verify that all the Act and SQL services are start it on both the client and the server. Make sure the Act sync is running on the server.
I reboot both server and client machine.
I move the database from the server on the local client machine to test it locally.
I even install Act on the server where the database reside. I also restore the Database from backup like few days before all this happens. Still the same error no matter from where I try to run it.
act
0
Hi Experts, I'm not able to  get Act to work on my new server Windows 2016. It’s version 16. The message is: “Unable to connect to the database. Please verify the Act17 SQL instance is running.”

It's working on my old server which is still online. I'd like to get some help on resolving this. I have the database in the old server too invade I need to do something their or invade i didn't back it up correctly please advise on how to.
0
I am migrating away from Act! after years of frustration, but I find that the export function within the program is not great as relates to my ability to "carry along" my document attachments to contacts, histories, opportunities, and the like.

Is there a software program that will allow me to export these documents, hopefully whilst still attached/linked to the original item (contact, opportunity, history, etc.)

Many thanks in advance!
0
Hi experts, I have a client looking to move to RDS on premise or azure solution. This is because they are taking more and more remote workers on. Currently they have domain controller with ACT on it. Server 2008.
“ACT. The database sits on there DC server at present. Related to this is how Microsoft Query will work extracting data from the ACT database. If we move ACT onto RDS server (either on premise or Azure) and add Office 365 Pro so they can use remotely.
There are some custom reports in excel which use Microsoft query to look up on the ACT database directly and return the information to excel when we refresh the report in excel. First question is: does office 365 still offer this functionality (or the Microsoft query add on)?
Second Question: if query works with office 365 will it work if the ACT database is housed on the Azure cloud

there are about 13 users.
cheers for advance

Third Question: if all is set up here will the remote working setup still be able to use query with logging on remotely?
0
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
0
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
0
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.
0
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.
1
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.
0
Cloud Class® Course: Microsoft Windows 7 Basic
LVL 12
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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.
0
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.
0
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
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

ACT

949

Solutions

959

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
>