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!

Register Log in
  • Congratulations derfloh 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. ashishh

    How do I allow multiple users access to my db at the same time?

    Thanks LittleSmudge, Your answer helped my situation. I have just a basic Access DB which needs to be simultaneously by 3 users (add/modify/delete). It worked perfectly. Thanks, Ashish
  2. ashishh

    "File is in use" error message

    Hi, So how do you go about solving this problem? The lock file will be there and it can only be one. Any solutions? IN our case, it is on shared drive. 3 people have access to it and they want to use it simultaneously. Thanks, Ashish
  3. ashishh

    New user : Don't know how to bypass the "You are about to update"

    Thanks guys. It was very helpful. Appreciate all the help. Keep up the good work. Sorry about the delayed response from me. Ashish
  4. ashishh

    New user : Don't know how to bypass the "You are about to update"

    Hi all, Thanks for your patience. This might be a trivial question but I seem to be stuck on it, partly because I'm new to Access. I have this form in which I have a macro which updates another table based on some selection on this form. This macro is triggered on after update event. I get...
  5. ashishh

    Upgrading SQL Based Report stops working in Impromptu 7.1

    The problem has been solved. Apparently all we needed was curly braces {} for the entire query. Once we put it on, the report started working fine. Just wondering if anyone else ran into this problem or not. BTW, thanks for your response dennydm! Ashish
  6. ashishh

    Upgrading SQL Based Report stops working in Impromptu 7.1

    ...the report and catalog to 7.1.116.11, the report gives strange errors in prompt variables. Could someone please help. Attached is the exact SQL ******** select T2.SR_NO_TXT, T2.SR_CRTD_DT, T2.SR_STAT_NM, T3.PROD_NM, T2.SR_SUBJ_TXT, T2.SR_SUBJ_DETL_TXT, T2.SR_ABSTR_TXT,T2.SR_DESCN_TXT...
  7. ashishh

    Dynamic Sort

    Dave, Excellent suggestion. Wonderful workworund! I sincerely appreciate your contributions to this forum. Ashish
  8. ashishh

    Dynamic Sort

    Hi, First of all, thanks for your time. I have a situation where in I need to sort the columns based on the filter selection. If choice "A" is made then I want the detail records sorted by Column #3, else by Column #4. I have tried looking for anyway to specify dynamic sort order...
  9. ashishh

    Works for Signle choice not for multiple choice

    Thanks Dave for your reply. It did work. I appreciate your time and effort. Thanks, Ashish
  10. ashishh

    Works for Signle choice not for multiple choice

    I have the following situation. I have two prompts 1. Emp_Name - Pick Employee Name This list comes from picklist report 2. Emp_Type - Pick the Employee Type Choice are "Creater" or "Owner". It is typed in. My data is like the following Record Number...
  11. ashishh

    How to pass a prompt value from a report to a macro.

    I have the exact same situation. I am happy to see someone trying to do the same. I run into some problems with this. I have the following problem. I have a "Wrapper Report". This is the main report. I have a prompt defined here and a variable which gets the value from the prompt...
  12. ashishh

    Multiple Reports under one Report

    I am still struggling with trying to get all the sub-reports combine together as one PDF file. The Sub-report function does not really let you stack reports on top of each other. I do not know if I use macro to fire one report after another, will it open multiple windows? What I intend to do...
  13. ashishh

    Simple stored Proc in Macro

    Dave, Thanks a bunch for the detailed response. I appreciate it. Ashish
  14. ashishh

    Simple stored Proc in Macro

    Hi All, I am new to Impromptu and here is what I need to do. Before running a report, run an Oracle Stored Proc (which does not require any input or output parameters). I am trying to do this as a macro but do not know how do I go about doing this. I have read the threads which explain how...
  15. ashishh

    CLOB and Impromptu

    Hi Windjuly, Did you find a way to use CLOB fields in Impromptu? I have the exact problem. Could anyone please help. Thanks, Ashish
  16. ashishh

    Multiple Reports under one Report

    Thanks for the info. That is a good starting point. Ashish
  17. ashishh

    Multiple Reports under one Report

    I have a report package that I am building. This includes several reports which need to be printed one after another. Is there any easy way to create sub-reports which following one after another. I can always create these reports serparately but I would like all of these to be together in one...
  18. ashishh

    Comparison between Crystal Reports and Impromptu

    Thanks puppyquestion1 and Kaiaulad for your responses. Now that we have decided to go with Cognos, and I 've taken some training on Impromptu, I know a little more about Cognos. I agree with you guys that it is more feature rich. It is intended for a large user groups who are writing reports...
  19. ashishh

    Comparison between Crystal Reports and Impromptu

    Hi, I am evaluating the reporting software. I have only used Crystal Reports and I have no idea how Cognos Imporomptu works. We normally use J2EE environment for developing software and would use the reporting tool to generate reports on the web. Does someone have any comparisons available...
  20. ashishh

    How to specify Optional Criteria

    Thanks for the answer. There is another way I was told I could use and that is as following: ({?s_Compound}='' OR {TBL_COMPOUND.S_COMPOUND_NAME} = {?s_Compound}) and ({?s_Protocol}='' OR {TBL_PROTOCOL.S_PROTOCOL_NAME}= {?s_Protocol}) and ({?s_Country}='' OR {TBL_COUNTRY.S_COUNTRY_NAME}=...

Part and Inventory Search

Back
Top