Recent content by dedjloco

It is centered automatically, but what I want is a very small button with a bigger + and then access thinks the + is to big for the button. but the problem is that the space around the + is to big. in a textbox you can change the margins but how do you do this in a command button.

So this is probably an easy one. I got a command button, with a + in it. now I want a small button with a big + in it. but when I do this the + is alligned to low. how can I change the space there is between the top and the + , so its alligned in the middle again?

If you could look into it it would be great. But I reviewed the application with some colleagues and got a lot of new ideas so a lot is going to change. And I will be put on another job next week so I think it will take a while before I will proceed with this.

I'm trying this later on so will update you when I have.

The difference is in the Not, so everything that is not that format will be rejected. what is the difference between StrConv and Ucase? and where should I put it because I tried this: [Project Nr] = UCase([Project Nr]) and this: Me.Project_Text = UCase(Me.Project_Text) But I found out this...

I have the following code wich is for entering new Project Nr's in an table, with the use of a combo box. Private Sub Project_Text_NotInList(NewData As String, Response As Integer) On Error GoTo Project_Text_NotInList_Err Dim intAnswer As Integer Dim strSQL As String...

Thank you very much. this works like a charm

oke that would be great. here it is:

Can you tell me how both of the options would work? And will they both work when you filter out records?

oke that worked pretty good. Now the only thing left from the original thread is when I selected a "Project Nr." to put the values I change in the correct recordset. I could make a procedure for that as well, but can't it be done differtly? Because It already works partially. Because it puts...

But if I put the table in the Dcount it always counts all the records and not the filtered ones, because the filter is on the subform.

This is what I made but it doesn't do anything. Private Sub Calc_Button_Click() Me.Nr_Text = DCount("[Manufacturer]", "Competitors_Subform") End Sub So this is in the click event of a button. and Nr_Text is to where the number should be written.

oke so where can I put this Dcount? this is also my last question. Because I found multiple topics in which they said that you can make a textbox in the subform footer and then put =Count(*) in the control source. and the you can refer to that textbox in the other textbox on the mainform. But...

Can you tell me what tis code does? Because I don't understand how I should integrate this in my program. and how this would solve that I want to assign different variables eachtime I call it.

So I have a Subform which is in datasheet view and it can be filtered trough controls in the main form. And I have a textbox in the main form in which I want show the number of records you see in the subform excluding duplicates. But I want to only put in number when the button "calculate" is...