Search results for query: *

Hi All, First of all Happy Holidays. We usually do this piece manually. I want to find out if it's possible to send a Greeting card (Outlook card) to all our clients using their email address that we have in our database. The goal will be to create a button in a form and once clicked on it'll...

Hi, I have a button to run 6 queries to get a final report. When I click on the button to run the queries it asks me for sql login ID and Password 6 times. How do i bypass it? thanks in advance

Hi, I am not sure how to do this. I have table1 with the following fields Table1 PlanID PlanName Assets Amount A ANN 1,500,000 Table2 Plan ID MinAssets MaxAssets Amount A 1,000,000 2,0000,000 10,000 A 2,000,000 3,000,000 5,000...

Hi, I have one ACT database. How do I distinguish clients of each sales person. In other words, if I have John, Tom and Bob entering clients cotnacts in ACT. I want to see all contact related to John, all contact related to Tom and same for Bob. Thanks in adavance.

Hi, i have a form with several tabs. The form is linked to a table. my question is: can one of the tabs be linked to a seperate table? thanks

Hi, i am trying to add two fields but the result is weird [Disbursements]+[Total Amount] i get 16$1,104.87 it should 16 + $1,104.87 = 1,120.87 Thanks in advance

Hi all, I have this formula: IIf([BP BILLED TO]="N/A",[Assests]=Null,Format([Assests],"Currency")) it gives me this result Assets $1,544,455.69 $2,587,001.12 I would like to show the numbers without the cents like this: Assets $1,544,455 $2,587,001 I tried properties but not available...

can you please tell me why this formula is not working: IIf([NAMECUST]="Carbro" And [Client Type]=2,Null,[Assests],IIf([NAMECUST]="CWR" AND [Client Type]=2, null,[Assests])) Thanks in advance

Hi, I made the below changes to a Blackberry to sync with our ACT Database. It seems to work but when we get back to it, the changes are not saved. Here is what I did: We need the blackberry Address book Wireless Synchronization to be off. On the Blackberry Address book ? Click Address Book...

Hi, I am trying to open a form from a switchboard and I get this error message: "MSACCESS exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being created." I restart the computer and it's fixed. but it keeps happening. Does anyone...

Hi, We have 4 department in our company and I would like to know if it's possible to create seperate department (Folders)in ACT. Each department holds its own contacts. Is this similar to creating groups? We do not want to create seperate database, we would like to store all contact in one...

Hi, I added a new field to my ACT Contact Detail and I do see it, but another user doesn't see the new field eventhough I saved it. I added the new field doing the following: Tools Design Layouts Contacts Field Why is it not showing on the other person's pc. Thanks in advance

Hi, I am new to ACT. I am trying to add new fields to the company details and contact detail tabs. Anyone out there knows how this can be done. Thanks advance

I updated a form in a database and now it's not opening. If I try to open it I get this error message: Microsoft office has encountered a problem and need to close. We are sorry... the information you might be working on maybe lost... and then it gives me a choice to send error report or don't...

Hi, I have this query that I export to an excel sheet. Everything works fine except 3 columns's format is not right. in the query they look like this: Column1 Colum2 Column3 $45.24 $779.93 $1,143.48 when I click on the number $45.24 it shows...

Hi, I am stuck... I am trying to get the first initial of the first name and the first letter of the last name (after the space) and combine them with :sh Here is what I did: Initials: IIf([Team Leader]="Michael Conaghan","MO:sh",Left([Team Leader],1) & "" & Mid([Team Leader],1,1) & ":" & "sh")...

Hi, I am sure you heard of this error before. I did a search but I could not come up with a solution. When I run this query on my pc it's fine, but when I try to run it on somebody else pc I get this error: Run time error '3085' undefined function 'Left in expression' I checked for any...

Hi, Customers1.[Account Exec], Customers1.[Life Exec], Customers1.[CHRD Exec], Customers1.[Pension Exec], Count(*) AS TheCount INTO 1 FROM Customers1 INNER JOIN Contacts ON Customers1.[Client key] = Contacts.[Client ID] GROUP BY Customers1.[Account Exec], Customers1.[Life Exec], Customers1.[CHRD...

Hi, can anyone tell me why this formula is not working. I get a blank column. Thanks Total Amount: IIf([BP BILLED TO]="PLAN ASSETS" And [QRT BILLED TO]="INVOICE" And [Morningstar Sentence after Total]=Null,nz([MaxOfMaxOfTotal Fee Amount])-nz([MaxOfQRTRLY FEE])-nz([Momingstar Clearfuture Per...

Hi, Is there a way to link data from ACT (ACT!Premium for workgroup by saga) to a blackberry? Thanks in advance