Search results

I do not know how to do that???

This is excellent, but still I didn't finish the thing. I still have to write a big if statement because I need to know the order for the variables. Which one is the min, which one is the almost min, middle one, almost max, and max, The exact order.

yes, in the module of the form.

Hi all! I have 5 variables, and I would like to find the smallest of them and also I would like to found the largest and all the rest sorted by size. I read that the best way to determen that is with array function, but I dont know how? The if function for something like that is too long. Can...

Yes, I understand. My English is not so sophisticated so sometimes I confuse people. I want to make a button that will do next: when I hit it I want to open a popup window (same as "save as" window) to chose the path and the file name for the blank database. After I enter the name, and chose the...

Check the Allow additions on your form, it should be Yes. Also try to go to new record with record navigations.

It should be like the save as function so I can chose the path and the file name every time.:(

Hi All! Is there a solution for the next problem: I would like to create a button in access XP that will create a new blank database and after creating it to export all of my tables that are stored in my database that I am working in. I need it to make some kind of security button (archive) if...

Thankssssssssss!!!!! :):):):):) Hi All! Thanks for All the replays, it SOLVED my date problem!!!! So, IT WORKS!!! Thanks again! Best wishes to all!

still filter problem.... Thanks CyberLynx, I tried everything that you wrote to me but in the end the filter is working only for 01/01/2008 and for 22/02/2008, I do not know why!!! So here is the base of the problem so if you have a little time for checking it, I would be very happy and...

Almost OK! Thanks CyberLynx!!! I changed the code like you wrote me but it is working only for the date 01/01/2008, for other dates it is not working... I do not know why???:confused:

Hi All I had some problems with filters in access XP but with your help I solve it, but I have another problem with that now. Until now, I used the filter for text fields and number fields and it is working ok, but now I wont to use the filter in date field but it is not working, so, I need...

Thanks!!! I modified it a little AND IT IS WORKING !!!! This is the modification: filtika = filtika & " and [Sifra]= '" & Me!TextFiltera & "'" If Left(filtika, 5) = " and " Then filtika = Mid(filtika, 5) End If Me.filter = filtika Me.FilterOn = True Thanks DCrake :):):):):):):):):):)

Stillll Problem! Thanks DCrake.... I tried it, but it still do not work! Here is the base so if you could just check it for a moment..... Thankssssssss!!!!:):):):):)

still problem Thanks, but when I try with this code: Dim filtika as String If Me.FilterOn = True Then Me.Filter = Filtika Me.FilterOn = False Me.Filter = "[myfieldname] = '" & Me![mytextboxname] & "' And filtika" Me.FilterOn = True Else End If I get the pop up with the message "enter...

Hi All! Thanks again Bob! It really helped me. I wondered, if you could help me something connected to the last question. I created a form and one text box on it for the filter and a command button for the filter. Everything works great with filter but I would like to use the same text box to...

new treat? Anyway Bob, I do not know how to post a new treat.... I do not have that option.... Thanks! :)

question again! Thanks again Bob! It really helped me. I wondered, if you could help me something connected to the last question. I created a form and one text box on it for the filter and a command button for the filter. Everything works great with filter but I would like to use the same text...

BIg BIg thankssssss! This WORKS.... YUHUUUUUU! Thank you Bob for a quick and accurate answer..... Best Regards Bob....:):):):):):):D

Problem Hi All I have a little problem. I have in access 2002 two combo boxes and I would like to use them both to create a filter on that form, but it only works with one combo box. How to wright code for filter with two combo boxes as conditions?:confused: