Search results

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

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

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

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

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

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

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

Thanks guys! #3 did the trick.

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.

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?

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

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

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

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

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?

Well, it's just that the application from which I am getting the CSV file, adds some unnecessary information, and I am just wanting to make it easier for the user to integrate the data into access. Manually, I would first delete the 12 lines and save as xlsx, and when I then import, I would...

Hi, When I normally manually import a CSV file, I tend to convert it to xlsx first and then import, because I get no import errors this way. Now I'm trying to do this dynamically, and it works syntactically, but I want it to skip 12 lines and my delimiter is semicolon.. These two factors are...

Oh I see .I don't have that.. What does that look like? All I do in my code is set some variables in my query which I set as querydef.. My code assumes the user has an ODBC connection to the database for the pass through queries to work. In fact, I personally don't get the odbc error message...

Hi, I have a few Passthrough queries, which function via an odbc connection. With VBA, I have a form where I can update the queries using query Defs. What I've noticed, is that when I start the program fresh, it will give me an ODBC error, however, if I go to my queries and execute one by...

Oh wow.. That sounds great.. I'll try that outm.i need to look up a few things like "make table query"..I guess I can do that with code, ie VBA, too..