Stylish Forms That Actually Look Good And Are User Friendly

May 9, 2006

I searched google for sample databases and most forms are rather primitive... Currently there are some features to make more user-friendly forms that I have yet to find in excess:

1. Stop updating record automatically :
For some strange reason access auto-update the records the user change in a form. What I want is to only update records when the user press the "SAVE" button. This could allows better validation without forcing the user to remain trapped in an entry.

2. Better error messages
Instead of annoying pop-up telling the user that he made an error, I want something like an ErrorProvider Component that tells what error the user made with a small symbol (!) which provides the explanation of the error when you over the mouse on it.

3. Using different formats for different columns in a datasheet form
For some reason it is not possible to assign a special backcolor for some field that are locked to indicate they are locked if you use a datasheet form. This needlessly confuses users who hammer their keyboard trying to enter info in locked fields and have no feedback ( except maybe an incredibly annoying pop-up window ) to tell them not to enter data there.

4. Better excel-style features for datasheet forms :
Good way to annoy users : prevent a way to cut and paste multiple rows/columns of information in datasheet. If you try to paste more than one column at the same time it just doesn't work.

Also why is it impossible to make the title of field to take more than 1 row ? I mean it sure looks dumb to have

Number of tax report
1
2
3
4

Instead of

Number of
tax report
1
2
3
4

View Replies


ADVERTISEMENT

User Friendly Linked Forms

Jun 2, 2006

ok can someone please explain this to me..

i linked the booking to the driver using the ids through the bookingdrivertable.

the italic fields are the ones i have included in my Query called "bookingdriverquery"

bookingtable
booking id (autonumber)
date (date/time)
time (date/time)

drivertable
driver id (autonumber)
name (text)

bookingdrivertable
booking id (number)
driver id (number)

after doing this i created a form using the wizard, choosing all the fields from the "bookingdriverquery"

when i opened my form, i hid the booking id and driver id (as they are autonumbers anyway)

i then added a date.. a time.. and a driver name.. pressed save..

the booking table had 1 record, the driver table had one record.. and the bookingdrivertable had 1 record (both the ids)

this is the outcome i wanted..

i would however like to use the booking id and link it to another table in the same way.. a customer table for example (using booking id and customer id)

i had trouble however doing this.. because to duplicate this above method means that my user will have to re-enter the same booking details on another form.. and then the customer details..

how can i link all this together.. if someone wishes ask me a question and i will try to explain.. someone help me please.

View 1 Replies View Related

Make Forms More 'User Friendly'

Dec 11, 2006

Hi,

Im coming to the final stages of designing my database - its a Uni project. For extra marks it needs to be pretty user friendly.

One of the things I would like to do to my forms - I will use the following screenshot as an example - is remove the 'X' (Close) tab from the top right but I am unsure of how to do this exactly.

I would also like to remove the grey area around the form including the record navigation at the bottom.

Could someone point me in the right direction?

Screenshot - http://img237.imageshack.us/img237/7909/screenydg1.jpg

View 2 Replies View Related

User Friendly Data Entry

Jun 29, 2006

Please Exuse the question I am about to ask. I am a bit rusty with Access and cant remember how to do the following. I have tried and tried to work it out and tried various help searches but cant get the answer I'm looking for.

What I need to do is create a data entry form, very simple! However I want the user to be prompted to enter a project name and number in order to find the project that i want the new data to be entered under. Then it will need to create a new record in that project ready for new data to be entered from the data entry form.

I hope it is clear what I need to do

View 1 Replies View Related

Null Not Allowed, User Friendly Msgbox

Jul 27, 2005

I have a table field where Null is not allowed, how do I use a user freindly message to tell the user to add data to this field. When a user tries to leave the field Null (ie by tabbing out), they get a message, "tried to assign NUl value to vaiarble which is not variant datatype.

What I want to appear is more like "Please enter a name" or some other custom message.

Any ideas - I have tried before anfd aftyer update events and vaidation rule on the form field of Not Null, but the underlying message always appears first.

Paul

View 3 Replies View Related

Need User Friendly Sorting Of A Report Using A Sort By List...

Jun 29, 2006

Ok, I am a noob at reports and did a search on this. My searching DID NOT HELP ME! I thought I would make that clear :D Maybe someone can tell me what to look at for this issue.

I need to take one report, allow the users to easily use a dropdown or listbox on a form to Sort and Group many fields of data. To recap: The user will click on name in the list and it will sort report by name. Also I need them to be able to select up to three sort criterias.

EX: Sort by Name then LastName then Company

Please guide me to the answer. Thanks.

View 3 Replies View Related

A User-friendly Way To Link Tables In A Split Database

Feb 25, 2008

Hi, all.

I have a "client/server" split Access 2003 database with an Interface file containing all the code/forms/queries and some system tables and also a Data Backend file, with all the data tables and table structure.

This is being deployed to multiple sites, each getting their own version of the backend, so sites will not be using the same backend between them all, rather multiple users in each site will all share that site's backend file.

Since users will deploy in different network locations, etc. they will have to re-link all tables. Is there a meaningful/user-friendly way of doing that without relying on user's knowledge of "Linked Table manager", etc.?

Thanks!

View 9 Replies View Related

General :: Hyperlink Friendly Field In Access

Oct 10, 2012

I'm trying to create a pdf report displaying records in a columns, with each record having its own hyperlink. Rather than displaying the actual hyperlink, which is quite long, I'd like to portray a friendly_field like in Excel (Hyperlink("Link"). Hyperlinkpart doesn't seem to do this.Is there a formula I can create in a query where I can reference each individual hyperlink but show it as a "friendly_field" such as "Link"?

View 3 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

View 3 Replies View Related

Good Practice Or Bad?

Mar 9, 2006

A developer where I am contracted to constructs his If statements like this:
If Day(Now()) <> 1 Then DoCmd.OpenQuery "qry_06c_Get_CurMon_Rebates"

Instead of like this:
If Day(Now()) <> 1 Then
DoCmd.OpenQuery "qry_06c_Get_CurMon_Rebates"
End If

All on one line and no end if needed. I didn't even know that would work.
Is this good or bad practice from a coding standpoint? Any Pitfalls?
Thanks

View 5 Replies View Related

Need A Good Tutorial

Jan 26, 2006

I have been selected to do a project by my department head. It involves programming an Access database to do various things. It has to have forms and all that good stuff. I'm trying to get the higher powers to get a web server for me to do this as a web application, but I may need to fall back on the Access idea. So I need a good tutorial on programming in an Access environment. I know it uses VB and I am pretty decent when it comes to programming with that language. What I need help with is how to do certain things like close a form using an onclick event or to print a report. There's a lot I need to be able to relearn so if anyone can point me in the right direction I would appreciate it much. I'm doing this for a Commander in the US Navy...(several ranks above me )...so I need to be able to pull this off!!

Thanks much,

JMH

View 1 Replies View Related

Good Access Book

Apr 3, 2006

I am looking for a good Access Book. At work, I have "Access for Dummies" and "Access2000 Step by Step". Are either of these good, bad, etc. What would you recommend. I am a begginner, but know some things, so I don't want something for real beginners.

View 2 Replies View Related

Can Anyone Recommend Me Some Good Books?

Dec 6, 2006

I don't want to buy something just because some guy on Amazon says it's so awesome that I have to buy this book!! :P

Anyway here are some things that I am looking at learning:

Access/VBA
SQL
Visual Basic


Any GOOD book recommendations would be great, and much appreciated. Thank you!

View 3 Replies View Related

Access Good For A Project?

Mar 5, 2007

Hello for one of my System Development Methodiology classes I have to develop something that will keep track of several projects that a local hospital has going on. We are to develop this in access and it should be able to show how far till completion a project is and several people should be able to update the database.

I usually do not use access and do not know much about it but is an access database able to be updated simultaneously and remotely? If so were could I be directed to find out more about.

View 1 Replies View Related

Good VBA Book, Any Idea?

May 9, 2007

I really need to learn how to code in VBA for access. Can someone direct me to a good VBA Book?

View 1 Replies View Related

Know A Good Guide To Query Syntax?

Sep 12, 2006

I'm new to Access and have been learning how to use it for the better part of a year. I've done all the Microsoft online tutorials relevant to the work I need to do with it, and gotten a few books out of the library besides. In general, I self-teach very well given a good resource.

Here's my problem: the main area in which I need to be proficient is running queries, and I cannot find a good, comprehensive explanation of how to construct expressions or set up calculated fields.

In case I'm not clear (I've had quite a time just figuring out what to call what I need), I'll give you an example. I was able to arrange a short tutorial with someone in another department. As part of a query, she used the following statement in the "Field" section to convert date information stored as mm/dd/yyyy into just the year:

Year: IIf([referraldate]<#1/1/2003#,"2002",IIf([referraldate] Between #12/31/2002# And #1/1/2004#,"2003",IIf([referraldate] Between #12/31/2003# And #1/1/2005#,"2004",IIf([referraldate] Between #12/31/2004# And #1/1/2006#,"2005",IIf([referraldate] Between #12/31/2005# And #1/1/2007#,"2006")))))

This is the kind of thing I want to learn how to do. Unfortunately, the Microsoft tutorials don't do much more that give examples of different expressions and functions; I feel like I've been given a handful of sample sentences, a few nouns, and a few verbs--and then told to go speak English.

What I need is a comprehensive guide that not only gives me the building blocks of expressions, but tells me how to combine them into a syntactically meaningful statement--so I know what order things go in, where commas and parentheses should be, etc. Both online or print materials are fine--I've been looking on my own, but with no luck.

Thanks for your help!

View 5 Replies View Related

Good Place To Share Database.

Dec 3, 2004

Can anyone recommend a good place to upload a database so others can access it.

View 1 Replies View Related

Is Access A Good Idea For My Project?

Feb 13, 2007

Hi! I have a client who wants a training tracking software built that will allow for simultaneous use by up to 850 users. Is Access a good idea, or should I use SQL, and if yes to SQL, can you point me to some great documentation supporting this? Thank you, thank you, thank you!

KellyJo

View 3 Replies View Related

Any Good Links For An Auto DB Admin Prog

Jun 9, 2006

Does anyone have an updated link to a free utility download that will auto create a backup of my database as well as do a compact and repair at a scheduled time each week. Maybe twice a week if possible! :p

View 5 Replies View Related

Can Anyone Suggest Some Good Access Aptitude Tests

Jul 19, 2007

In my current, new position, I have been asked to look into the possibility of finding out if there exists some good tests available to test how much skill someone has with Access.

Do you know of any existing tests or websites that do testing like that? If not, I may have to create one for us, but I didn't want to have to totally reinvent things if something good already exists.

Also, if something doesn't already exist, maybe we could get some people here to contribute to a thread with potential questions to ask.

View 6 Replies View Related

Any Good Book That Have Examples Of Code, Function, Etc

Feb 15, 2008

Just wondering if anyone new of any books that contain examples of code, functions, syntax, etc. I would like to have a good reference that I could go to instead of searching the internet everytime I need to try something new.

Thanks in advance.

View 6 Replies View Related

Good Sights For Command Buttons And Other Images

Feb 25, 2005

Just looking for any good places to find unique command buttons i could use in my application.

View 2 Replies View Related

Looking For Good Tutorial On Feeding A Site With A Database.

Oct 25, 2004

I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come across ADO several times. Is this similar to what I am looking for? Thanks.

View 5 Replies View Related

Good Or Bad Idea? Text Box In Main Table Or Other?

Dec 1, 2004

I would like to add a textbox to my main form so that users can enter in some extra data regarding the job they are working on. This text box should tie to the current record of the main database, tableJobLog.

Is it best to keep this textbox as a field in the main database, tableJobLog? Or should I create a separate table (perhaps tableJobNotes) with just this text field and link the two tables?

I would think that having it in the main table would make the table grow considerably in size after some time.

If creating a separate table is better, I would need some guidance on how to do this.

Thank you very much.

View 2 Replies View Related

Is Trimming Field Size Where Suitable Good Practice?

Jun 6, 2007

If I have a DB with several tables containing thousands of records, and most of those records only ever need say 8 characters, does anyone know if changing the field size from default 255 chars to 8 chars will actually benefits the the DB?

Potential benefits I'm thinking may occur are reduced filesize and maybe some speed?

View 3 Replies View Related

Setting Up Good Report Menus For End Users - A Lot Of Reports!

May 25, 2005

I am working on stream lining reports for my application, so that I don't have a huge maze of menus.

I am open to any ideas of how to best set this up. Right now I have a report menu with about 8 command buttons. Some take them to a criteria form for that report, others straight to the report, and others to another menu with a whole other set of buttons for more reports.

I have looked at organizing the "categories" of reports that I have.

I see that I have Candidate reports and Hire reports. This is because this application is for people who apply for a job. Once the information is entered on the entry side, there are a number of things to report on.

One idea is to make a statistics report menu for all of the summary reports. These are counts of candidates under certain groups, like what office they applied to, what departmen, or what date they applied. Then these counts exist for hires as well, and what they were hired to, and what date they started.

I also have detail reports showing the people information as candidates or hires, grouped by these such factors.

If anyone can help me to organize the best method for making these reports available to the user, I would really appreciate it.

One thought would be a form with 2 combo boxes and a preview button.

I am thinking that this could work for the statistic report menu. My database is normalized, so I can't use their names in the combos. I would want to have 1 combo for choosing candidate or hire, as that report that they want. Then the next combo would be the factor to report them on. Office, department, application source, etc

I have summary report for candidates and for hires. parallel reports, but one for (ie) all candidates by the office that they applied to. Then I would have one for all hired candidates (were hired) by the office that they were hired to. Same with department, and many others.

If anyone can help me to either how best to do this process, whether my thought is a good way to go, or if there is a better set up that I should try. I am open to anything here!

Thanks. :D

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved