Search results for query: *

SkipVought - I think dates/times are a problem because all the users care about is the readability of the output document/application. The formatting is critical to giving the user the perception that they have the right information they need to make decisions from the data; even if they had...

I have a .csv file that is downloaded from a vendor on a daily basis, with multiple tables include on the same page, with varying lengths. I need to get at the data in one of the tables but I can't format the columns for the entire file, since there are multiple data columns of various types...

Bill, Thanks for the ideas. Clearly you're correct saying that the VBA module is more powerful than the macro. However it is also significantly more complex and since I'm not a programmer I find it much more difficult to program in VB in Access than say Excel, where you can at least record a...

I could use some help with a dcount criteria inside an Access Macro which I'm trying to use for a recordcount. I want a command to run if recordcount is greater than zero. I have a split database deployed on a network. The Back End contains all of my tables and sits on the server, and there...

Skip, That is absolutely fantastic - exactly what I was looking for! Thank you very much. This is great code, I've been looking for an easy way to do deletes like this for a couple years...

I have an excel spreadsheet that imports various information using a DDE link to another application. Fields sometimes error out, and these fields are evidenced by the presence of the pound sign "#" character. Sample errors are "#NA Fld", "#NA Calc", etc. I want my macro to delete every row...

I want people w/ 2000 and 97 to both be able to use the database, and record their info to a single set of tables, with 2 or more concurrent users. I am very concerned that a 2000 user would accidentally convert the 97 db into 2000; and I can't find a way to prevent conversion without modifying...

I would create 3 reports. The first would be a report on current occurences for each group 1 element. The next would be a report of the old/audit occurences for each group 1 element. Then place each of these as subreports linked to the master report on the group 1 element, sitting side by...

GMAN33, I recently bought a copy of Professor Millet's VisualCUT software, and I've become a big fan. It will not only save a crystal report into a single PDF, with a bookmark for each group name, but it can also "burst" into separate pdf document for each group element. Moreover, it can do...

SAD ENDING TO THIS STORY The good news: All of the subreports look great! All the shared variables pass wonderfully, and show the appropriate value for each sales person. The bad news: When I put all of the pieces together in the master report, several of the variables aren't passed because...

LB, YOU ARE THE ALL KNOWING ONE YET AGAIN! Thank you. Your solution worked great. Your posts have solved my problems on at least a dozen occasions, I am indebted. kcushing, I am not able to use a TopN on that particular subreport due to the fact that managers have asked for a great deal of...

This is a very common problem, particularly aggrivating when new to Crystal. If I understand correctly, you have some summary functions at the group level, and you want a grand total for them at the end of your report, but Crystal doesn't allow summary functions on group level summary totals...

I know I'm doing something dumb here, someone please help me. Using CR9 pro, SQL database. I have a main report for my sales people (group level 1) where I want to display their Ranking in terms of YTD sales. For several reasons, I can't re-order my main report by their YTD sales volumes, and...

TopN won't suffice in this case since the managers want the report in alphabetical order. Also this is actually a subreport within another main report, and I can't change the order of the data or it won't match the order in all the other pieces of the master report. By the way I noticed that...

I saw a new window in the formula editor, and I want it to make it reappear. I had placed a formula into the report on my preview window. Apparently the formula had an error, and the formula editor opened up automatically when I tried to switch groups to view the preview for another group 1...

Can anyone help me here? Thanks for any help you can give!!! I am using CR9 Pro, hitting a SQL database with a single table that has all of the sales data over a period of years. I have a single grouping by salesperson (FA). I have a running total formula in the group1 footer that totals the...

synapsevampire - your test confirmed the formula was having trouble choosing the correct value, and suggested it was from the data elements, rather than the formula itself- which turned out to be the case. lbass - So I looked at your suggestion and decided to try and handle the effects of a...

Can anyone help me troubleshoot a problem I'm seeing with an array calculation? I'm using CR9 PRO hitting an Access Database and looking at 4 time fields. All formulas are evaluated at the Details level. I have 3 equations that calculate the time gap between the bench mark AO Time field which...

Mike, That was excellent advice. I checked out Millet Software and ended up solving 2 of my problems! The DataLink Viewer application was exactly what we were looking for. My thanks to you and to IdoMillet! ES

Rookie question here: Can anyone explain why the Database Expert seems to duplicate the tables in the new connection list when I connect to my xls file using DAO Access/Excel? E.g. I'm trying to connect to //.../accounts.xls with a single spreadsheet called "Client List". Once I connect to...