Hello everyone. This is my first post (for not asking help :) )
I look at topics for start up options etc and I think all of this it’s ok but there is a smarmiest way to start your application. So here we go..
We make a vbs Script
Set WSHShell = CreateObject("WScript.Shell")
WSHShell.Run """C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE""/RUNTIME ""C:Documents and SettingsEvalDesktopDataBaseUI.mdb"""
And we start The Access In runtime and open your Db
Note this working with Access 2003 .If you have an other version just change the access directory “C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE”
Where is your Office Access
Then you can make a shortcut of your .vbs script and rename it ass you like
You’re Application Name. You can change the Icon (If you have a Program File’s Folder Place your icon) Right Click Properties/Change Icon
Then your app is starting in Access /Runtime and everything is fine :)
We are looking for an access based software similar to this http://www.pedyn.com/access/P2000details.htm Could any of you can guide us to get a best suit
it 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 ?
We 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 have table with the functional dependencies shown above.
I would like to know if it is in 3rd Normal Form. I think it is.
The table stores data on DVDs and Tapes.
Format = "Tape" or "DVD".
Region is either "1","2","3" or "0" (If format is DVD) or "PAL" or "NTSC" (If format is Tape).
Rarity is a rating (1 to 5) of how rare a tape or dvd is. The user uses their descretion when deciding this value, but the take format and region into account when deciding.
Price is the cost of the tape or dvd. The rarity, region, and format are considered when the user decides upon a price.
Region, rarity and format are unique, and can only appear once in the table.
Finally, Price band is the primary key of the table. It is a value used solely to identify the combination of Format, region and rarity.
Im not sure if I have done the diagram correctly. Im not sure if I need to model a dependency if it is only there because the user is using data when deciding on the value of other data.
In which case, would this be the correct diagram, and is it in 3NF?
I have a form with a textbox and a button. When the user enters in a number range, I need records to show up for only dates that are in-between and/or equal to the numbers typed in the textbox.
For example when the user types in 4-9, and pushes the button, a display of records will be displayed for only 4, 5, 6, 7, 8, 9 (if there are such records). The numbers are contained in a NUMBER field of a larger table.
This seems to be a tough question, and I've done days of research on it and can't find an answer.
Does anyone know how complicated would it be too allow the user to key in the first couple letters of the last name in the combo box & have the combo box prompt names that begin with those letters?
I thought I did this before, but I can't figure out how.
Access 2007-2010 format Form, 9 bound fields, grouped together Smart Tag = "UnitGroup"
Summary: Needing to run VBA whenever the value is changed within one (or more) of these fields. User could be placing new value (defaults at 0) or editing(changing) previous value entered.
I am not good on writing loops/next statements. But I am wanting to make an image visible to true when someone changes the value within the group.
This is what I have so far:
Dim ctlGroup as Control For Each ctlGroup in Me.Controls If ctlGroup.Tag = "UnitGroup" Then 'finds the smart tagged controls If ctlGroup Then 'if any fields within group changes value then Me.Image321.Visible = True 'show image End if End If Next ctlGroup
I don't even know if I am close with my code - clearly it is not complete and lots of holes of wonderment!! Maybe it would be easier just to use the individual even (on change) with each individual field (9).
I am operating in MS Access 2007 and unfortunately have to stick with the "out of the box" controls. I have data entries of notes in my database for "most workdays" - but not holidays or weekends. I want to allow the user to be able to edit notes for "most workdays" - but not let them pick a day to edit that doesn't have notes - by selecting them from a calendar date picker. Essentially, I want to gray-out/lock the non-workdays from editing.Is there a smart enough Active X or other control as a Date Picker that uses the results of a query to show valid/invalid dates?
I have this Access application. Now I want to see the databases and fields defined.but when I open the access file, it straight opens the access application. Then when i press Alt+F11, it opens VB Editor. Then when I click on Design mode it comes back to access in the design mode, but still does not shows the design mode for databases and reports and all.
I can remember there is one more step I need to do after getting into the design of the form.But I cannot remember that
I have done my access application. I will give it to my friends to use but dont want them to modify my program. So, plz help me to lock the design view(like some access application) so every using my program can't access it to modify.
Or who can tell me the way to hide everything in design view. Just show the interface. Eventhough when user hold "Shift" button while openning but still cant view a design view part.
I'm not goood at security in Access. Plz help me to show this problem. Thank you everyone. :)
I am developing an application in access xp (2002) and want to distribute it as a runtime application. I do not have the Office xp Developer version and thus need to buy the MS Office Developer. It is still available and if so, where can I buy it? Or can the Visual Studio Tools for the MS Office System make a runtime version from access 2002? Any help would be appreciated. Niels
hi i want to develop application in access like inventroy control.But i have no knowlege how to do it.Please guide me.I want some sample or frame to develop application in acess.Thanks in advance.
hi i want to develop application in access like inventroy control.But i have no knowlege how to do it.Please guide me.I want some sample or frame to develop application in acess.Thanks in advance.
I have created a website that includes an Access database providing a directory of manufacturers and suppliers to complement a magazine version.
The requirement now is to distribute the catalog on CD as well and the challenge is how to supply a query function?
I created a cd version of the website and it works fine - except if the user does not have Access installed the queries dont work.
I know the MS Developer Edition is the preferred route but it is very expensive for a simple application like this - does anyone know of an alternative approach?
I need to open an application when user clicks a command button...From this forum I have learnt that I can use SHELL command..but when I use this command to open an application, it opens a new instance of the application everytime...Can I bring the application to the foreground if it was already open?
I have an Access application which was written on Access 2.0. I need to run it (as is). I saw that it was possible to run it using some kind of Access 2.0 runtime environment - my client uses the following command to run the application:
Msarn200.exe application.mdb /ini application.ini
Where can I get this MSARN200? Do I have to find the Access 2.0 installation itself?
Am an ardent access user and have a small problem that am Requesting for help.
I have designed an application software using access and I would like to peddle it to a few prospective clients. I want to package it as a trial software to run for thirty days and after that if the clients is not satisfied,I want it to disable but store the data. How is this possible.
Using the MDE-menu function in MS Access it returns an error. MS Access is not able to make a MDE-file of my database. I prefer to make a runtime of my database, but surfing the internet I can not find a way to do this. Can you give me directions for this?
can a 3rd party application be run within an access window? i am looking only for Acrobat reader butr dont want it to open outside of the database. i would like to try and have it open in a window on a form only keeping it within the database itself.
if it can be done, where can i look up the info needed to achieve it?
I have an access application which is locked for edit. When ever i open this application it shows me the main menu, i want to edit this menu but it does not give me any option, even the Access File menu and toolbars are not visible. Please help
My MS 2000 Access application is crashing and returns a msg something like this: "Your Access application caused an error and Access must be closed" This occurs only when I execute some forms; always the same forms cause the problem. Somebody told me to copy the .mdb to another place in my HD and change the names of the forms. I did it and it always works well! Any good reason for that? My app is not yet splited in FE and BE. Splitting would help?
I have Access 2003 in my computer and I have developed an application which I want to share with my co-workers. But they have only Access 2000. Since MDE is only in 2003, I had to convert my 2003 application to 2000. Is there a way to secure 2000 application? I dont want anyone to change my code or import or read my code..I am not sure what is possible..Could someone please tell me how I can do that?
