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 Chriss Miller 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. dixie617

    Error with AuditTable Module

    I tried to debug the code by stepping through it, it stops right after it finds the PK of the record being modified. then gives me the error.
  2. dixie617

    Error with AuditTable Module

    it is not giving me the option with this error, not sure why. All it gives me is the 'OK' button. Thanks Dix
  3. dixie617

    Error with AuditTable Module

    Having some trouble on a module and cannot figure out why it won’t work, the error I am getting is, if you have a chance could you take a look and see what I did wrong, it has been a while since I played with VBA: The error: "Syntax error in query expression 'SELECT Issues.IssueID'. 3075"...
  4. dixie617

    Error 2046 The command or action 'AddFromOutlook' isn't available

    Thanks for the information MajP, that was not it though. I discovered that some of the ac commands will not function on a linked table, they will only work on a table actually stored within the database currently in use. I had to import the linked table to get this function to work correctly...
  5. dixie617

    Error 2046 The command or action 'AddFromOutlook' isn't available

    I have searched all over the internet and still have not figured out why once I split my database that the AddFromOutlook command will no longer work. All I have seen is that it has something to do with the linked tables. Any ideas??? Code: Private Sub cmdAddFromOutlook_Click()...
  6. dixie617

    Month Name on a Report

    Bob, That explained a lot thank you for the infomration I have saved it to my postings and archive so I will have it in the future. Dix
  7. dixie617

    Month Name on a Report

    Great thank you so much for your help
  8. dixie617

    Month Name on a Report

    This is pretty much what I was needing thanks, but, how do I make it last month, for example I am running a report for November and it is now December, then what happens when I run December's in January will it work? Thanks Dix
  9. dixie617

    Month Name on a Report

    Hello, I am trying to remember how to put the Month Name on a report using a text box formula, what I need is for the report to show at the top "Report for the Month of & (previous month's Name)" I know I need to use the MonthName function but after that I am lost, it has been a while since I...
  10. dixie617

    Invalid Date Search

    I did put the null tests first in the formula, I did not realize that those should be first. Ok, that makes since that they are still invalid dates, I did test them, they come up false. Thanks so much for all the help.
  11. dixie617

    Invalid Date Search

    Cool, got it to work, I just took out the first line, one more question I have a few that are like 1/1/2007, or 1/01/2007 which Crystal will read as a valid date correct? If so how do also illiminate those? Thanks Dix
  12. dixie617

    Invalid Date Search

    ...or not isnumeric(split({PROBLEM.APROXONSETDATE},"/")[3]) ) and {PERSON.PSTATUS} = "A" and Not ( ({PERSON.LASTNAME}) like "zz*") and {PROBLEM.CODE} like ["ICD-401*", "ICD-250*"] and isnull({PROBLEM.ONSETDATE}) and not (isnull({PROBLEM.APROXONSETDATE})) and isnull ({PROBLEM.STOPREASON} ) and...
  13. dixie617

    Invalid Date Search

    Hey LB, Sorry I did not get back to you on this, got stuck with a project that put everything on the back burner for a couple of months. Now I am back working on this little project with a bit of a twist. Working in a different table, I am still looking for a formula that can search for...
  14. dixie617

    Invalid Date Search

    There is another field that identifies what is supposed to be entered, but does not check for valid entry. Many moons ago, a few years now anyway, before the developing team got smart and set limits and formats on what could be entered, many were entered incorrectly. ObsValue is a string that...
  15. dixie617

    Invalid Date Search

    I am trying to find invalid dates entered into a field within our database. The field is called ObsValue, which can be anything, it is in a general table that houses all observations entered, from text, dates, numbers and so on. I have approximately 150 of these various terms that are entered...
  16. dixie617

    Minimum Function

    I think I understand, I did have two links from one table going to the same table. I am getting a warning: "More than one datasource or a stored procedure has been used in this report. Please make sure that no SQL Expression is added and no server-side group-by is performed.
  17. dixie617

    Minimum Function

    I forgot to add the SQL Query from the report, is it suppose to have more than one select statement now: SELECT "PERSON"."PATIENTID", "RPTOBS"."HDID", "RPTOBS"."OBSDATE", "PERSON"."PSTATUS", "RPTOBS"."OBSVALUE", "PERSON"."EXTERNALID", "PERSON"."DATEOFBIRTH", "PERSON"."PID"...
  18. dixie617

    Minimum Function

    LB, just figured out it worked but not, I am only getting about 30 records now where their should be a lot more
  19. dixie617

    Minimum Function

    It worked perfect thank you so much
  20. dixie617

    Minimum Function

    Thanks LB for all of the help, So if this works (which I will know shortly is currently running) I can then apply the same, matching the records selection to the other reports this applies to? Dix

Part and Inventory Search

Back
Top