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 RepliesI really need to learn how to code in VBA for access. Can someone direct me to a good VBA Book?
View 1 Replies View RelatedJust 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.
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.
I allready looked at what was recommended in this forum - but I noticed there are only two books listed.
Are both of these books good for beginners or is the Access 97 Bible better? I have seen about a dozen of books and would like to have a few on hand to learn from and to reference as my skills increase.
I truly am after something that can give me a breakdown of the code in Access and what each line really means and the action it produces.
Thanks in advance,
John
Hi All,
i'm looking for a really good access book that will help me progress my access knowledge i have an okay knowledge of access and wish to expand my knowledge futher any good books out there that can help i know their is hundreds of books but does any one have first hands experience of a gr8 book they used
Thanks
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
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.
Can anyone recommend two good books which it should include the knowledge from Beginner to Advance level.
1. Microsoft Access
2. VBA to work with Access
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
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
I want to know which is the best book on VBA out there.. for Access 2003
View 3 Replies View RelatedI 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!
Hi Everyone,
I was wondering if anyone can recommend a good book for learning more about Access?
I have basic experience with the programme, but am hoping to tackle the old 'questionnaire/survey' issue. A lot of books I can find on amazon seem to be set at such a level that I can already do (multiple tables, simple queries and reports), I need something a little more in depth. Others don't seem to tackle the specific issues I'm going to face (although I could be wrong about that!). Also, as I usually don't bother with computer manuals (I generally pick up and play with new programmes) I don't know which ones are best (e.g. Microsoft own, 'Dummies' etc)?
EDIT: I'm using Access 2002.
Thanks a lot!
Bek
DOes anyone have any examples that they are willing to post or links about how to build an appointment book in Access? I have tried google but I cant seem to find useful links.
Thanks.
I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc.
How to do tht.
thnxx
I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc.
How to do tht.
thnxx
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!
Can anyone recommend a good place to upload a database so others can access it.
View 1 Replies View RelatedHere is my setup:
In Acess 97 I have a single data base with 5 tables, Attorneys, Employers, Health Care Professionals and two others. All tables have exactly the same fields.
I am trying to create a “phone book” made up of all the records in the data base. The form for this phone book has only a few fields such as fname, lname, phone, address. It also has the autonumber field. The record source for the form is a Union Query. When I open the form it works well. I get lawyers, employers, doctors , etc. all in alphabetical order.
Here is my problem:
I have a command button labeled “View Record.” I want to be able to click on this and have it find the record in its original table and open the form for that table so the record can be modified (on exiting the record I have it requery so the phone book is updated).
I can only get this to work with one table at a time, that is, the table that is named in the event procedure code. So if I am in, say, an Attorney record and tblAttoney is named in the event procedure code, all works well. But if I am in, say, an Employer record I get a blank Attorney form opened.
How can I get it to trace the autonumber to the proper table and open the record . I assume that the autonumbers are unique ACROSS all five tables since they are in the same database.
Any help would be greatly appreciated.
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 RelatedJust looking for any good places to find unique command buttons i could use in my application.
View 2 Replies View RelatedI 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
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 RelatedI 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.
hello, this is frazzling my brain i cannot comprhend the answer :confused:
sorry werent sure were 2 post this hope this is the right place
I have an array of comics 300 they come out weekly, the first is Number: 344 this came out 26th September 1983, i have a form with a combo box were i select the comic number (344 - 700+) in this case i am selecting 344 and i press a button "command 11", i would like it to display in three text fields, date, month and year. This has well an truly killed off my brain. Any help would dearly be appreciated.
Need any further information just ask.
Paul