Hi,
Does anyone know about a application builder which can be based on ms access?
I need software to build an application with forms, tables etc as in access. The reason is that I wat the application to look professional. Not like in access with the screen in the background. E.g. If i click on the application it must open with a form to log in. And all the other forms must be like on any other program. Not with the access screen on the background. could anybody suggest something?
Thanks
4 1965
You can compile the access app so it runs independant of access or you can switch off all the background stuff from within access code. No need to reinvent the wheel.
Hi, thanks for replying after so long time. What info do u need from me to help me build that code. That would just be amazing.
Ryno
OOps, just taken another look at compliling database to mde and using access runtime module, still allows user to access tables so sorry no good.
Will dig out an old prog of mine with code to disable menus etc and post soon as.
Ok have stripped my old app except for relevant code.
First off let me point out a few things.
When the app starts it may ask you if you want to block unsafe expressions, the only way I know to get around this is to go to te tools menu in access and select macros, security. You need to set the option to low which, I guess is ok if you are operating in a closed environment. Or add yourself as a trusted source but I don't know how to do that.
When the app opens menus and the design window are hidden, the code is in the open event of the switchboard form. -
Private Sub Form_Open(Cancel As Integer)
-
' Minimize the database window and initialize the form.
-
' hide toolbars
-
On Error Resume Next
-
-
-
DoCmd.RunCommand acCmdWindowHide
-
DoCmd.ShowToolbar ("menu Bar"), acToolbarNo
-
DoCmd.ShowToolbar ("Database"), acToolbarNo
-
DoCmd.ShowToolbar ("Relationship"), acToolbarNo
-
DoCmd.ShowToolbar ("Table Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Table Datasheet"), acToolbarNo
-
DoCmd.ShowToolbar ("Query Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Query Datasheet"), acToolbarNo
-
DoCmd.ShowToolbar ("Form Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Form View"), acToolbarNo
-
DoCmd.ShowToolbar ("Filter/Sort"), acToolbarNo
-
DoCmd.ShowToolbar ("Report Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Toolbox"), acToolbarNo
-
DoCmd.ShowToolbar ("Formatting(Form/Report)"), acToolbarNo
-
DoCmd.ShowToolbar ("Formatting(Datasheet)"), acToolbarNo
-
DoCmd.ShowToolbar ("Macro Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Utility1"), acToolbarNo
-
DoCmd.ShowToolbar ("Print Preview"), acToolbarNo
-
DoCmd.ShowToolbar ("Utility2"), acToolbarNo
-
DoCmd.ShowToolbar ("Web"), acToolbarNo
-
DoCmd.ShowToolbar ("Source Code Control"), acToolbarNo
-
DoCmd.ShowToolbar ("Visual Basic"), acToolbarNo
-
-
-
' Move to the switchboard page that is marked as the default.
-
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
-
Me.FilterOn = True
-
-
End Sub
-
Strangely the line - DoCmd.RunCommand acCmdWindowHide
only seems to work when the app is initially opened.
You MUST have a backdoor entry built into your app, personally I comment out the above code until I am sure the app is ready and working.
The backdoor in the attached app is a label on the switchboard with a click event set, this then asks for a password before proceeding (or not) to let you select wether to show or hide the menu bars etc. Instructions are shown in the app attached.
The code to toggle show or hide is as follows.
in the label click event -
Private Sub Label25_Click()
-
Dim msg As String
-
On Error GoTo wrongpass
-
-
msg = InputBox("Enter the security code.")
-
If msg <> "secadmin" Then
-
GoTo wrongpass
-
End If
-
msg = InputBox("Option Hide / Enable ?")
-
If msg = "enable" Then
-
'reinstate toolbars
-
On Error Resume Next
-
-
DoCmd.ShowToolbar ("menu Bar"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Database"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Relationship"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Table Design"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Table Datasheet"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Query Design"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Query Datasheet"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Form Design"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Form View"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Filter/Sort"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Report Design"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Toolbox"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Formatting(Form/Report)"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Formatting(Datasheet)"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Macro Design"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Utility1"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Utility2"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Print Preview"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Web"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Source Code Control"), acToolbarWhereApprop
-
DoCmd.ShowToolbar ("Visual Basic"), acToolbarWhereApprop
-
Exit Sub
-
End If
-
If msg = "hide" Then
-
-
DoCmd.ShowToolbar ("menu Bar"), acToolbarNo
-
DoCmd.ShowToolbar ("Database"), acToolbarNo
-
DoCmd.ShowToolbar ("Relationship"), acToolbarNo
-
DoCmd.ShowToolbar ("Table Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Table Datasheet"), acToolbarNo
-
DoCmd.ShowToolbar ("Query Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Query Datasheet"), acToolbarNo
-
DoCmd.ShowToolbar ("Form Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Form View"), acToolbarNo
-
DoCmd.ShowToolbar ("Filter/Sort"), acToolbarNo
-
DoCmd.ShowToolbar ("Report Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Toolbox"), acToolbarNo
-
DoCmd.ShowToolbar ("Formatting(Form/Report)"), acToolbarNo
-
DoCmd.ShowToolbar ("Formatting(Datasheet)"), acToolbarNo
-
DoCmd.ShowToolbar ("Macro Design"), acToolbarNo
-
DoCmd.ShowToolbar ("Utility1"), acToolbarNo
-
DoCmd.ShowToolbar ("Print Preview"), acToolbarNo
-
DoCmd.ShowToolbar ("Utility2"), acToolbarNo
-
DoCmd.ShowToolbar ("Web"), acToolbarNo
-
DoCmd.ShowToolbar ("Source Code Control"), acToolbarNo
-
DoCmd.ShowToolbar ("Visual Basic"), acToolbarNo
-
Exit Sub
-
End If
-
Exit Sub
-
-
wrongpass:
-
'error because no password entered
-
-
Exit Sub
-
End Sub
-
After entering "enable" to show menu bars, to show the design pane you must goto access menu "window, unhide" and select database window. After you have finished updating, maintaining your app you should again goto access menu "window" and select to hide the design pane then select your backdoor entry point and hide menu strips etc BEFORE handing the app back to the user / operator.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: james |
last post by:
My fellow VB.NET developers,
Ever wonder why MS didn't include a "Class Builder" in Visual Studio .NET
like they did in other versions of visual studio?
So did we.
|
by: sales |
last post by:
I am glad to present to the community of this group the new version of
our component intended for visual building of SQL queries via an
intuitive interface - Active Query Builder
(http://www.activequerybuilder.com/). It has full support for MS SQL
Server dialect starting from version 7 to 2005.
Active Query Builder can be used in different development environments.
Today our visual component is availiable in the following editions:...
|
by: Daz Talbot |
last post by:
Hi there
Does anyone know if it is possible to invoke the SQL Server Query Builder
from within a VB.NET program.
I'd like to have query building functionality within my application.
Thanks
Daz
|
by: AlexanderTodorovic |
last post by:
Hello Everyone,
I'm developing a client application in which the users need an
expression
builder as provided in MS Access 2003. I would like to use the
expression
builder in a C# application.
Is is possible to call the expression builder e.g. via automation?
If yes, how can i execute the rules and get the result?
|
by: Leite33 |
last post by:
Hello
I am rookie in learning C++ Builder 6. I try to make an application for storing data and especially pictures. So i try to connect C++Builder 6 and Microsoft SQL Server 2000. I use 4 C++ Builder 6 components,Ado Connection,Ado Table ,Datasource and DBGrid. For the connection i dont use code and is very easy. But i have a big problem,when i am running the application its brings me an error,"Cannot Convert Null To String". How can i solve...
| |
by: John J. Hughes II |
last post by:
Is it possible to compile report builder into a Forms based application? If
that is not possible is there a way of including it with the install so its
at least installed at the same time the application is. I would prefer not
to use the OneClick install from the Report Services due to the many
problems.
Regards,
John
|
by: jphelan |
last post by:
Ever since I successfully applied some techniques for increasing the
speed of my 17 meg. Application; it has only made me hunger for more.
First, let me list what I have done so far:
1. Split the application and database into front and back-ends,
2. Increased the load-time of my application by "pre-loading my
heaviest forms when the database is initially opened,
3. When forms do open, under, "Filter Lookup" I use, "Never",
4. I set...
|
by: nirmaljanak |
last post by:
Hello Experts,
I am using Oracle Report Builder 10g for creating reports. I am saving all reports in JSP format. when I run it withing report builder it works fine.
I want to enclose this JSP in my web application, when done it gives run time errors.
Is there any setting that i need to do to run JSP created through Report Builder within an web application.
Because it is just a JSP page it should work. but not working .
|
by: Lars Uffmann |
last post by:
Does anyone have a good suggestion?
I am currently using Eclipse Europa with the C-Development Toolkit (plus
gnu-toolchain under cygwin) and the Widestudio Native Application
Builder plugin.
While I am surprised I actually got this configured and running, it has
some things that I do not like too much - especially a couple of bugs
(build tools vanishing from the builder settings upon switching between
projects, for example). And then...
|
by: Oriane |
last post by:
Hi there,
I would like to open my Asp.Net project as a "Web Application" rather than
as a "Web Site" in Visual Studio.
But the thing is that I use the System.Web.Profile and the auto-generated
class "ProfileCommon myApp.Profile", which provides me with type profile
properties. And the fact is that this generated class is not generated with
Web app...
For ex, in the web site project, if "X" is a profile Property, I can write:
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |