I am using MS Access to develop a DB application for one of my clients. Now I want to give it my client in a form of .exe file in which he can only use the menubar I have designed. I dont want him to see the MS Access toolbars
Kindly Guide
hi everyone i'm super new at access. i think it's neat for now.
i just made a form that people can use to insert information. we have a network drive here and it would be super cool to be able to convert the form into an Executeable file that way people can just click on the exe Icon and open up the form without having to go into access and then open the form.
please let me know
Is there anyway to create update patches for the access application? If the users are going to use the application for entering data, how can I just provide them update patches for th application if I make some changes in application in future, is it possible in access? I dont want them to change the application by themselves, so I can just make some updates and provide them, without causing any disruption in their datas.
View 3 Replies View Relatedhow to create web application using ms access. my requirement is i have an inhouse developed retail invoice application ( ms access 2003) which i need to move to web based.
View 2 Replies View RelatedI am using an attendance management system with a DB in Access. Now I want to create APPLICATION_ID automatically by continuing number. For example, I have a table called "LEAVE_APPLICATION" and the structure is below:
EmpID Leave_Type_ID APPLICATION_ID
00360 2 1
00360 2 2
00360 14 3
00360 14 4
00360 8 5
01390 8 1
01390 8 2
01390 14 3
01390 14 4
Now I want to update the table by adding the below data
00360 2
00360 2
01390 14
01390 1
How can i create the APPLICATION_ID field auto generating while pasting additional data. It should be numbering continually from the last record (Grouping to be applied for EmpID)like below:
00360 2 6
00360 2 7
01390 14 5
01390 1 6
I was looking to see if there was an easy way to create a user front end desktop application for a small access database.I have three users on different computers i would like them to input or amend data within one table of the access database.
View 2 Replies View RelatedI have been reading a lot about Access Runtime and the problems that occur when a runtime application is installed on a machine that already has a full version of Access. Any program that can be used to create an .EXE type file for an access application that will eliminate all of these problems? The cost of the compiler program is not a major concern if it works!!!
View 12 Replies View RelatedI have a series of 7 separate Access 2010 programs that are designed to run under the control of a scheduler, and they must always finish. Errors are trapped and logged but mustn't stop the processes completing.
What I'm trying to do now is to create a single master control program that runs each individual application, one after the other, in order. And each individual app cannot start until the previous one is finished.how to call a separate Access program and know when it has finished.
I am trying to make my database as secure as possible so I can sell the application I have written. Certian things are stored in a table to make the application unique to the buyer to hopefully stop free distribution.So I need to make sure that the user cannot acces the tables and make changes to them other than via the front end.I have a password protected backend but the users can still edit the contents of the table via the front end.Not sure if this is the easiest way but I am considering the following:I want to open the main form when the database is opened, and then close the whole access application when the main form is closed.Also, is there a way to change the text in the Top Bar that says Microsoft Access to something else plus change the Tab Name on the Windows Program selection bar at the bottom of the screen.Would using the Access Developer Extensions be the best answer to my problem??http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspxHas anyone used these?
View 4 Replies View Related1.What is Access Runtime?
2.Is there any way (or is it possible) that can change mdb/ mde to executable file (.exe), and can be ran in Access Runtime? :confused:
Thanks
I've made a few databases in the past for an engineering test facility with some (limited) success. Recently we purchased a time sheet program that works as a stand alone program, but uses Microsoft Access to operate. Everything is table driven and there are filters and all the good stuff from Access, but it's a seperate program - I don't have to open Access to run this program. This would be great if I could make database programs that could run on their own, so to speak. Any chance one of you could point me in the right direction on how to learn to do that kind of thing? Do you need stand-alone Visual Basic or can I make the program within the limitations of Access? I have both so it doesn't really matter, but outisde of VBA within Office products, I'm a programming noob. Thanks in advance.
View 1 Replies View Relatedit is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?
View 4 Replies View RelatedI was asked to create an Access db with search functionality in a form and have done so, now I have come across a problem………..
The team I have created this for do not have Access installed on their pc’s and this is and archive search db that I have created so will only be using it very rarely!! As a result I wondered if there is a free viewer or anything I can do to get them to use this db that I have created without having to purchase 12 licenses for an application that will rarely be used!
Any suggestions ?
If you make your database into a executable file to package it, does the other person you are sending it to have to have or own Access to use it. I was under the impression that I could create a database, package it as its own program and give it to someone that does not have access and it would still work? If not, how would I do such a thing.
View 4 Replies View RelatedIs there anything way how to convert the file.
View 1 Replies View RelatedHow can I turn my DB into an Executable file, or "stand alone"...Id like to have the end users when opening the DB see only the forms and reports without the Access Background.
View 1 Replies View RelatedWe have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.
I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.
Please help...thanks in advance for any thoughts!!!!
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
View 1 Replies View RelatedI created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
View 7 Replies View RelatedWhen putting together the final application, you don't want the user to see all the usual default menu options.
1) Which access items should I hide?
2)Let's say I make some modifications after we go live. How can I get the new forms, modules or whatever to the .mdb in use? Would I just delete the tables in the modified .mdb and then import (File/Get External Date/import) the tables with the live data?. It's not a split db, btw.
3) Are there any other options or procedures I should think about for maintainence? For instance, right now I use the compact on close option which has proved to be very useful.
Thanks,
scratch
Can anyone point me in the right direction to produce an application diagram.
Sort of a map of an app, what data it hold in laymans terms rathers than table and field definitions. What forms do what, and how the whole application fits together.
Thanks for any assistance you can offer.
This seems like a very silly question but I wondered if someone could tell me how I open up another mdb file from a form?
I've tried the following
On Error GoTo Err_Command976_Click
DoCmd.Quit
Dim stAppName As String
stAppName = "S:updateUpdateMDEUtility.mdb"
Call Shell(stAppName, 1)
Exit_Command976_Click:
Exit Sub
Err_Command976_Click:
MsgBox Err.Description
Resume Exit_Command976_Click
End Sub
But I just keep getting "Invalid Call Procedure or Argument"
Many Thanks
Andy
Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!
View 1 Replies View RelatedHello,
I do not want any menu bar in some application I have made using a switchboard. In the start-up function I unchecked all the checkboxes but some menu functions keep coming back. How can I overrule this?
I'm looking for methods to verify if an application is working correclty.
Any suggestions?
Thank you in advance.
Hi All!
I have created access Application and would like to document it. Do u guys have any samples, or maybe you have documented some aplication before...
Please chare,
Sincerely,
B
If you can please reply with the sample