Search results

Hi all I have many forms and modules in VBA code. My code usually has a line in comment mode like 'On Error GoTo ErrorHandler thus, this error handler is temporary disabled during the code development. Now, I want to replace above line by using a compiler switch such as #If DEVMODE Then #Else...

The fresh FE gives no clue to indentify the user opening FE... that is the point, sir

Not so clear what you mean, but the case is user selecting "remember me" on login form for the 1st login, next time they will not need to type username & password again. This looks impossible if a fresh new FE is downloaded from server...

Hi Isladogs, Same FE file is downloaded from server to local (user's) computer everytime user start the application, thus how and where to store these login data?

Kind of lazy to handle an extra text file, many thing can be happened with that file which is outside of Access db

Hi Pat, I distribute same FE to 2 different teams: R&D and purchasing team. They have to login in with given username & password, this login form has "remember me" feature which is store on local table. If the FE is downloaded from server everytime user clicking on the shortcut, then"remember...

Changing BE extension looks great trick. btw: How do you hide tables in BE? If someone has BE PWD, will he be still able to access BE hiden tables? Thanks,

Hide Navigation menu, Hile acToolbarNo, Disable SHIFT key. Anything else, PAT?

Dear all. I have structure (type) in VBA and an array Private Type Item_property Itemname As String ItemMaterial As String End Type Dim ItemArray() As Item_property And I expect to init ItemArray like: ItemArray = { ("Knife", "Steel"); ("Ruler", "Plastic"); ("Ring", "Gold")} but It...

Ah... not every keystroke make data change, ex arrow keys. So the change event is the best to use

I just realized it, yes, it does search when paste data by mouse.

Hi @MajP I have applied your code to my application, it works and help to avoid the error 2185. However, I would prefer a blank window on my subform if filter returns no record. So in my case, i found a solution that is moving the searchbox to parent form and apply filter like...

Hi @arnelgp About event change remarks in microsoft site: Examples of this event include entering a character directly in the text box or combo box or changing the control's Text property setting by using a macro or Visual Basic. I think, i am getting risk if inside event change, i set value...

Again, the story is the BE's password can be retrieved by opening FE with text editor such notepad. I am not sure if new access (A365) can resolve this weakness. Anyway, Ms Access is not intended for high security application/program i think. btw: When sharing BE folder on network, we normally...

Hi Sr, Take a look at attached photo in #1, in the immediately window, the textbox is already has focus, but .Text is still not accessible. That's strange

Good addressing, I keep watching and curious to know the root cause too. Some time, my subform can paint the form without record, sometime it is totally blank, hope to know about them more clearly

I meant your code in other thread, they can solve the issue https://www.access-programmers.co.uk/forums/threads/help-with-dynamic-search-on-form-with-read-only-recordset.320126/page-2#post-1792689

Dear MajP Yes, it seem almost my case, my program has exact symptom of that topic. as @arnelgp suggested, I also tried on change event but it is same. The most strange behaviour is that the textbox is already got focus, but vba code insists asking for the focus to access .Text or .SelStart...

No, it stops at the yellow line of Txt_FnameFilter.SelStart while it goes through Txt_FnameFilter.Text without any error. But when i type ?Txt_FnameFilter.Text in immediately window the error also occurs.

Dear all I have an unbound textbox names: Txt_FnameFilter, it functions a search for each character keyed in via function: User_FnameFilterParameter (Txt_FnameFilter.text) This error occurs when no search result found. I have read about Error 2185, i understand that I can not access...