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
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
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?
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.
I 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!
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.
How 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.
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?
I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
The user will be creating a new project that contains a bunch of releases. The releases have standard names which are stored in a table tbl_ReleaseNames It should be noted that the list of names is not static.
The user selects which of the releases pertains to their project and then based on their selections, new records would be created in tbl_RFP_Release and then a subsequent form would open where it would display each of these newly created releases where they could enter additional information. I thought of creating an unbound checkbox associated with each of the standard names, and then checking to see if the checkbox was checked and then creating the new records followed by opening up the new form.
I've built a PostgreSQL database for some ecology data and am trying to use MS Access 2010 to make a front-end for it.
I've created a form to display site data; it includes such fields as site ID, site name, county, state, landscape, etc. (There are more, but if I can get the idea down with a couple of these, I should be good to handle the rest). One can click through the form and see 14 pages of site details, which is fine because there are 14 sites.
What I want to do now is make a search form in which one can enter values for site ID, site name, county, etc, and somehow get the pages of the display form that match those values. It's not terribly important to me how that output looks - whether it's a list of matches that allows for clicking on a match and showing just one page of the display form, or whether it's a filtered subset of the display form pages that one still clicks through to view them all.
if there is code to write, where do I type it? Do I start my search form by making a form with the search fields as values, or is there some other way? How do I make those search fields into search boxes rather than display boxes?
Is it possible to create a form and vb procedure within that particular form (ie. an OnClose event)?
Code:
Function CreateForm() Dim Form as Form set Form = CreateForm frm.Caption = "MyNewForm" frm.Recordsource = "Stuff" 'Do other stuff to form, save and close, open form again [Forms]![MyNewForm].OnClose = 'insert sub and/or call to procedure (if possible, haven't been successful yet) End Function
During the create form from wizard process, there is a screen which gives the option of applying a style. Can this be bypassed or can a 'none' option be added.I'm new to access, so any suggestions are welcome. I think creating a form in design view will build with no syle, but how do you add fields?thanks
i have about 1500 records in my database and i want to display a bar chart for each record, i can tryed creating one but when i try adding the months it says i only can add 6 fields but i want to include each month not just 6 months in the chart, this is an on going database so in the future there will be more months added. here is the picture of the form i want to be able to show 2005 and 2006 figues in the same chart
Can someone direct me as to the most efficient way to add records to a table from a form? I have a table of members and a table of invoices and want to automatically create an invoice for each member by clicking a button on a form. Is there a way to do this using a macro, query, or do I write it in VBA?
I need to add a basic button on a form that would populate the current on-screen data in a form letter. The fields I have are name, address, city state zip and amount. I currently have the basic buttons on my form - Search, Next, Previous,Add, Delete Print Current Record. Thanks in advance for your assistance.
How do I create a new record (in the table to which the form is bound) automatically if, when the form opens, there is no record in the table that meets the criteria in the form filter?
hello, i know i have seen example from here, nome of them seems to help. My is just a simple search. i have 4 tables: Artist Name, title, country and location
all i want is create a form that has a search. I want to type the artist name and it lists the country of the artist. How to i do this. I create the command button and text box but it just does not work.
This is the code i use on the command.
Quote: Private Sub ButtonSearchForRecords_Click() Dim StringQuery As String Dim StringWhere As String StringWhere = "" If Not (TextBoxSearchName = "") Then StringWhere = StringWhere & "AND [Name] = '" & TextBoxSearchName & "' " End If StringWhere = Right$(StringWhere, Abs(Len(StringWhere) - 4)) StringQuery = "SELECT [Name], [Title], [Country], [Location] " _ & "FROM [2-75TH SCAR] WHERE " & StringWhere _ & "ORDER BY [Name], [Country]" Me.ListBoxRecordsFoundInSearch = StringQuery Me.ListBoxRecordsFoundInSearch.Requery End Sub
Hi, I have a data entry form that needs to become an invoice form. The problem I have is that the background colour prints too, tried "print data only" option, but as it says on the tin, only the data is printed. Ideally I want the formatting, field headings, but not the background colour.
Is the only option to remove the background colour? Or should I create a "print" button that runs a report for the selected record?