Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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