Recent content by conceal

Does nobody have a clue how to export the data that has failures in it??? Or is the only option to write the whole query procedure in VBA for every record??? Something like "If me.value = ... then ... else ... end if" ??? Thanks for your effort! Greetings, Maik

Hi, In Access I've linked an Excelsheet to the tables in Access. Through queries I update, append and delete records to ensure that the table has the latest data. When I execute the queries, I get several notifications. Some are of the kind that ask if I would like to proceed, some are a...

Hi Glenn, Thanks!!! This was what I've been searching for! Bye the way, I'm still programming that optimisation program to recude the number of calculation, but since I've to do that in my spare time, it goes slowly. I've got a bug somewhere. Nevertheless, I'll post it as soon as possible...

Hi Macropod, Sorry for my incomplete information. What I meant was: Someone else gave me this code: Function myDate(text As String) As Date time = Right(text, 5) withoutscore = Replace(text, "-", "") myDate = DateValue(withoutscore) + TimeValue(time) End Function The code...

Hi Macropod, Sadly I'm not that familiar with VBA that I understand what the macro does. I've tried to run it (even with the selection of the cells), but nothing happens. I've found out that the problem in the program I got from someone else has to do with the software I'm using. I'm using...

Hello, In Excel I've a column with all kinds of different dates. The format of the dates is 'Month day, year - time' (example: 'March 7, 2005 - 11:35'. The problem is that it's saved as text. I've copied these dates from a table form a website and can't edit it there. Since this will be a...

Hello, In my database I would like to make my own forms with my own design. In this design I've put several unbound comboxes and textboxes to type certain data in. When a form is filled in completely, there is a commandbutton which should make sure that all the data in the several comboboxes...

Hi Bong, I was programming and used your recommendation 'usedrange'. When I apply this on a table of 5 by 5 and execute the program everything goes fine. But, when I change the table to a table of 3 by 3 the usedrange still is 5 by 5. Is there something I'm missing here? Should I delete or...

Hello, Well, I've found that the solution for this problem might be 'The Hungarian algorithm'. I'm still studying what this algorithm is and if it's programmable in VBA Excel. When I succeed, I will post the code if someone would like this. Greetings, Maik

Hi SkipVought and Bong, Thanks for your answers, but if posted this question at two forums (also at the Microsoft Office forum) and there they made a good point... it would take YEARS to perform these calculations... I have to find an other model to find the optimal combination. Nevertheless I...

Hello, I would like to know how I could write data from a unbound textbox or a combobox to a table using VBA (for instance, a commandbutton). Is there an example which makes things clear to me? Thanks for your effort! Greetings, Maik

Hi Glenn, Yes, I'm searching for the permutations of 150 from 150, which means that the number of calculations that need to be preformed by Excel is equal to the factorial of 150 = 5.7134 times 10 to power 262 calculations... and of all of these, I want to find the best possible... Greetings...

Hello, The last week I've been programming on a Excel-file that should calculate the optimal combination of persons and locations. I've made a table with 5 rows and 5 coloms. In the cells is a score filled in what gives an indication of the knowlegde of the person on that location (considering...

Hello, The last week I've been programming on a Excel-file that should calculate the optimal combination of persons and locations. I've made a table with 5 rows and 5 coloms. In the cells is a score filled in what gives an indication of the knowlegde of the person on that location (considering...