473,320 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Opening User Forms

i have designed a userform and everything works ok on my computer. to view the form a macro has been recorded to a button with the code, userform1.show. this macro is called showform().
when somone else tries to view the form they are greeted with an error, when you click debug the error is the macro to open the form. can anyone shed any light on this?
i cant understand why i can use this but nobody else can
thank you
Nov 29 '07 #1
5 1182
debasisdas
8,127 Expert 4TB
Kindly post what exactly is the error message.
Nov 29 '07 #2
when the button is clicked to display the form the error reads.
Run-Time error '1004':
Application defined or object-defined error

when you debug the error is in the macro:

Sub ShowForm()
UserForm1.Show
End Sub

and the userform1.show line is highlighted.
any help wiould be greatfully apreciated
Nov 29 '07 #3
hariharanmca
1,977 1GB
application defined or object defined error
Will this helpfull for you.
Nov 29 '07 #4
hi i have had a look at this and downloaded some other files for the other users who will access this workbook and form. it still doesnt work. i work in an office so all computers have the same spec and files included. the form works perfectly for me but nobody else can use it
Nov 29 '07 #5
i have sent the file to my home pc and it works but still doesnt on the other office pc's we have tried various releases of windows and excel with no joy, any ideas please
Nov 29 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: VanIkyn | last post by:
Hello peoples, This is a last resort, as I've run out of search strings I can think of for this problem. There may very well be a simple and logical solution that I have overlooked. Thanks in...
1
by: N. Graves | last post by:
Hi, I want to have a Search Dialog box that has several text box and fields to build a search and display the results in a form. I can do everything that I need to if I us a report but I would...
5
by: Burton Roberts | last post by:
When using ASP.NET and an OleDBConnection control I get this error on CNN.Open: "The Microsoft Jet database engine cannot open the file 'C:\A2K\Backups\EdsBe2K.mdb'. It is already opened...
16
by: iwdu15 | last post by:
how can i open a file i saved and place the info into different text boxes?
1
by: Vivek | last post by:
Hi, I am developing a MDI application. I need to track the child forms open so that I can stop a user from opening the multiple instances of the same child form. Now what is the best way of...
2
by: chris | last post by:
Hi, I've developed a Windows Forms Application in Visual Studio 2003. I built an MSI package using the setup and deployment projects setup wizard. I ran the MSI package on my machine (where I...
11
by: Tony K | last post by:
I have a MDI application. On the menu toolstrip child forms are selected from one of the menus. I don't want to play the disable/enable menu item game. I have selected that open forms are added...
1
by: Mucker | last post by:
This could be a difficult one, so please bear with me. I've an assembly containing Delphi 2006.NET forms. A C# app, via reflection opens these forms . This works fine - I've a C# app, opening...
21
by: Dan Tallent | last post by:
In my application I have a form (Customer) that I want to be able to open multiple copies at once. Within this form I have other forms that can be opened. Example: ZipCode. When the user enters...
2
by: =?Utf-8?B?RXRoYW4gU3RyYXVzcw==?= | last post by:
I am (still) relatively new to Windows applications, most of my experience has been Web based, and I am confused about what exactly happens when the Main() method is called and how to manipulate...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.