Search results

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?

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...

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...

So I created a code that is working on itself, but when I try to make it "parameterizable" so I can call it multiple times it doesn't. Here is the code: Public Sub CurrentRecordMacro(MyObject As Object, TableField As Object) Dim dbs As DAO.Database Dim rst As DAO.Recordset Set dbs = CurrentDb...

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...

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...

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...

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...

oke my Access crashed and now all the references in my macro's aren't recognized anymore. but they are still in my forms. any idea's?

Oke this should be pretty easy, but I'm search for hours now and haven't found the right solution jet. I have 3 checkboxes in a form and 3 records with checkboxes in a table. The table and the form are coupled. And you should be able to check multiple checkboxes. I just want the link the...