Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #21 (permalink)  
Old March 30th, 2009, 12:12 PM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

Maybe, because I never see a problem like that...

Unless the database is broken...
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========
  #22 (permalink)  
Old April 1st, 2009, 07:34 AM
Authorized User
 
Join Date: Mar 2009
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It has nothing to do with datatypes and memory issues are of no concern as it has plenty of it.

Take this line of code which today failed to do what is should:

Code:
strTabelNaam = "SubSelectieProcesInzet"
After executing this line the variable is still empty. Its hilarious and disgusting at the same time.
  #23 (permalink)  
Old April 1st, 2009, 08:03 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

Access is broken then!. Did you re install it?? Maybe you have to reinstall the whole computer. :(
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========
  #24 (permalink)  
Old April 1st, 2009, 08:39 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Memory doesn't have to do with the amount of system resources your PC has, it has to do with the range of memory address space that is reserved when you use each type of variable. For example, Integer variables hold signed 32-bit (4-byte) integers that range in value from -2,147,483,648 through 2,147,483,647. If that value is exceeded, as can be the case with a primary key field, then there is a memory overflow, regardless of how much RAM you have on your computer. It overflowed the reserved address space.

It doesn't seem that the variable types are an issues since strings will hold 2B unicode characters.

That has me stumped. Have you run this on other computers to see if you can duplicate the behavior there? It is very unusual.
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
  #25 (permalink)  
Old April 15th, 2009, 06:04 AM
Authorized User
 
Join Date: Mar 2009
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've reinstalled Access on my machine and still have the problems.

There is one work-around which seem to work for me atm. That is exporting all modules to textfiles. Create new mdb on a XP-machine with Office 2003 SP2. Import all objects from the original mdb. Import all VBA modules (the textfiles).

The problem is that i need to do this basically everytime I change something in the code.

fml :-(
  #26 (permalink)  
Old May 1st, 2009, 03:37 AM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to pacala_ba
Exclamation

Hi
EXACTLY the same on my PCs...
=========================
I have found one one common feature between my and your DB, i do not use
Static Queries. Queries.Count=0
I use dynamically created queries, and Connection/Command.Execute cSQL
-------
keywords: Compiler Wrong , Crazy Error , vba string bug
-------

Last edited by pacala_ba; May 1st, 2009 at 03:41 AM..
  #27 (permalink)  
Old May 2nd, 2009, 06:52 AM
Friend of Wrox
 
Join Date: May 2006
Location: Helsingborg, , Sweden.
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Have you checked your OPTION EXPLICIT setting?
  #28 (permalink)  
Old May 2nd, 2009, 09:03 AM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to pacala_ba
Default

Have you checked your OPTION EXPLICIT setting?
YES, and All the other Settings
-Decompile: really helps, but the succes is not very High
- Import all into new one from old
- SaveAsText/LoadAsText(MDB-TXT-MDB)
- Acces 2003 reinstall and Last update from WEB
- Ac Help-Detect and Repair, Restore defaults Settings
- Over 1000 Access crashes send to Microsoft in last 2 years
i am Fighting with this ~2 years
--------------------------------------------------------------------------
All the History about ONE CODE LINE !!!
Dim cSQL as String
cSQL = "A" & "B"
-----------------------------
Result SOMETIMES(Random process there ) While running code cSQL = "A"
Result Immediate/Debug Window ***ALLWAYS OK***,cSQL = "AB"
---------
My Opinion Compiler is *** Sometimes *** Wrong
Compile on Demand = OFF (If ON, permanent crash)
I have Large Modules , some over 20 000 lines, But this happens also in small Example DB....
I have some MDE-versions of my DB, they are running dailly (15 hours)...OK,
but before run i MUST it CHECK , for CRAZY ERRORS/VBA STRING BUG...
---------
Keywords: Compiler Wrong/Crazy Error Access/ vba string bug
---------
Example DB AC2002 (ZIP 1,2 MB), an Extraction from Original DB
http://www.dbforums.com/microsoft-ac...xample-db.html
Next week i try to create Example DB for Ac2003
---------
Links to this Problem:
http://sites.google.com/site/pacalaba/
  #29 (permalink)  
Old May 2nd, 2009, 09:48 AM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to pacala_ba
Default

OPTION EXPLICIT , YES
------------
another examples:
-----------
my_Ar = array("a1","a2")
Running: my_ar(1) = Nullstring
Immediate window : my_ar(1) = "a2"
----------
Application.SetOption "Ignore DDE Requests", 0
===============================
Run=> ..........YES Error 2091
? err,err.Description
2091, '' is an invalid name.
Access do NOT see 'Ignore DDE Requests" there !!!!!!!
--------------
RST!My_COL_NAME
--------------
ALLWAYS the same in Immediate/Debug window is O.K.
  #30 (permalink)  
Old May 2nd, 2009, 09:57 AM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to pacala_ba
Default

image-example:
http://i42.tinypic.com/2nun4me.jpg
On the First Time, i do not believe to my eyes....




Similar Threads
Thread Thread Starter Forum Replies Last Post
Bug or no to bug learning C using VS.Net to compil tesh All Other Wrox Books 0 February 14th, 2007 01:06 PM
Trim a string in VBA lryckman Access VBA 2 January 19th, 2007 08:39 AM
Span Bug? interrupt HTML Code Clinic 4 June 20th, 2006 09:40 AM
Bug happens guoqi BOOK: ASP.NET Website Programming Problem-Design-Solution 0 October 13th, 2003 01:35 PM
String access by character bug in multi-dimensiona richard.york Pro PHP 1 September 6th, 2003 05:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.