Microsoft >>BUG<< in app.LoadFromText acModule,...

[PACALA_BA]

Microsoft BUG in app.LoadFromText acModule,...
Hi, This is an FULL-ACCESS-2003-line:
Dim lc_KNR_TAB_FA$, LN_BBA_SER&, ll_POC_MAN_DTM As Boolean, ln_FLT_IMX As
eIII_IMX_GRP_Enum, lc_cur_TR$, lcSftRJ$, lc_FLD_CDF$, lc_FLD_FRB$,
lc_FLD_MR$, lc_FLD_ZTP$, lc_FLD_W_NAS_S$, lc_FLD_W_VYP_S$, strFROM_EXE$,
strWHERE_EXE$, lc_VERS$, strSUBQRY_EXE$, lc_KNR_TAB_BWM$, lc_KNR_TAB_AP$,
lc_KNR_TAB_SJ$, lc_cur_SJ$, strWHERE_B$, strWHERE_DTM_1$, strWHERE_DTM_2$,
strWHERE_FFFK$, ll_Analyze As Boolean, ll_TRM_SER_ALL As Boolean,
ll_Analyze_CUR As Boolean, strWHERE_MR$, strWHERE_FRB$, strWHERE_OLD$,
strWHERE_NEW$, strWHERE_BRW_FLT$, ll_make_color_MR_INI As Boolean,
ll_make_color_FRBVYB_INI As Boolean, lc_TMP_FLT$, I_MAX_ATR_INI&,
i_Rows_TAB_CUR&, ll_BrowseTable As Boolean, ll_DEL_TAB_OUT As Boolean,
lc_MATCH_NO$, ll_MATCH As Boolean, ll_DISK_FULL As Boolean, ln_free_DBC As
eDBCounterEnum, ln_TT_TYPE As eTTTW_KUS_Enum, ll_TR_ZTP_MAX As Boolean,
ll_KUS_KBX As Boolean, ll_KUS_KTX As Boolean, lc_CUR_SER$, ll_TGNCurSer As
Boolean, la_KnrFldZTP As Variant, lc_BrwFlt_INI$, ll_BrwFlt_SET As Boolean,
ll_SHW_OUT As Boolean
app.LoadFromText acModule, Name, FileName
Two times TRY, two times the same Error.....
The last 'n' is cut and paste to the new line !!!
************************************
I had Reloaded my Large-program-database to TXT, and than back.
I works MORE-better, but there are ALLWAS CRASHES !!!
There must be something WRONG else.

(e-mail address removed)


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-99a3-ee6b87c78cd4&dg=microsoft.public.access

 

[Larry Linson]

Jan,

You make no friends here by screaming BUG, BUG over and over; and you do not
inspire the _volunteers_ here to expend time and effort trying to educate
you in the basics of programming and Access. A consistent style is helpful
(for example implied data types mixed with declared datatypes are not
consistent), reasonable formatting of your code is helpful (as has already
been pointed out), and, in regards to your claims of "BUG", most of what
you've posted can be explained as "PEBCAK" (Google is your friend if you
have trouble interpreting PEBCAK). I'd suggest you speak to your employer
about funding some classes or books on VBA programming, and Access (for the
version you are using).

"Crashes" is completely non-explanatory as to what has happened.

And, by the way, it appears you have chosen some wrong option in the online
interface, because there is no suggestion for Microsoft in your post,
despite the footer of your message. If you disagree, please point out what
you are _suggesting_.

Larry Linson
Microsoft Office Access MVO

 

[PACALA_BA]

Hi, thank for answer
when code is limited to 1024 characters
why it is enabled in editor,
to write code-line with more then 1024 char ?
My opinion is the limit must be = 1024, and NOT more.
Bye

 

[PACALA_BA]

Hi, thank for Answer
Ok, my long DIM lines i can SHORTEN...
but my strSQL = strSQL1 & strSQL2 & "<SOME TEXT>" & strSQL3 & strSQL4
toshrten it also possible
---------------------------------------------------------
strSQL = strSQL1
strSQL = strSQL & strSQL1
strSQL = strSQL & strSQL2, and so on....