Solved

Why this error occur?

Posted on 2002-03-25
8
131 Views
Last Modified: 2010-05-02
I load a form from main menu using form1.show vbmodal
after save some data in form1, i click 'back' button for back to main menu.

It always display this error message and some data might not be save sometimes.

Error during lolad.   Refer to C:'\Windows\Desktop\myVBFolder\form1.log' for details

How to solve this problem?
0
Comment
Question by:yongyih
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6895527
and what is the error in the .log ?
0
 
LVL 1

Expert Comment

by:inethog
ID: 6895667
Send me your code and the log file, I'll have a look at it, if you wish.

D.

inethog@hotmail.com
0
 
LVL 2

Author Comment

by:yongyih
ID: 6895727
sorry, i already solve this problem..
the problem is because

unload form1
form1.setVisible=false

i should set visible to false first before unload form1.

Can i change the question to another one..
how to do calculation for date.
example today is 26/03/2002
i want to add 13 (13 months) to this date so that i get
26/03/2003

how can i do this?  

thanks.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 3

Expert Comment

by:Bahnass
ID: 6895747
I think u SHOLD ASK TO DELETE q ( By sending 0 point Q in community support area) then make a new Q for PAQ
as any one will visit the Q will not know from its header

also think about emoreau Told U to C what is inside log file ( This can be translated into points more than 10 ....)

0
 
LVL 51

Accepted Solution

by:
Ryan Chong earned 10 total points
ID: 6895750
Anyway try: Dateadd("m",13,now())
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6896081
>>example today is 26/03/2002
>>i want to add 13 (13 months) to this date so that i get
>>26/03/2003

now + 13 months = april 2003!
0
 
LVL 2

Author Comment

by:yongyih
ID: 6899701
thanks ryancys, you solved my problem.
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 6901035
you're welcome :)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MsgBox 2 61
Using "ScreenUpdating" 6 83
Access Object Property from VBA Module in Excel 2010 2 39
how to know if my Checkbox is True in VB6.0? 9 65
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question