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 1958
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...
|
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...
|
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....
|
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++...
|
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...
|
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...
|
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...
|
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.
...
|
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...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
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,...
| |