I am using MS Access 2007. Can an Access application be designed so that data entry can be handwritten, not typed nor dictated?
Is there third party software to interface with the manuscript recognition and convert and insert this handwritten data into the appropriate forms in a conventional "font" display? Or, is Access able to do this without additional software/hardware?
I am making a database, where 10 to 20 users will be entering data. I have queries
1. I am planning to create a form with which user will be directly entering in the table, will that b right?
2. If 2 or more users will open form its own side does they all will be entering in same row number?
3. What will be the best of these, by insert query or directly to form?
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 ?
View 4 Replies View RelatedHi, I am using a wet and cold holiday weekend to learn about Access. I want to create a simple sales order entry function.
I have set up 2 tables Orders and Order Details. The Orders table holds order number, customer, due date, etc and the Order Details table is to hold the line items (product, quantity, price, etc). So far, so good.
I have created 2 forms and made the Order Details form a subform of the Order Header form. So far, so good.
I have 2 questions arising from this.
1. How do I get the cursor to tab from the last field of the header form to the first field of the details subform? When I get to the last field of the header form it just goes to create another order.
2. Is it possible, and if so where do I get info on how, to enter (and show) many detail lines for the one header. This is a normal sales order situation, customer stuff followed by 5 or 6 lines of products on the order.
I have two old (Windows 95) MS Access tutorial manuals, beginners and advanced but can't find the answwers there. I am using MS Access 2000.
Any help or pointers to where I can get the help would be appreciated.
BD:confused:
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 created a rather large data entry form for one of our departments which will be used to run a mail merge document. The merge is run off of a query of the form, rather than the tables themselves...I think that is what I've read is the right thing to do?
Anyways, most of it is working great so far but I've run into an issue where a few of the form fields are combo boxes. In access and in the query the data looks correct, but when you look at it in word (in edit recipient list) and after the merge, it will have a file path name instead.
So a combo box that has "Medical Plans and Visual Plans" in that field in the query, comes over saying "c:Users
ameAppData
Ex: New Hires are provided information about Medical Plans and Visual Plans.
Ex: New Hires are provided information about MeC:UsersbrooksAppData
It always shows the first two letters before putting the filepath name in there.
I have tried doing it multiple ways...a lookup to another table, lookup right in the field itself....get the same results.
I have input boxes in access form. I want to limit entry of * in one of the input fields named "Name" anyway If * is found anywhere in anyform of data entry then it should show warning.
View 14 Replies View RelatedI have a data entry form to add new records to an Access database file called Claims. An auto-incrementing sequence number (SeqNbr) needs to be kept PER YEAR. If the user enters a date the sequence number pertaining to the year of this date needs to be incremented. The first record within a new year of course takes value 1.Records can be added at random for different years.
A simple SQL-statement can be made to determine the new sequence number:SELECT max(Claims.SeqNbr) + 1 from Claims where year(this.value) = year(Claims.EventDate)...this.value meaning the value of the date control in which the user entered the date.I need to return the new sequence number to another field on the form in which also the COMPANY CODE, YYYY and MM from the EventDate, the new sequence number and the USER INITIALS are concatenated.
I am creating a simple data entry form wherein the user will enter the product id and on change the product description and retail price must be displayed.
When the order quantity is entered, the total cost need to be calculated. I am able to do this using DLookUp and simple multiplication.
However, after doing the above, I need another row to appear so that I can accomplish the same for another product.
Hi
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
Could anyone please help me out
thanks
namit
Good Day,
Is it posibble to refer data from table and using it for a application title?
I know we can used tool/startup to change a title of application but I need to combine with other data refer from table.
For example : Microsoft Access (Company Name)
+ company name is a data refer from a table company.
TQ
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.
Hi
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?
Regards
Tony Randell
Hi all..
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?
Thanks in advance.
Hello,
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?
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 :)
Hello Forum members
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.
All help is appreciated
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?
View 4 Replies View RelatedHi,
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?
many thanks,
nigel
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
View 4 Replies View RelatedMy 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?
Thanks a lot
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?
Thanks.
Does anyone know if it is possible to send an email when a button is clicked?
View 1 Replies View Related