Search results

  1. T

    Pass Combobox value to Function

    Hi, This should be pretty straightforward, but I do not seem to succeed. How do I pass the value of a combobox to a function? This is my current code: Function UpdateDealer(iDealer As Integer, oDealer As Integer) 'stuff End Function And this is the code behind the button: Private Sub...
    • Timoo
    • Thread
    • Replies: 1
    • Forum: Forms
  2. T

    SQL query loop

    Hi, Up to now I have to say this forum is The Best! Found só many solutions here, all in bits and pieces of code! Thanks you all, for posting here. Now, I have a small, little problem. I want to update columns in a table, 1 by 1 (12 months in a row). This is the code I use: UPDATE...
  3. T

    Replace, or Append if NOT exist

    Hi, I am building this database, importing several excel files from different customers. The excel files are standardized. Every month or so they give updates. Then it is up to the database to update the old tables with standard info coming from these excel files. Now I am looking for a way to...
  4. T

    Update table record with Excel info

    Hi, First of all I want to thank you all for being this forum. It helps me a great deal in my first steps into VBA. Right now I am looking for a way to update a record in a table with information, read from Excel, if the record already exists. If not, it is an append. How could I do this...
  5. T

    Cells to read Excel > Access

    *EDIT: see 3rd post for solution/solvation Hi, Right now I am building a database with items, coming from local dealers. We send them a locked excel sheet, which they feed with dealer information and item information. In the excel sheet, this is being separated (in the background) in 2...
  6. T

    Excel cell value into Access VBA variable

    Hi, Right now I am setting up a database to import 'random' Excel files, placed in a certain folder. These files are set up as follows: customer can fill in a certain table (unlocked cells in a locked sheet/workbook). second (invisible) sheet copies values from customer sheet, from row 1 to...
  7. T

    Repeated query to VBA

    Hi I'm totally new to VBA. And I think I will be needing it a lot, the next upcoming half a year. I know that I'm the kind of person only learning from experience. Therefore I turn myself to you, experts. So, first problem I walked into and I would like to solve through VBA: A query I...
  8. T

    Subtract Column Name as Var

    Hi, Could you help me out in this? I'm doing calculations; for every month I create a column (1 to 12) and this column is being populated with numbers, customer by customer. This is being done for YearFirst and YearLast. Next, I calculate the difference for every month and so I end up with 12...
  9. T

    Sequential Query

    HowTo Create a Sequential Query, in Loop? Hi, I've got a problem. I'm doing an update query on a table. 1 for every month. (...) Now I would like to use a counter, so I do not have to run 12 queries in a macro, but 1 query with dynamic field names. But I do not get the thing to work. Current...
  10. T

    Timoo @ Doosan Infracore

    Hi, New to the forum. Who am I? Timoo. I work for Doosan Infracore. Here I mainly do data analysis and some Access dbase building Where am I? Waterloo, Belgium Why am I? Because every day hanging out with the angels became boring after thousands of years in heaven
Top Bottom