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: *

  • Users: tazardous
  • Order by date
  1. tazardous

    simplifying a complex SQL statement

    thanks to all who had a suggestion. Quite by accident I found a solution. My original query (never posted here) prompted the user to enter a first and second date. It worked fine and users entered dates like 02/02/2000 etc. But the new query ONLY works when you enter the dates like 02-02-2000...
  2. tazardous

    simplifying a complex SQL statement

    placing the # on the outside of the parameters as you suggest causes a syntax error on the following statement: SELECT tblvalvular.studycode, tblvalvular.testtype, CDate(LTrim(Right([esign],Len([tblvalvular].[esign])-(InStr(1,[tblvalvular].[esign],":"))))) AS EsignDate, tblvalvular.esign FROM...
  3. tazardous

    simplifying a complex SQL statement

    Nope, Cdate has no effect, still get the same error. the parameters are fine, same syntax was used on same query, but different field and things worked until I started parsing on this field. thanks though! taz
  4. tazardous

    simplifying a complex SQL statement

    I'll try what you suggest... was hesitant to do so before because it seemed it would only make the statement more complex and the general error message seemed to suggest making it simplier. Taz
  5. tazardous

    simplifying a complex SQL statement

    Oops, sorry, here it is: SELECT tblvalvular.studycode, tblvalvular.testtype, LTrim(Right([esign],Len([tblvalvular].[esign])-(InStr(1,[tblvalvular].[esign],":")))) AS EsignDate, tblvalvular.esign FROM tblvalvular WHERE (((tblvalvular.testtype)="FunctionalMR") AND...
  6. tazardous

    simplifying a complex SQL statement

    <DISCLAIMER: Yes, I did search the forum first on this topic.> I've built an expression that parses out the date portion of a text field (esign), the expression is named EsignDate in the query and the query runs fine, returning the date portion. (see expression below) EsignDate...
  7. tazardous

    including another field in a query

    After a very long day (it's 1 AM) I can't tell you how thankful I am for your solution. Yes, it works great. Thank you for taking the time to be helpful. Once again I am amazed at how willing others are to share their knowledge. Taz
  8. tazardous

    including another field in a query

    I've got a table that I want to extract a subset of data from. It contains three fields of importantance: leasekey : the foreign key that ties this table to a parent effectivedate : the data associated with a lease rate rateSF : the lease rate per square foot. What I want to do is query the...
  9. tazardous

    Hiding the 'Replace' Tab in the FindRecord dialog

    Hi, While researching the how do remove the REPLACE tab myself, I saw your question and the answer. To remove the replace tab, set the forms Allow Edits property to No. I suppose the next logical step would be to create a custom find, where programically you set allow edits to no, call the...
  10. tazardous

    combo box without arrow

    Thank you, thank you, thank you for taking the time to lay things out for me so well. Although I have not tried this, it certainly looks good and I have every reason to believe it will work. For all your hard work, you deserve a 'star'. taz
  11. tazardous

    combo box without arrow

    Hey AceMan1, could you provide the code for that event???? Earlier you said you were put it in the LOST FOCUS event for the listbox. So basically you have something like: wait 50 milliseconds me.listboxname.visible = false is it the delay what makes this work? Because just hiding the control...
  12. tazardous

    combo box without arrow

    Thanks Randy700, but that option, while valid, was discussed earliar in this tread and frankly would be a lot of coding (over 140 controls on this form - yes, I know, it's not pretty, but despite my efforts of persuasion, this is what the client wants), with over 20 controls that have to be...
  13. tazardous

    combo box without arrow

    Yes, exactly, the problem is that one can not hide a control that has the focus. Moving the focus to another, arbritrary control, would no doubt confuse the user, whose very action was to click on another control of their choosing. Now, if I could KNOWN what control they were clicking 'to', I...
  14. tazardous

    combo box without arrow

    ok, Thanks, yes that does work. But as you said, that's a lot of events to code.... Especially on the form I am working with. Not to mention I will have about 20 controls that 'could' have their listbox visible. I'll have to see if I can 'generize' it so that I can call a generic routine...
  15. tazardous

    combo box without arrow

    Hi, Actually, I changed it to a listbox already too. So the scenerio is the same. Again, I need to stress, the use of the listbox, and it's becoming visible and invisible when a selection is clicked, works fine. But, if the user decides AFTER the listbox is visible, to click away, onto some...
  16. tazardous

    combo box without arrow

    Thank you for the idea. It works to the customers satisfaction except for the case where they click on the textbox but decide NOT to click on one of the NOW visible selections. Rather they want to leave as is the values and click somewhere else. Since the textbox is still visible (no onclick...
  17. tazardous

    RunCommand acCmdFind

    Hi, I see that this is a rather old post, but I am having the same issue and was wondering what solution you found?
  18. tazardous

    combo box without arrow

    Hi everyone, I have a client, who would like the functionality of the combo box (dropdown list), but doesn't want the little right arrow image on the field. Is there a way to have the functionality and look (i.e. one 'line' of text displaying until entered) of a combo box, but without the arrow?
  19. tazardous

    filling a textbox from a collection of other boxes

    I've looked high and low and I apologize up front if someone's offered a solution already to my problem and I just missed it during searching these forums. My problem is that I need to collect the selections of several dropdown combo boxes in a form and put them into another field on the...
  20. tazardous

    How To Export an Access97 Report to a PDF FIle

    I had found some code here at tek-tips that worked very well with my access program and acrobat writer 5.0, but now that I've upgraded to adobe acrobat 6.0 professional it doesn't work. Has someone already conquered this problem who would be willing to give me a jump start on fixing this...

Part and Inventory Search

Back
Top