Search results

yes I agree. Thanks rainlover.

Hi to all ! I have my code to disable and enable the close button of ms access window, not the close button of its forms or reports. And it is working. Now I would also want to know how to disable the maximize, minimize button and help menu of ms access. PS. As I can see in the code, it...

thank you very much for the replies rainlover and simon_mt. Probably I would use a function to format a date. I was thinking before to alter the shortdate format through registry entries. but yes maybe it is better to use the function instead. thanks again.

hi, how can i programatically change the regional setting for short date and time format?

I see. you have added ".text" in my query criteria... what is that for? I am not familiar with that sir. may I ask it from you what is that for?

ok thank you very much sir. i can see that it is working. but may i ask what did you do sir because I have also tried the coding without me.refresh but it did not work?

khawar thanks for your reply. but I cannot seem to open the file because it is not an access file inside the zip file. how can i open it?

i want to input my text to search in the textbox and everytime i input a letter, the subform should suppose to be updated. yes it is updated but the word that i input in the textbox does not appear as a whole word but only single letter as i type.

this is my db that i work on figuring out how to work on my prob.

ok. now i see that OnChange event is really right but it does not immediately update my record. I have to use me.refresh my main form first before an update in the subform is done. how do you find that situation?

thanks for the reply JANR but I tried OnChange as you suggested but it did not work. do you have other idea.

thank you very much MStef. anyway can you also tell me on what event procedure should I use that when I input every letter that I want to search, my subform will requery or get updated. thanks.

Hi, I just could not figure it out. I am using this criteria in a query below" Like "Forms!Form1!Text0*" is that correct format? I dont know if that is correct because there is no result when I run the query. I am using in my search form. Moreover, what event procedure should I use so that...

I really appreciate the replies. but bytemyzer, what is the end-user only have home edition operating system and cannot avail of XP pro as of the moment, would there any other way to set permission to the folder or any other way to secure the db file so as not to be deleted by any user?

ByteMyzer, may i know what operating system that sets the folder permission like that because I am only using windows xp home and when I go to the folder properties, only hidden and read only attributes are there!

I am not in a company, so I dont have any dept Sir. can you advice me instead!

1. how will I do permission on the shared folder? 2. yes I can make the file hidden but I think it can still be seen when the folder options is changed. How will I do it?

hi to all ! after I have shared the database over the network to be shared to users through shared folder, how do we protect now the database file itself from being deleted since the database file is seen from the shared folder. The act of deleting the database file maybe just mere error or...

and put that on current event

can you try this: dim picpath as string picpath=[frmSubCatch].Form![Image] [Image1].Picture = picpath