Access 2002 bug: "dynamic" forms problem - re-post plus more...

There was no respond to my original post in microsoft.public.access.forms 
(May 5th 2007) about a fortnight so I try it here...
���������������������������������
A while ago we had a discussion about A2002 (sub)form which changes
dynamically from code (hide/unhide controls, change subfom's width, etc.).
There's a problem if I make some changes in code when the form is open: if I
save changes, A2002 saves controls positions & subform's size as well. This
is a BIG A2002 BUG and it's really annoying. Why Access forms don't behave
as Visual Basic forms? I don't want Access to change my (sub)forms' design
properties... grrrrrrr....

Somebody has recommended not to save changes when I'm in debug and/or(?)
break mode. Good idea, but sometimes I simply forget... today (May 5th 2007) 
it happened
twice...

1) Do I really have to close all forms and return to database window when I
need to make changes in my "dynamic" (sub)forms?
2) Any workaround to avoid user's CtrlS on such (sub)forms? Do I really have
to add a code to Form_KeyDown events? All forms? :O
3) Does A2007 behave the same way?
4) Is there any document, official or unofficial, about how to correctly 
handle code-writing in MS Access to avoid:
a) project database corruption?
b) loss of parts of project's code (which I've been experiencing for several 
months - since I have switched from A97 to A2002)?

I'd appeciate a list of "situations" when I should not make any changes in 
code:
a) debug
b) break

Also, I'd like to know what exactly do both debug and break in MS Access 
2002. There's poor information about debug/break in A2002 help.

During last few days I've lost some parts of VBA-code mostly after I reset 
the A2002 project and added new code (just after A2002 gave me some error 
and I chosen "debug"). I have decompiled the project but I'm affraid I'm 
still in trouble. :-(

I have never lost any part of code written in Visual Basic 6.0 but it's 
quite different in MS Access. Access developers' team should definetely make 
a research on what they're doing wrong in handling Access's VBA code. Access 
should not allow programmers make changes in code when it may cause any 
possible problem with MDB-corruption/VBA-code-loss.
If it is a problem why they don't simply store project files (forms, 
reports, VBA-modules) in text files? Then, Access should all necessary stuff 
from text files compile and add to MDE. In VB6 I have all the code stuff in 
ASCII-files which is really safe compared to Access.

TIA

Vlado 

0
windows
5/17/2007 9:08:58 AM
access 16762 articles. 3 followers. Follow

1 Replies
1345 Views

Similar Articles

[PageSpeed] 42

Access is not either a subset nor a superset of VB6.  The classic VB and 
Access object models are quite different, and there is neither promise nor 
implication that they do, or should, work the same. I do not know the 
hyperlink, but there is a place where you can submit requests / 
recommendations to Microsoft.  My guess is that, if there have not been a 
flood of requests for such a change, the likelihood is low of such a change 
being implemented to make a current product work the same as an obsolescent 
one.

Larry Linson
 Microsoft Access MVO

"Vladim�r Cvajniga" <no.spam@thank.you> wrote in message 
news:uTD7CMGmHHA.208@TK2MSFTNGP05.phx.gbl...
> There was no respond to my original post in microsoft.public.access.forms 
> (May 5th 2007) about a fortnight so I try it here...
> ���������������������������������
> A while ago we had a discussion about A2002 (sub)form which changes
> dynamically from code (hide/unhide controls, change subfom's width, etc.).
> There's a problem if I make some changes in code when the form is open: if 
> I
> save changes, A2002 saves controls positions & subform's size as well. 
> This
> is a BIG A2002 BUG and it's really annoying. Why Access forms don't behave
> as Visual Basic forms? I don't want Access to change my (sub)forms' design
> properties... grrrrrrr....
>
> Somebody has recommended not to save changes when I'm in debug and/or(?)
> break mode. Good idea, but sometimes I simply forget... today (May 5th 
> 2007) it happened
> twice...
>
> 1) Do I really have to close all forms and return to database window when 
> I
> need to make changes in my "dynamic" (sub)forms?
> 2) Any workaround to avoid user's CtrlS on such (sub)forms? Do I really 
> have
> to add a code to Form_KeyDown events? All forms? :O
> 3) Does A2007 behave the same way?
> 4) Is there any document, official or unofficial, about how to correctly 
> handle code-writing in MS Access to avoid:
> a) project database corruption?
> b) loss of parts of project's code (which I've been experiencing for 
> several months - since I have switched from A97 to A2002)?
>
> I'd appeciate a list of "situations" when I should not make any changes in 
> code:
> a) debug
> b) break
>
> Also, I'd like to know what exactly do both debug and break in MS Access 
> 2002. There's poor information about debug/break in A2002 help.
>
> During last few days I've lost some parts of VBA-code mostly after I reset 
> the A2002 project and added new code (just after A2002 gave me some error 
> and I chosen "debug"). I have decompiled the project but I'm affraid I'm 
> still in trouble. :-(
>
> I have never lost any part of code written in Visual Basic 6.0 but it's 
> quite different in MS Access. Access developers' team should definetely 
> make a research on what they're doing wrong in handling Access's VBA code. 
> Access should not allow programmers make changes in code when it may cause 
> any possible problem with MDB-corruption/VBA-code-loss.
> If it is a problem why they don't simply store project files (forms, 
> reports, VBA-modules) in text files? Then, Access should all necessary 
> stuff from text files compile and add to MDE. In VB6 I have all the code 
> stuff in ASCII-files which is really safe compared to Access.
>
> TIA
>
> Vlado 


0
Larry
5/21/2007 5:43:11 AM
Reply:

Similar Artilces:

setting a range dynamically
Hi there, Is it possible to dynamically set a range of cells in code. eg instead of Range("A2:E11").Select Selection.Copy Can I set the 2 and the 11 dynamically, something like dim i, j i = 2 j = 11 Range("Ai:Ej").Select Selection.Copy which obviously doesnt work Thanks Stevi -- Stevie ----------------------------------------------------------------------- StevieH's Profile: http://www.highdots.com/forums/m96 View this thread: http://www.highdots.com/forums/t301312 range("a" & i & ":E" & j).copy or range(cells(i,"A"...

dynamic build
='UNITED ARAB'!$B$4 UNITED ARAB is in column A2 of present worksheet. How do I build a formula to concatenate A2 into: ='UNITED ARAB'!$B$4 Should look something like: =A2+!$B$4 But my syntax is messed up. thanks Try =INDIRECT("'"&A2&"'!B4") --- HTH Bob Phillips "shank" <shank@tampabay.rr.com> wrote in message news:%23Xb6Pz1dKHA.5136@TK2MSFTNGP02.phx.gbl... > ='UNITED ARAB'!$B$4 > UNITED ARAB is in column A2 of present worksheet. > > How do I build a formula to concatenate A2...

Copying Formula to a dynamic range.
Hello All I have this formula =IF(ISNA(VLOOKUP(A4,'C:\[Id.xls]Sheet1'!$A:$B,2,2)),"" "",VLOOKUP(A4,'C:\[Id.xls]Sheet1'!$A:$B,2,2)) I have 5 different files in a folder, i need to open each file and add a column called ID and add the above formula till the end of file and then save the file. The number of rows in each file is different. Thank you for any help. --- Message posted from http://www.ExcelForum.com/ One way (with some assumptions): Option Explicit Sub testme() Dim myFileNames As Variant Dim myPath As String Dim iCtr As Long ...

creating dynamic chart from within VB6
I'm creating a chart within a Visual Basic 6 program which has 3 series. The first two series are static, and represent minimum/maximum limits for the third series, which is a diameter vs. offset graph. The diameter vs. offset graph will grow as more measurements are taken at increasing offsets, and I'm looking for a way to construct a dynamically-expanding graph. I've read some of the articles and website tutorials from past queries to this newsgroup, and it sounds like it is pretty easy to do this directly from Excel. My question: is there some way to do the same thing ...

Smart Tags for Dynamics GP 2010
Will the Smart Tag download that was used for Dynamics GP 10 work for Dynamics GP 2010? Is there a new download for GP 2010? ...

How I open Microsoft Dynamics GP through Command Prompt
I want to Open Microsoft Dynamics GP through command prompt with out entering user name password. I provide user name n password in the batch file. My qustion is that if I open GP through command prompt I dont want to enter password and i dont want to select company . I want that home page will appare directly. dont ask y i require this but i need this . If u please help me to finding out this. Download Microsoft's documentation on the Integration Manager and look at the last chapter. It discusses creating a macro to run on launch that will log a user in and select a company, ta...

Dynamic Chart with Two X Axis
I have a chart that has two columns for the X axis (date and time). I am making the chart dynamic so it will automatically update when new data are entered. To do this, I have named the data in the two columns "Date" and "Time." How do I enter these two names into the X axis label on the chart? Thanks in a advance for your help! I looked at that website, but it was no help. Does anyone else have a suggestion? >-----Original Message----- >Adam wrote: >> I have a chart that has two columns for the X axis (date >> and time). I am making the char...

Translated Microsoft Dynamics GP and/or Add-on Products
This week I am posting the last couple of articles in Translating Dexterity Applications Series. If you are interested in know how to translate Dexterity applications or just curious about how it can be achieved without any changes to source code, please have a look at: http://blogs.msdn.com/developingfordynamicsgp/archive/2009/02/09/translating-dexterity-applications-series.aspx If you are a developer or partner who has created a translated version of Microsoft Dynamics GP or an add-on product for Microsoft Dynamics GP, please post a comment on the article with the details of what you...

Dynamics GP 10 Trial Version Manufacturing Modules
Is there some sort of magic at install time to enable Manufacturing in the trial version? Or (better) a way to install it from a working trial version? Thanks -- Walter ...

dynamically copy cell content and fill color
I know I can easily copy the contents of cell S1 to cell A1 by simply putting =S1 into cell A1, but can I also copy the fill color and content from S1 to A1 using some function? TIA John Keith kd0gd@juno.com John Without code you are stuck with Copy>paste special>paste links then paste special>Formats. Unless S1 has conditional formatting for fill color. You could copy that CF to A1 Gord Dibben MS Excel MVP On Wed, 23 May 2007 18:03:15 -0600, John Keith <kd0gd@juno.com> wrote: >I know I can easily copy the contents of cell S1 to cell A1 by simply >putting =S1 ...

Great Plains Dynamics
Where can I get a list of instructor led classes and scheduals that I can provide to others in my company? Do you have access to CustomerSource or PartnerSource? If you have access to the former, select Training & Certification on the left. You can search classroom training and eCourses. You can try sending a message to mbsuniv@microsoft.com. "Tom Parke" wrote: > Where can I get a list of instructor led classes and scheduals that I can > provide to others in my company? Tom, try www.iggnet.com Richard L. Whaley "Tom Parke" wrote: > Where can I ge...

DYNAMIC RANGES #2
I am looking to develop a macro that will allow me to select a range of cells dynamically. I have created a mapping template that maps user defined fields to native fields, but each file that I map has a different number of rows of data. Rather than simply selecting a range of cells statically, I am hoping that there is a macro out there that will allow me to catch all data in a column by dynamically assigning my range to include all rows of data up to the last row containing information and no more. To add to this issue, not all intermediate rows will contain data, but it is important tha...

Dynamics GP 10.0 SP4? When?
Has anyone heard whether Dynamics GP 10.0 SP4 is still on track for July, 2009? Thanks. -- Tim Foster Tim, It is planned for July, this month. Hopefully we should be seeing it anytime soon. -- Thanks Janakiram M.P. MCP-GP Note: If you are a Microsoft Partner, You can also Login to Dynamics GP partner forums at http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/threads "Tim Foster" wrote: > Has anyone heard whether Dynamics GP 10.0 SP4 is still on track for July, 2009? > > Thanks. > > -- > Tim Foster That's what I was expecting, but a ...

Dynamics 6.0 in WinXP
Can I use Dynamics 6.0 with WinXP Operating System? I am experiencing different errors in POP eversince I upgraded my O.S. I have clients running 6.0 GP with no problems...but what are your POP errors? "GP Support" wrote: > Can I use Dynamics 6.0 with WinXP Operating System? > > I am experiencing different errors in POP eversince I upgraded my O.S. > > I believe you have to be on a service pack of GP 6.0 to be compatible with Windows XP - I don't remember which SP off the top of my head, but I want to say 6 or 7. I think 6.0 went up to SP 12, and the...

Dynamics GP 10.0 with Framework 3.51
I am installing a Dynamics GP 10.0 fresh install with SQL 2008 on a test server, and it is having problem in finding Frame Work 2.0 even though it is installed on the server. In the process of installing Dexterity shared component 10.0 it is failing because Frame Work 2.0 is not installed on the server. I have not tried uninstalling 3.51 from machine yet. I am wondering are there any tricks to mimic the installation to skip this check. Thanks, Vishnu ...

Dynamic distribution list based on direct reports??
Exchange 2007 Is it possible to create a dynamic distribution list for each staff that reports to a specific manager?? On Wed, 16 Jun 2010 00:10:12 -0400, "JackH" <grandam010nospam@gmail.com> wrote: >Exchange 2007 > >Is it possible to create a dynamic distribution list for each staff that >reports to a specific manager?? Maybe. http://technet.microsoft.com/en-us/library/bb738155(EXCHG.80).aspx "Manager" and "DirectReports" work as filterable properties for some of the "Get-*" cmdlets. Maybe they'd work...

Dynamic Distribution groups
Hello, In oure organisation, we use multiple global address books to hold all contacts. Each week we send out a news letter to all employees, retired-employees, and some external persons. Right now we use several Distribution Groups (DG) for each group, and put these DG together in a other DG called "newsletter" This method works, but needs a lot of administration to keep all the DG up-to-date. I'm looking for a way to minimize the administration fot this. The most perfect thing would be to create a new "Newsletter: yes/no" field in the address books. So for e...

Delete All Transactions in Dynamics GP
Hello all, I am looking for a method that will help me delete all of the transactions but keep all other data from a single company in Dynamics GP 10.0 SP4. I want to do so because we were running a multi-company GP for final test and we had to do a lot of modifications to the initial configurations. Now we are stuck either with working with an old backup that has the old configuration that need modification but with no transactions, or to delete all of the transaction from the company. I have done a small research on the web but i couldn't find anything like this. Dyn...

Dynamic IP for MX record.
Hi All, Since my ISP only provide a Dynamic IP, is that anyway I can use the Dynamic IP for MX record or A record ? Is it any way can help me to solve this problem. I used to have a static IP for my server at home, but since I change the ISp and it wont' work now. Is anyone could help ?? Thank you. Zoya. In news:ua7HMBmGGHA.2320@TK2MSFTNGP11.phx.gbl, Zoya <vaio9003@yahoo.com> typed: > Hi All, > > Since my ISP only provide a Dynamic IP, is that anyway I can use the > Dynamic IP for MX record or A record ? Is it any way can help me to > solve this problem....

Dynamics GP 11.0
Is GP 11.0 beta available for download? We are a gold certified partner. We would like to test the GP 11.0 beta, be a beta site or learn more about GP 11.0. Please let us know how to go about this. Thanks, VJ Hello, If you are interested in receiving more information on the GP 11.0 "beta program" please email your partner information to dyngptap@microsoft.com. Thank you, Jen -- "This posting is provided "AS IS" with no warranties, and confers no rights." "VJ@QCI.Com" wrote: > Is GP 11.0 beta available for download? We are a gold certified p...

Smart Tags Not recognising Microsoft Dynamics GP data in Word
Give no error in application. sterror.text gives Error for user DOMAIN/FirstName.Suname Begin Term File Creation: 13/11/2006 09:41:37. Error Number = -2147217900 Date = 13/11/2006 09:41:37 Description = Line 1: Incorrect syntax near '.'. Source = Microsoft OLE DB Provider for SQL Server Last DLL Error = 0 Module = SmartTagCB:ReadTokens ------------------------------------------------------------ Finished Term File Creation: 13/11/2006 09:41:37. Creation Time: 0 Seconds. Seems problem may lie in period not being recognised in domain user with firstname.lastname format. Is there any ...

Adding Google Map to CRM iFrame (plus dynamic content to URL)
Here's a URL for google maps: http://www.google.ca/maps?f=q&hl=en&q= If I were to enter: http://www.google.ca/maps?f=q&hl=en&q= radio beacon inc. loc: toronto It would return the company Radio Beacon Inc. located in Toronto. I can dump this into an iFrame URL but I don't want it to be hardcoded. I would like to pass the Account Name the URL. I've seen some posts but I have not been able to make it work. I hope Michael Höhne is out there to help me too :) From OnLoad on my Account Form I have added this code: crmForm.all.IFRAME_AccountMap.src = http://...

Dynamics GP 9 on an Ultra Mobile PC
Just an FYI, Dynamics GP 9 seems to run just fine on a Samsung Q1 Ultra Mobile PC. I can definitely see some warehouse and retail applications for these types of devices down the road. No rewriting of software for a Pocket PC, built in touch screen, Wifi and bluetooth. Mark Polino (DynamicAccounting.net) That's great - thanks for testing it out and letting us know Mark!! -- Victoria Yudin GP MVP "Mark Polino" <mark@mpolino.com-nospam> wrote in message news:ADF8821E-51D2-481F-BDB5-DB0D914CF412@microsoft.com... > Just an FYI, Dynamics GP 9 seems to run just fine ...

Creating dynamically arrays, is that possible in VBA?
Hello I would like to do the following, but I am not sure it is doable in VBA. I saw it in Php, so I have a little hope it is. I have a spreadsheet full of range names. They are all of the form "S1.Name3.Subname2". Basically I would like to load in VBA all the values from these rangenames in one macro. For the moment I do it manually be doing dim S1_Name3_Subname2 S1_Name3_Subname2=Thisworkbook.Names("S1.Name3.Subname2").RefersToRange.Value2 and I do the same for all the range names. I have found on a post on this group a lovely program called NameManager that allows t...

Dynamic Range Not Working
I created a named range called HarvestData. In the refers to box I typed the following: =OFFSET(Harvest!$A$2,0,0,COUNTA(Harvest!$A:$A),COUNTA(Harvest!$1:$1)) I hit ok. If I go back into the "Define Name" dialog box and select the name "Harvest" and have it point to the actual range in the worksheet, it highlights cells A2:B20. The problem is, there are data in columns A to N. Why is it not recognizing the rest of the columns? I discovered this problem because I'm referencing column h in a VLOOKUP and it is not returning data that I know is there. What am I doing...