Recent content by jpro

Thanks pmsawyer, I didn't try the global variable (mostly because I am new to these). I will give that a try. Great minds discuss "Ideas" Average minds discuss "Events" Below Average minds discuss "People

I am fairly new to creating variables and having trouble calculating a sum on these because Crystal doesn't let me use the standard Summary tool in this case. Looking to find a way to create a final Sum based on my 3rd formula below that I don't know how to create. Crystal doesn't let me make a...

Hoping someone can help on a dual pass parameter question with Crystal Reports 8.5. I have a table in our report that contains Ship to locations that is not linked into any of the data in the rest of the tables. What I am trying to do is first have the user select a customer name from this...

Found an article to solve the issue: You may receive a "Cannot group on fields selected with '*'" error message when you run a query in Access SYMPTOMS When you run a query in a Microsoft Access database that uses one of the aggregate (totals) functions such as the Sum() aggregate function...

We have one user that gets all records returned from a table everytime a query is run even though there is specific values or even No values at all selected. We have completely uninstalled Access and reinstalled and there is no difference. Other users can query against this same db without...

Our environment has 10 Cisco aironet 1200 devices all using the same WEP keys and SSID. When a client is roaming through the building with their laptops and move out of range of one AP they drop their network connection then reconnect to the next closest AP. When we installed the APs, we made...

Yes, all check boxes are unchecked in the startup options. Great minds discuss "Ideas" Average minds discuss "Events" Below Average minds discuss "People

I am trying to hide everything relating to MSAccess besides the forms\reports that the user is using. I have gone into startup and set the form I want the users to use in the display field and removed all check box items completely. When the database is opened the main form opens as I want it...

Thanks mrdenny! I ran the chkdsk with the /v,/r &/f switches and everything went through on the restore the next time I ran it. Great minds discuss "Ideas" Average minds discuss "Events" Below Average minds discuss "People

I am restoring a database using a snapshot and during the restore process it gets to about 90% then errors out and stops. The log says - Operating system error 23(Data error(cyclic redundancy check).) I have since taken a new copy of the snapshot and tried again with the same issue. Anybody...

Apologies for my descriptions, but you are correct I am creating an export file in CR to use for the EDI import. I have tried the chr(10) alone and also tried the chr(10)+chr(13) with no luck. The file that I have created from CR works when I copy that character in from an existing file that...

In the menu bar, go to database,set location. This window will allow you to change the location of your source tables used in your report. Just point it to the locations of the second companies coresponding locations and save it as a new report.

I am trying to create a flat file to import as an 850INB EDI file. I have extracted all of the data needed through Crystal and have been able to create a character seperated flat file, however I am having a problem seperating out the header,detail, and release sections. I have tried to insert...

Outstanding!!! That is exactly what I needed. Thank you for your help.

I am trying to strip out the first 5 characters of a string, but cannot find the solution. Basically, I have a bunch of 30 character max strings that all start with a 5 digit code that I do not want to see. Example - "2549 Bulk Food Sales" Hoping to get "Bulk Food Sales" Any help would be...