Recent content by Kingz

  1. K

    Using continuous forms instead of creating controls:)

    Hi guys. First of all, thanks to MajP, isladogs, pat Hartmann, GPGeorge, Arnelgp , and anyone I might have forgotten for the discussion on not misusing ms Access by creating controls dynamically, and for the advice and discussion on the topic. It was merely out of laziness that I didn't want...
  2. K

    Solved linking text box with after_update procedure using VBA.

    Ok, I'm starting to see understand your points of view. I've just read up on con Ok, I'm starting to see understand your points of view. I've just read up on continuous forms.. This could indeed be a clean solution to my task. I think I'll make a new thread to discuss a bit more thoroughly...
  3. K

    Solved linking text box with after_update procedure using VBA.

    I got it.. It's ctl.afterupdate = "[Event Procedure]" Thanks!
  4. K

    Solved linking text box with after_update procedure using VBA.

    We did need it.. The application is nearly finished now, it just needs one or two added functionalities like this one. To briefly explain the reasoning: imagine you have 5 different rooms, say and each room has 20 different components which could be filled by text boxes or combo boxes. Now the...
  5. K

    Solved linking text box with after_update procedure using VBA.

    Please! That's why I write my " by the way" at the end. I hear you
  6. K

    Solved linking text box with after_update procedure using VBA.

    Yeah, I tried that, but I got an error.. Run-time error 438 Object doesn't support this property or method
  7. K

    Solved linking text box with after_update procedure using VBA.

    Hi, I've got a form where I dynamically create a text field using Set ctl= CreateControl(...,acTextbox,...) Now, in the form, I have written an after update function, which I need to be linked somehow to the created control. How do I do that with VBA. I know normally, one would go on the text...
  8. K

    Solved Large cte problems

    Thanks guys! #3 did the trick.
  9. K

    Solved Large cte problems

    Thanks for the prompt reply and solution, but there seems to be something missing after the declare function. There's a compiling error regarding the declare statement anyway.
  10. K

    Solved Large cte problems

    Hi, I'm reading in a long CTE SQL via text file, and replacing a few parameters via VBA-Code. When I try to look at the final SQL in the immediate window, I only get to see the bottom half of the statement. How can I see all of it?
  11. K

    Solved Schema setting for passthrough query

    Works! Thanks.. It was the latter.. Just the semicolon missing.
  12. K

    Solved Schema setting for passthrough query

    Hi, I thought if I have a passthrough query and the query is written without a schema, I could add.. SET SCHEMA "XXX" Before the query, but it doesn't work. I guess the syntax is DB2, and that I need the access syntax.. Any ideas anyone? Thanks in advance, Kingz
  13. K

    VBA - change column name function

    Silly me.. Currentdb.Tabledefs(table).fields(old_col_name).name = new_col_name Does it
  14. K

    VBA - change column name function

    Hi, I wrote this little function as part of an ETL procedure. It's simply to help me change column names in my access table, in VBA.. Public Sub change_col_name(TableName As String, OldColName As String, NewColName As String) Dim tblDef As TableDef Dim fldDef As Field Set...
  15. K

    Import csv to excel to access table

    Unfortunately not.. It's just too much..I think access finds it easier to assign an appropriate data type to a column when it's an excel file. What would help is to maybe remove the 12 lines before I convert it to excel.. does that seem feasible?
See more
Back
Top Bottom