Search results

I would like to thank you all for the information about the use of wildcards on strings, dates and number fields whe running the queries. I feel it is very important to know why one should NOT DO something as much as knowing one should DO and you always provide both. :) Regards,

Thanks for the explanation, Colin! I will start working on the Form/SubForm iterations tomorrow, if I need any help I will get back to you, but I hope I will be able to start fishing myself... ;)

Thanks a lot, Colin! I have tested and the error 2107 is triggered on the second record I pick from the combo box. First one is fine, but the second brings this: Private Sub txtFindCard_AfterUpdate() If Not IsNull(Me.txtFindCard) And IsNumeric(Me.txtFindCard) = True Then Dim...

I see what you mean, Colin. Indeed that would be faster to find matching numbers. I will look for tutorial on how to do it.:) Thanks for the feedback! EDIT: I found this tutorial from Allen Browne, is that what you mean? http://allenbrowne.com/ser-03.html EDIT 2: Actually this sounds much...

But do you know if someone has ever done a “dos and don’ts” for forms? The bishop’ YouTube series is saved on my reference notebook, that form was based on one of his tutorials.

Colin, I am travelling now and I will take a look at the file you uploaded when I get at home. Thanks for the feedback and if you have a good tutorial on forms design I will appreciate if you could refer to me. Regards,

Hi, :( I spent my entire day trying to sort this out but I am giving up and asking for help::banghead: I have a small form that will load with all controls locked, except one that the user can enter information to search for a record. The code will change the RecordSource of the form to a...

I have followed you and gasman´s suggestions and it works, unfortunately that´s was not the source of the problem I was having. I can´t make the reset button to work... but I will post that on another thread because this one is another subject. Thanks guys.

The reason I want to lock them all is to prevent the user from creating a unwanted record on the table if he clicks on the controls before running a search... I thought I have just managed that with this: Private blnGood As Boolean 'This is used to prevent the form to saving the record...

Given the number of controls I guess you are right, but I will add it to my reference notebook for sure!:) Unless I did not understand your approach of the property sheet - I am sorry in advance: I need to unlock it when the user will input the feedback information. The events will be: On...

Hello, The_Doc_Man! I wonder how you and the rest of the heavyweights here get information like this... :eek: In fact I wonder how you guys reached such a high level on this. It´s amazing how all of you have answers and insights for all my questions.:eek::eek: It´s funny that when I run...

I am not sure how to use this, Colin... :o I have to tag a control with "L" if I want it to be locked when I call this function? But what do I have to do if I wanted them to be unlocked? I am sorry but I facing a real nightmare on a form and I think I am not thinking straight anymore...:(

Is this looping through all controls? In that case I will create a new case for the txtCardFind control?

Resourcefull as always! :eek:

Just one control should remain usable... I have attached the screenshot, the only unlocked control should be the one beside ENTER CARD NUMBER".

It´s not working...

My dear Colin, I wonder if there is something you don´t know about Access and VBA... :rolleyes: I downloaded the file!

Thanks a lot! I have been trying to figure this out for a couple of minutes!:D

Hey Guys! I am building my forms and as I am compulsive about colors I have found two interesting websites for finding the HEX and RGB codes. If anybody is interested: http://www.tayloredmktg.com/rgb/ https://htmlcolorcodes.com/

I was not aware of that perfomance issue, at least the field I am using is indexed. On a second thought, As per the owner explained to me indeed there is no point in using wildcards on this particular form because it needs to return only exact match so I will use the "=" operator and remove...