Search results for query: *

Thanks!

Is it possible to script the entries on a inputbox as you enter them? I am using a inputbox to get an access code form the user. But anyone could see what they enter in the Inputbox. I do not want to user a form to get this info. I thank you in advance for your time BJ

Is it possible to script the entries on a inputbox as you enter them? I am using a inputbox to get an access code form the user. But anyone could see what they enter in the Inputbox. I do not want to user a form to get this info. I thank you in advance for your time BJ

Hi JonFer, THank you for your reply. I tried your method. But I am not sure how to refer a text box on a form as PArameter value. My form reference look like this: Forms![Ticket]![ChkDate] I inserted this in Query Parameters and Data Type as Date/Time I also insert this on the criteria field...

Hello All, I am trying to create a crosstab query to put on a SUB-form which will display a schedule ('Time' as Row, 'Name' as Column, and Contact as Value. I also has a "date' field which I inted to set criteria. It works fine if i type in a date and run the query. But I would like the...

Hello, I am a Access DB and VB programmer and looking for contract work. Is there anyone here who would be willing to give some advice, direction as to where to go to find such work? I am looking to work from home as I am retired now. Thank you so much in advance for your comments. BJ

Hi all! How do you run a query based on items selected on a form? I like to be able to have the option to select or leave blank (Text boxes, Combo boxes etc.) depending on the filtering I like to perform. I have used control names in criteria fields of my query. But if I leave any field on the...

Hi all! How do you run a query based on items selected on a form? I like to be able to have the option to select or leave blank (Text boxes, Combo boxes etc.) depending on the filtering I like to perform. I have used control names in criteria fields of my query. But if I leave any field on the...

Thanks TrojanRabbit! I was so cought up in doing it through code, just overlooked the simplest way. It's working fine now, I assigned the criteria in the Query itself. bj

I was hoping to do it through code, but I will try this way. Thanks a lot!! Bjay

Hi All, I want to use a Form to get parameter values (criteria’s) from the user for a Query, and then use these values to open a Report, which has its ‘recordsource’ set to the earlier mentioned query. Could anyone help me? I want to do it through VB code. Thank you in advance for your help. Bjay

Hi All, I want to use a Form to get parameter values (criteria’s) from the user for a Query, and then use these values to open a Report, which has its ‘recordsource’ set to the earlier mentioned query. Could anyone help me? I want to do it through VB code. Thank you in advance for your help...

Hi All, How do I filter data on a subform by using a macro? I have a form named "Directory" and within that a subform named, "Advisors". I want to filter the 'City' field, for an example. I have created a macro (Where Condition: [Forms]![Directory]![Advisors].[Form]![City]...

Thank you petrosky! I got it to work the way you descibed. Excellent!!!! Jay :-)

Hello all, How do I get a image control on a form to display the photo of each client from a table. I have created a field in the table which has a hyperlink to the image for each client. But I can't get it to display on the form as I browse through the records. I have tried an image control...

Thank you for 'ChrisBelzona' and 'braindead2' for the quick responce. I did try both and they work fine. But I decide to use 'Select case' method as 'ChrisBelzona' suggested. bjayhome

I have a subform and 5 option buttons on a main form. What I would like to do is to change the form shown on the subform to a different one each time a different option button is clicked. (I have also created 5 forms that I would like to see appear on the subform on my main form.) Can someone...