Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 150
Default Userform.show '1004 Error'

Hello All,

Ok, this is quite a strage question, however I have experienced this problem
and so has a colleague of mine for a different application.

The problem:
Upon clicking a button in order to show my form, I get the '1004'
Application Error.

As of Friday, I had tested it to ensure all was working and it was. Previous
versions of the tool I'm developing work fine with Exactly the same coding.
Hence I'm very confused. The code I've been using to show the form is:

Private Sub CommandButton1_Click()

frmHub.MultiPage1.Value = 0
frmHub.Show

End Sub


Has anyone else experienced this problem or know of bugs/fixes for it?

Thanks

Stan
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Userform.show '1004 Error'

Try showing the form before you address an onject on it.

Nath
-----Original Message-----
Hello All,

Ok, this is quite a strage question, however I have

experienced this problem
and so has a colleague of mine for a different

application.

The problem:
Upon clicking a button in order to show my form, I get

the '1004'
Application Error.

As of Friday, I had tested it to ensure all was working

and it was. Previous
versions of the tool I'm developing work fine with

Exactly the same coding.
Hence I'm very confused. The code I've been using to show

the form is:

Private Sub CommandButton1_Click()

frmHub.MultiPage1.Value = 0
frmHub.Show

End Sub


Has anyone else experienced this problem or know of

bugs/fixes for it?

Thanks

Stan
.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 188
Default Userform.show '1004 Error'

"Stan" wrote in message
...

Hello All,

Ok, this is quite a strage question, however I have experienced this
problem and so has a colleague of mine for a different application.

The problem:
Upon clicking a button in order to show my form, I get the '1004'
Application Error.

As of Friday, I had tested it to ensure all was working and it was.
Previous versions of the tool I'm developing work fine with Exactly
the same coding. Hence I'm very confused. The code I've been using

to
show the form is:

Private Sub CommandButton1_Click()

frmHub.MultiPage1.Value = 0
frmHub.Show

End Sub


Has anyone else experienced this problem or know of bugs/fixes for

it?

Thanks

Stan


Not sure if this will fix it, but I normally only show a userform from
the calling sub.

Any other actions, such as frmHub.MultiPage1.Value = 0 I would
normally put in the activate event code.

HTH,

Alan.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
error 1004 (VBA) Harlan Grove Excel Discussion (Misc queries) 0 May 15th 06 07:33 PM
Run time error 1004, General ODBC error [email protected] New Users to Excel 0 September 19th 05 01:41 AM
Runtime error '1004' General ODBC error star_lucas New Users to Excel 0 August 29th 05 04:09 PM
Excel 2003 Macro Error - Runtime error 1004 Cow Excel Discussion (Misc queries) 2 June 7th 05 01:40 PM
VBA error - run-time error '1004': Romanian37 Excel Programming 3 May 21st 04 03:25 PM


All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"