Search results for query: *

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

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

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

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

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

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

Please help me with a version question. I am using CR9 Pro to design reports based on tables on a SQL server (ODBC connection). RAS is great for distributing simple reports, but drill-down takes forever on my complex reports. So I'm looking to buy a couple of low cost CR licenses for some of...

Apparently my CR9 doesn't recognize that I have enabled and started Microsoft IIS. Therefore it is not offering me the option to save reports to enterprise folders. It is working fine for another user. I'm running WinXP Professional. I installed CR9 Pro before I installed IIS. Next I...