Search results

I tried your suggestion, but what I don't understand is how the other controls can be "coupled" to the value in the combo box. So if I select a value from this box al the other value will change to what is stored in the record with this value. And when I change something it now just change to...

No it is run from an other form. Thank you, because you just pointed out a fault in my code. every line should refence to an other "ScoreEstValue". so 1, 2, 3 etc. So is this still possible with a select case statement? And how do you account for when the value is exactly 1, in my code it is...

I've looked it up. But I can only find it for editing the controls it self. My code is a calculation. For each check there is a value and when you check tis box you add this value to the total and then divide it by the number of checked boxes. And if you put it in an "for each" can you save it...

Is there a way to make the macro below shorter or leaner? Public Sub ScoreMacro() Dim Score As Single Dim Counter As Single Dim Total As Single Dim ProductWeeg As Single Dim DriveWeeg As Single Dim SWLWeeg As Single Dim BoomWeeg As Single Dim BridgeWeeg As Single Dim NrWeeg As Single Dim...

oke postes something but the solution was somewhere else

oke I messed around for a little and got the solution. and it works like a charm when you add more filters Here is the code: 'Filter Competitors Public Sub FilterMacro() Dim FilterString As String Dim ProductFilter As String Dim DriveFilter As String Dim FeaturesFilter As String Dim SWLFilter...

I'm sorry it does work, but still only when both filters are active. Do you know a way to make it work with 1 filter active. If you know what I mean? and when I add more filters you would get someting like this: FilterString = "(" & ProductFilter & ") And (" & DriveFilter & ")" And (" &...

I put in this: If Not DriveLen <= 0 Then DriveFilter = (Left$(DriveFilter, DriveLen)) & " AND " End If lngLen = Len(FilterString) - 5 Because when you do it your way it doesn't work when you don't put anything in the second filter. because it doesn't understand the AND. I could solve that en...

I think that needs some more explanation, because it doesn't work at all when I put it in. even when I delete the AND's and the part that gets rid of the extra AND at the end.

Thank you, it did what I hoped. I changed it a little as you can see below, because it doesn't work when you don't check a box in the drivetype category, because then it comes up with "ProductFilter AND". But this was solved in my code. But it brings up another problem. Now if you check...

The title is maybe a little vague. What I'm trying to do is creating a macro to filter data in a subform. But what I'm trying I can't find anywhere. First I want multiple filters on 1 field. So when there are multiple statements true I get all the records that meet the statements. This works...

So you gave been great with the help so far. Now I want to store the values I put in the form "Product Specs". I have a table "Product Specs" as well, where the data should be stored. If you look at this table then you see that its an exact match of all the data. But what I want is that you can...

Maybe an other idea is to change all the references in the macro to the data in the table. but I don't know how I can do that. So now I try to retrive the data out of alle the fields from the scores form, but all that data is stored in the scores table as well. but how can I call that in my code?

Thank you it works good. But this bring an other problem. I have this button "change scores", and when I pressed it then the scores form would open as a popup screen. but now this doesn't work anymore. Probably you can do someting simular to how you hide it, but I think when you close it again...

oke is there a work around? someting I can do in the code? if not how can it be open and hidden? because in the and I want a windownwithout ribbon and navigation pane.

So I was trying some settings in the Options>Current Database to restrict people from editing the database. But now it seems that part of the macro's don't work anymore. I put back all the settings but still have this problem. If you have a look at my database when you click the checkboxes on...

The anwser is no. But I think it had something to do with one another, because I tried some things after the crash. and that probebly created the problem with the slider. So I think when I put another slider in my form now it will work again.

I solved the problem. I don't know why, but the slider I put in the form caused the problem. I changed it for a textfield now, because that was better for more then one reason.

Thank you for the reply. I think that your method doesn't work for what I want, because there are more answers possible on one question. If you translate it to your idea. Do you know why you can't download? And maybe I'm wrong, because I don't understand what you mean with the datasheet view...

I made the following form and the strat of a table. The idea is that when a checkbox is checked that either the corresponding checkbox in the table is checked or I could copy the corresponding record to a new table. But in the end I want to cound all the scores and calculate the average of all...