Question VBA string bug? (1 Viewer)

[steeffie]

Google is your friend
http://support.microsoft.com/kb/945674

Hotfix did not solve issue.

Maybe I should start from sctratch now Ive installed the hotfix, but I dont think that would help either. Not one of the issues being fixed with the hotfix really sounded like something that is similar with this.

Look at this line of code:

strTabelNaam = "SubSelectieProcesInzet"

After executing this line the variable is empty. Fantastic! No, I mean horrible...

 

[Rabbie]

Hotfix did not solve issue.

Maybe I should start from sctratch now Ive installed the hotfix, but I dont think that would help either. Not one of the issues being fixed with the hotfix really sounded like something that is similar with this.

Look at this line of code:

strTabelNaam = "SubSelectieProcesInzet"

After executing this line the variable is empty. Fantastic! No, I mean horrible...

Sorry to hear that!. I can't think of anything else to help here as it is very difficult to solve a problem I can't recreate.

 

[steeffie]

No problem, thanks for your time and tips!

 

[steeffie]

lol, its hilarious (and disgusting at the same time).

If I step through the code and do

strTabelNaam = "SubSelectieProcesInzet"

strTabelNaam = empty (or "" in VBA terms)

If I change it to

strTabelNaam = "SubSelectieProcesInzet "

strTabelNaam = "SubSelectieProcesInzet "

and if I then change it back to

strTabelNaam = "SubSelectieProcesInzet"

strTabelNaam = empty (or "" in VBA terms)

 

[xBug]

Hi, I have EXACT the same CRAZY ERRORS
Decompile,Import all into new One, SaveAstext(MDB-TXT-MDB)
helps a liitlle , but the problem STILL PERSISTS !!!!!
How large is your DB ?
WHAT references are you using ?
----------
My solution While running code, PSEUDO-LINE-EDIT,compile and save All,
and than OK
-----------
In your Immediate window string are OK ?, by me HERE OK
----------
Immediate window...OK
Compiler/Code running....WRONG !!!!!

 

[xBug]

Ac2000...the same bugs (English full)
Ac2002...the same bugs (English full)
Ac2003...the same bugs (Mixture Access english, others Native Lang)
-------------------------
another machine the same bugs...
Full access reinstall and last update from WEB.. the same
Ac-Help-Detect and repair with Restore DEFAULTS settings...the same
Memory TESTING...ok
-------------------------
Do you have Compile on Demand =OFF ?
Do you have Access CRASHES problems ?
-------------------------
Decompile really Helps, but there is NO GARANTEE about this:
Are there somewhere other BUGs ?
--------------------------
I have build an Testing-Run , for small derivation of my DB
But i CAN NOT Testing everything
If after test OK, than runs it dailly over night (~15hours)...OK

 

[steeffie]

Hi, I have EXACT the same CRAZY ERRORS
Decompile,Import all into new One, SaveAstext(MDB-TXT-MDB)
helps a liitlle , but the problem STILL PERSISTS !!!!!
How large is your DB ?
WHAT references are you using ?
----------
My solution While running code, PSEUDO-LINE-EDIT,compile and save All,
and than OK
-----------
In your Immediate window string are OK ?, by me HERE OK
----------
Immediate window...OK
Compiler/Code running....WRONG !!!!!

In Immediate window strings are incorrect too, so your problem seems a little different.

Still no solution found. I'm glad I've found a way to create an mdb, which works fine as long as VBA code stays intact. I export all VBA to text files, import them in a new mdb on an XP machine with Office 2003 SP2, along with all objects from my working version. I dont know if problems will arise on that machine too after changing VBA, but I'm afraid that it will and after that it will not create working versions anymore. Im running Vista with Office 2003 SP3 on my developing machine.

 

[xBug]

By me
VBE-TOOLS-OPTIONS-GENERAL TAB-
COMPILE ON DEMAND = OFF
if <ON> than my DB usually crashes...
and you ?

 

[xBug]

1.On me: WIN XP SP3
vbe6.dll, ModVer: 6.5.10.24, and you ?
---------------------------------------------------
2.How long are you Fighting with this Bugs, First time appears it on......?
I am fighting with this ~ 2 years
---------------------------------------------------
3.How about your Project-Component size ?
---------------------------------------------------
4.My Project-Component size:
But i am using Large Condinitional Blocks, like this #Const gflgCompileFUL
-----------

for i = 1 to application.VBE.VBProjects(1).VBComponents.Count:debug.Print i,application.VBE.VBProjects(1).VBComponents(i).Name,application.VBE.VBProjects(1).VBComponents(i).CodeModule.CountOfLines:next i

1 Form_FRM_ZZ2_BBS 759
2 Form_FRM_ZZ2_BXA 241
3 Form_FRM_ZZ2_BXN 692
4 Form_FRM_ZZ2_BXO 230
5 Form_FRM_ZZ2_KUK 2391
6 Form_FRM_ZZ5_DVX 116
7 Form_FRM_ZZ5_ECC 3936
8 Form_FRM_ZZ5_KSX 1374
9 Form_FRM_ZZ5_STM 1066
10 Report_RPT_ZZ7_TRD 343
11 Report_RPT_ZZ7_TXT 69
12 Report_RPT_ZZ7_ZMN 375
13 CLS_ZZ2_CLP 182
14 CLS_ZZ2_DLG 405
15 CLS_ZZ2_EXT 4860
16 CLS_ZZ2_MPK 2183
17 MOD_ZN7_IF2 7843
18 MOD_ZN7_KS2 8394
19 MOD_ZN7_SF2 3055
20 MOD_ZN9_ARC 603
21 MOD_ZN9_BK2 5757
22 MOD_ZN9_DEC 242
23 MOD_ZN9_EX2 4504
24 MOD_ZN9_FX2 2525
25 MOD_ZN9_SYS 1020
26 MOD_ZZ0_CON 3841
27 MOD_ZZ2_CM1 21896
28 MOD_ZZ2_REF 825
29 MOD_ZZ3_AC1 20309
30 MOD_ZZ3_AC2 14738
31 MOD_ZZ3_AC3 4635
32 MOD_ZZ3_AL1 13350
33 MOD_ZZ3_BAS 1232
34 MOD_ZZ3_VB1 2106
35 MOD_ZZ3_VB2 8296
36 MOD_ZZ5_000 6724
37 MOD_ZZ5_FR1 3758
38 MOD_ZZ5_FR2 6685
39 MOD_ZZ5_IN1 3768
40 MOD_ZZ7_BK1 1363
41 MOD_ZZ7_IF1 3834
42 MOD_ZZ7_KS1 5972
43 MOD_ZZ7_PRT 834
44 MOD_ZZ7_SF1 4124
45 MOD_ZZ9_EX1 4080
46 MOD_ZZ9_VAJ 637

[SIZE=2]Debug.Print "AllMacros.Count= " & Application.CurrentProject.AllMacros.Count[/SIZE]
[SIZE=2]AllMacros.Count= 8[/SIZE]
[SIZE=2]Debug.Print "Pages.Count= " & Application.CurrentProject.AllDataAccessPages.Count[/SIZE]
[SIZE=2]Pages.Count= 0[/SIZE]
[SIZE=2]Debug.Print "QueryDefs.Count= " & DBEngine(0)(0).QueryDefs.Count[/SIZE]
[SIZE=2]QueryDefs.Count= 0[/SIZE]
[SIZE=2]Debug.Print "TableDefs.Count= " & DBEngine(0)(0).TableDefs.Count[/SIZE]
[SIZE=2]TableDefs.Count= 8[/SIZE]
[SIZE=2]FOR I = 1 TO References.Count: DEBUG.Print I,REFERENCES(I).FullPath: NEXT I[/SIZE]

1 C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
2 C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB
3 C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL
4 C:\Program Files\Common Files\System\ado\msado25.tlb
5 C:\Program Files\Common Files\System\ado\msADOX.dll
6 C:\Program Files\Common Files\System\ado\msjro.dll
7 C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE
8 C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL
9 C:\WINDOWS\System32\scrrun.dll
10 C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
11 C:\Program Files\Microsoft Office\OFFICE11\MSOUTL.OLB
12 D:\Program Files\Attachmate\E!E2K\EXTRA.TLB
–––-

 

[xBug]

Hi,
Try VBE6.DLL(6.04.9972) ...
It works WONDERFULL on Ac 2003 SP3, and without any CRASH...