Recent content by 65goatman

Thank you for the suggestion.... Unfortunately, that solution caused additional time by manually creating the from the Excel side. I tested that solution, but when I copied the cells from Access, it changed the format of the Excel column. This then added steps to go back and correct. Again, I...

Good day, Using Access, I break a raw data file into separate tables based on the value in a field, (Customer Name). I then export the table to Excel where I email the worksheets for the completion of fields that I added to the raw data file. I want to limit the responses that can be entered in...

Good day, I already tried to copy the whole DB to the local side, which didn't work. Goatman

Good day, We have an Access 2002 DB running on a server that is running the backend for our web page. I would like to export the table/query to my local PC where I can analyze the data within Access 2007. To connect to the data server, I must use a remote connection. When I first created an...

I am cleaning up old accounts/objects on several servers AD.. I have several Items Identified as user accounts, but do not show up as such.. What type of an object would be identified like this? S-1-5-21-1013083955-3031003544-1497960530-1309, S-1-5-21-1013083955-3031003544-1497960530-1286...

We use citrix Metaframe Program Neighborhood Version 9.230.50211 (128-bit SSl) to connect to multiple web based application servers. As a new connection is required, we must manually create each connection for each individual on the team. Is there a way to configure a single "master" and...

Hello, While cleaning up a user's e-mail accounts in outlook 2000, I deleted the old internet POP3 e-mail account and created a new account to the same off-site server. I was told that the messages were only test related. After all is working correctly, I am told that there was a couple of valid...

A while back, Crystal offered a free version of Crystal Info. I have lost my copy and would like to find a replacement copy so I can create a distribution list of reports for a class I am involved with. Can anyone direct me to a location where I might download the info program or a demo version...

I am reporting off of a btrieve table via ODBC, that has a field that is formatted as a 1-integer in the Btrieve table. When I report off of the field, I get the correct number, then two zeros, a decimel point and two more zeros in the Crystal report. When I import the field into Access, and...

Thanks, That seemed to do the trick for me....

I have a report that uses running totals based on a parameter field that looks at a formula field. These RTs are located in the group footers. If the RTs all have zeros, I do not want to display the individual group. How can I tell CR to suppress the group if all the RTs within the group equal...

I have created a series of Reports using three tables in an Access database. I have found that using links on over six fields seems to cause Crystal to shut down. I went into Access and combined two fields into a single field,(period+FY), and (Entity+Enterprise), on all three tables. Now I am...