Search results

=> I did try the code and on qdf.Type = dbQMakeTable I get "Compile error: Can't assign to read-only property" => In my code, where it says error occurs in order to help identify the location of code snippet from original first post. But at actual compile time, it gets hung up at DoCmd.RunSQL...

Here is the overall code. The error occurs in Private Function MakeTbl(Cancel As Integer). Sorry, I will not be able to send any other information such as tables, queries, or forms.

This code is part of ad hoc query maker, where the user selects items from a form and the SQL code is then generated. The ad hoc query maker works fine, even with multiple users. The problem came when it was requested that the produced query have the rows numbered, kind of like Excel. I tried...

Hi, I have a question on string concatenation. Some code background info: In the form frmMainMenu, there is a text box that gets the computer name 'txtUserID'. I'm trying to create unique table names according to individual that runs the code. qryMaker is just a query. Here's the code: Dim...

Hi, I too have a question on concatenation. Some code background info: In the form frmMainMenu, there is a text box that gets the computer name 'txtUserID'. I'm trying to create unique table names according to individual that runs the code. qryMaker is just a query. Here's the code: Dim...