Recent content by etseel

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