Search results

I have try on another PC, it didn't work. When I open database, the database window didn't appear. So, is it possible to reappear this window? Le

That what I did. When I try to import from the problem db, it seem nothing happen. Le

I have compact my Database, I'am not sure if I done right. Because the memory still at 49 Mo. I try to tranfere all my data, it didn't work. Thanks for taking care of my problem. Le

Access 2000

Thanks for your reply, but I see Compact but I didn't see Repair. Where should I go to find repair? Le

Hi, I don't know want I did, suddenly, all the forms,tables, and query in my database are gone. But when I go to the proprities of my database it still has 49 Mo. Any ideas to restore my database? Le

Thanks very much, what a great help!! Le :p

Yes, when I click on option1 which the name of the option1 is company1 and I want it appear on my independant field "Company1". Thanks for your reply, Le

Hi, How can I refering the name of the button function instead of the control value? I have created a independant field which the control source is : =[OptionFilter] This gives me the control value of the option button. What I want is the name of the button, example "Option1". Any ideas...

Thanks for your response, but the record which is zero, it doesn't appear anymore. Any ideas? Le

Yet, but when I count it, if is null it appear blank, so, this blank area can be replace by a zero? Le

Thanks, right now, I'am using the option filter. The problem is, several words doesn't write the same way, for example sometime the word like "show-up" or "show up". Here what I wrote : Me.subfrmAbstractSearch.Form.Filter = "Title like ""*" & _ "show-up" & "*" & "company" & "*"""...

No, for example company1 has 3 telephone numbers, company2 has 4 telephone numbers and company3 has zero telephone number. So, what I did, I build-up a query to count the telephone number filed which means company1 = 3, etc. But in Company3 = 0, the field is blank. Thanks, Le

Hi, I need some advices. I'am trying to design a form to search abstracts with predefined keywords. For example, a keyword likes blue flowers but maybe in the abstract or in the title but blue and flower don't stick together. Is it possible to search words in any where in a field? Thanks, Le

Hi, Is it possible to put a zero in a blank field? I have build a query which count records and some off them are zero but the field shows-up blank so, is it possible to replace this blank by a zero? Thanks, Le

Thanks, I have download the "nomouse" sample and I have problem with it. Here is the error message " error 53 and VBA332.dll. I have copy the VBA332.dll beside the nomouse apllication and it deosn't work. Want to do? Le

Thanks for your reply. If I use the following code : Private Sub Form_Load() Set clsMouseWheel = New MouseWheel.CMouseWheel Set clsMouseWheel.Form = Me clsMouseWheel.SubClassHookForm End Sub Private Sub Form_Close() clsMouseWheel.SubClassUnHookForm Set clsMouseWheel.Form = Nothing Set...

Hi, Is it possible to have a simple code which stop the scrolling mouse. I have search around in this forum and found a thread with an example named "nomouse". I'm a fright to use this code because thet seem complexe. Also, I'm in the end phase my design, I don't want to worse my database. So...

Hi, I have a table which one of my field has blank space. If I transfered this table to another Database, this table was replaced all the blank space by a square after the transfere. So, how can I avoid this situation? Thanks, Le

Thanks. So, if I don't put it, it would not affect my database? Le