Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. branch861

    VBA Code raises "Type Mismatch Error" HELP!!

    I have the following code behind an A97 form. It worked fine in A2k but I keep getting a "Type Mismatch Error" with the following code. I commented out most of the lines and I keep getting the same error. I also tried moving the code to the On Load Event...no change. After...
  2. branch861

    Low disk space error.

    I'm getting the following errors via Event Viewer. Can someone please shed light on the situation for me. This doesn't make sense. "Low disk space. C:\INETPUB\CATALOG.WCI is full. Free up at lease 6MB" The C: drive physically has 1.29 GB free (4GBtotal). Does this make sense...
  3. branch861

    Low Disk Space error!

    I'm getting the following errors via Event Viewer. Can someone please shed light on the situation for me. This doesn't make sense. "Low disk space. C:\INETPUB\CATALOG.WCI is full. Free up at lease 6MB" The C: drive physically has 1.29 GB free (4GBtotal). Does this make sense...
  4. branch861

    Using Data from a specific "AS OF" date possible?

    I had a thought and wanted your input. What if I imported the tables I needed and used Access to create the reports instead of copying the entire database. Doesn't that sound like a viable option. Please advise at your convenience.
  5. branch861

    Using Data from a specific "AS OF" date possible?

    <<You can copy the database as it stands on 3-31 to a new file >> I like this option. Sounds easiest and most straight forward for a novice. Right? <<Note you will probably need to do this at the end of each quarter>> No as a matter of fact it's only once a year. <<IF the data you need to...
  6. branch861

    Using Data from a specific &quot;AS OF&quot; date possible?

    <<how often do you have to pull reports? how many different reports do you have?>> This is a once/year type situation and there are numerous reports. I have completed and tested the report requests I've been given so far. And I plan to run those tomorrow. My concern is about the late report...
  7. branch861

    Using Data from a specific &quot;AS OF&quot; date possible?

    You're right! I would like to query data as if the data hadn't changed. I plan to run all of my reports tomorrow. But I know that there will be those folks coming to me after the fact wanting reports after the AS OF date has changed. They keep telling me that they want me to use the 3/31...
  8. branch861

    Using Data from a specific &quot;AS OF&quot; date possible?

    No. I would be soooo happy if it were that simple. The issue is that I have tables and within those tables within the database they all have the same ASOF_date. Every record would have the same ASOF_date. And this date changes everyday. Make sense? Thanks for taking the time to respond...
  9. branch861

    Using Data from a specific &quot;AS OF&quot; date possible?

    I'm a newbie...so bear with me...PLEASE! I have been asked to create a series of reports that utilize the 3/31 database. Our data within SQL server has AS OF dates. Which means that the data that is showing within SQL server right now is data from the previous day. So, therefore, tomorrow's...
  10. branch861

    Union query in CR8.5

    Thank you for your response. I figured this out yesterday morning and neglected to post that I no longer needed assistance. But I truly thank you for your response.
  11. branch861

    Union query in CR8.5

    I'm more familiar with Access and SQL Server. I'm very much a newbie regarding CReports. But I'm hoping you can help! I would like to combine results without linking to a query done in Access of SQL. Can you help with suggestions. Presently I have the results on the same report but one is a...
  12. branch861

    Please Help Crystal Novice with Formula!

    I figured out the solution. Thanks for being here though!
  13. branch861

    Please Help Crystal Novice with Formula!

    I presently have a crosstab that displays the months. But next to each month I would like for the next month to appear as well. Example of what I would like to see: Jan-03 Feb-03 Feb-03 Mar-03 Mar-03 Apr-03 Apr-03 May-03 etc. Does this make sense? Please help! Thanks so much! J.Branch

Part and Inventory Search

Back
Top