Search results for query: *

Thanks for responding Sorwen. the reasoning is mostly due to setting a combobox enabled property causes it to be almost unreadable especially by older computer users. this allows me to have the Forecolor still black. also there has been occasion to allow the user to peruse or view what the...

This is in reference to thread796-1499946. Using Kliot's code to add a readonly attribute to the Combobox works great (see code below). However being new to this I am trying to understand why the background color changes to grey when readonly and white when not. and How can I control this...

Do you have a DSN named Local Server. If not add one. depending on what operating system you are running this involves different steps. Let me know if you need more information.

Not to a complete satisfaction. I wound up using 3 adodc controls. in code when the user asks for new I ask what they want a new one of A project, A Quote, or A Quote Revision. then I add a record with the default data that is needed to each table. if the select Project I have to add a project...

Thank You for Your Response. I can not use any data Grids since I am to use only individual controls for each field. but I might be able to get the idea to work with ADO controls. Is there any where I can find out more information on shaped SQL statements? Morgan

I have been given the task of creating a form that looks "JUST LIKE" the Subform in Access. I am converting an Access database to SQL and VB. The Company wants the form to look just like the Access Form/Subform they have now. The subform is in the form of individual controls not a...

filter only seems to work if you have a Field your filtering on. I just want to say I want Record Number 345 and have a recordset of that. This is for a search by record on every field one record at a time. I think I have it figured out though. There might be a better or cleaner way to...

.filter only seems to work if you have a Field your filtering on. I just want to say I want Record Number 345 and have a recordset of that. This is for a search by record on every field one record at a time. I think I have it figured out though. There might be a better or cleaner way to do...

I have an ADO Recordset. I want another Recordset that will have only One Row in it that is the current row for the first Recordset. Can I do this with out requerying the database off of some value. I would prefer to just tell the new recordset which row in the old recordset I want it to have...

I am using an ADO recordset.find to move me through a recordset to what the user is looking for. I want to allow them to cancel the procedure if it takes to long or they notice that they selected the wrong field to search on or something. once the .find has been initiated though I can't seem to...

I have a vb app that allows you to log in to an SQL Server. I then want to use that same connection for my ADODC controls on my forms. When I use my ADODC controls though I find that for every ADODC control I have a Connection in SQL. Is there a way around this. below is my ADODC control Code...

Doug Why do you reset your RST3 recordset after having spent all the time to add data to that recordset in the first part and then reset it to a new recordset just to fill it again. should you use two different recordsets? Morgan

To: John Yingling I used your code sample and modified it to fit my code as follows. I still cannot stop the Find methode of the ADO Recordset once it is started to the SQL server. Is there a way of stopping it. Any help would be appreciated. Also I have found that even though I reference an...

Thank You for the Information on DOEVENTS. I was still wondering if for my particular application is there a better or alternative way to cancel the find once it has started. Morgan

Actually I haven't gotten the DOEVENTS working for a find on a Recordset. I was researching why when I ran across this thread that made mention that there might be a better way. I have seen a couple of threads in here that mention a possible alternative but no one has posted any code showing...

This message is for Jeff marler If you do not use DOEVENTS what do you use to allow a user to cancel say a find on a recordset with a find form. Morgan

Thanks Everyone I appreciate the help. RJ5 in the SQL Forum instructed me to use the LIKE keyword. I tried the % in different places and came up with mixed results. I don't know why yet but I think I can work around it. .find ("QuotationNO LIKE '%10881%'") Works fine .find...

Thanks RJ5 I tried the % in different places and came up with mixed results. I don't know why yet but I think I can work around it. .find ("QuotationNO LIKE '%10881%'") Works fine .find ("QuotationNO LIKE '10881%'") Works fine to find the number and anything behind the text...

I am trying to find the value "010881" I tried the % wildcard character in back and in front of my string with no luck. I know the value is in the database but the search goes completely through without finding it like it was looking for "%10881" not...

Thanks for your quick response. This uses a VBA style string search. I tried it with my recordset .find and it didn't work. Thanks for all your help though. Morgan