|
Type keyword or phrase to search:
My Articles...
Resources
I have other resource websites and social networking sites for you to browse...
Blog, articles, video tutorials
Access Database
Tutorial Blog
Contact me on Twitter
@benbeitler
|
Need access database help on a order system?
hi all, im in the process of building a order database. Im just a bit confused on the invoice so im hoping people can give some suggestions. Well the database is for a take away food place. Because its a take away the customers are completely random with no names, address etc. added so i only have customer number in the customer table. the customer table is relationed with an Orders table which he customer number is the foreign key. The orders table is connected to a order details table. so my question is that im a bit confused on how my invoice will come because when i was looking at the northwind example in access theres customers names, addresses etc. so would i just create the invoice based on the customer number in the customers table?i hope i explained it ok any suggestions and help are most appreciated
Basic access database help??
i want to make a search form on my sitei want the user on my site to be able to search for location.type.priceall 3 or a mix and matchso after the user makes there deceision i want a results page to come upcan i do this in access?? the search crap is set up already on my site but i have to link it to a database looking for an easy program i am a rookie to this but i am also a rookie to web site design and keywords and i am on the 1st page of yahoo and google making more than i am putting out money wise so to all of you ppl who wont evan attemp to help the rookie get over it stuff is easy to learn if you want to so some beginer helpthanks
Stock access database help?
ok i am building a database where it has orders and stock. so far i have dont the orders bit and im stuck on the stock bit. i created an update query to delete stock from " quantity" of a item sold when i click a button in the orders form eg. write order in form and click the update stock button i made and a parameter to enter order id then the stock table gets updated.what i want to know is is this the right way of going so far?and i have a " quantity to order" field in the stock table and a " Order limit" field. What i want to happen is when the " order limit" has gone through in the " current stock level" i want a message or summin 2 say that the order limits reached and then a report can be made to show what needs to be ordered for it. or is this a bad idea?hopefully i dont need 2 program and all suggestions are very much apprieciated.thank u to all who answer
Basic access database help??
i want to make a search form on my sitei want the user on my site to be able to search for location.type.priceall 3 or a mix and matchso after the user makes there deceision i want a results page to come upcan i do this in access?? the search crap is set up already on my site but i have to link it to a database looking for an easy program i am a rookie to this but i am also a rookie to web site design and keywords and i am on the 1st page of yahoo and google making more than i am putting out money wise so to all of you ppl who wont evan attemp to help the rookie get over it stuff is easy to learn if you want to so some beginer helpthanks
Microsoft access database help. I have created a command button that opens a subform.?
For each new entry I want the subform to store separate data for the corresponding entry but it seems to always store the same data for every entry. How do I fix this?Here is the code Private Sub Command270 Click On Error GoTo Err Command270 Click Dim stDocName As String Dim stLinkCriteria As String stDocName " Payment History Subform" DoCmd.OpenForm stDocName, , , stLinkCriteriaExit Command270 Click Exit SubErr Command270 Click MsgBox Err.Description Resume Exit Command270 Click
Access database help please?
One of the forms on my access database has no related query or table. I need to retrive the data from this form from my database. Do I need to create a related query table to the form and if so how do I do it. Thanks in advance
Access database help needed?
Dear All,I have one excel sheet where I put items of super market,each item have details like brand name ... ingredients ... barcode etc.I want to make database in access ... i have imported that excel file.Now I want to accomplish two things,one is that if someone write barcode which is already entered then it should not make duplicate ... instead it will open previously entered dataSecond thing is that typing ingredients is huge pain ... if somehow I can make it easier ... like previous records have term VITAMIN, WATER, SALT, SODA, CREAM etc. So if it will autocomplete the words.Thanks in advanceThanks micky...it did solved my problem...now 2 last things...1st is my barcode initial zero is not coming and 2nd is that I dnt want client with back end to delete any record but they can modify.
Access Database Help?
Hi, I wonder if any one out there can help me out?I have an access database with a list of codes I would like to run a report to show the entries against each code. However on the report I would like it to show a name in place of the code based on the first few letters of the code.For example There are many codes beginning with CCAD, every time a code beginning CCAD is found I would like it to show the word 'Apples'. Every time the code LLHG appears I would like it to show 'Oranges'.I can't do a simple find and replace on the data as we need to maintain the original code information and we also need to be able to produce the report as needed without going through a find and replace to update any new records.Any help would be greatly appreciated as I have a mental block with this one.Many thanks,
MS. Access Database help please!?
Hi i just started an Indoor Soccer league and im trying to make a database with Access, ive done some of it but im still having trouble on the relationships between the tables and i need help on making a table for Teams to keep track of their points and goals and players and also a table for players to keep track of the goals and red, yellow cards of each player also there are two divisions first and second, each with 8 teams i want to have it all together if someone could help me. give me ur email and ill send u my database so you can see it and help me fix it plz.. i rlly need it
Access database help required urgently!!!?
I just copied a load of info from excel into access. Me not being very hot on access had the existing files highlighted when I pasted. Now the previous records are gone and I can't recover it Is there a way of doing it? Please don't tell me i have to input over 1000 records again??
Access database help please?
I work in an office that five employees have a share drive. Everything we input in this share drive in Access database saves automatically in all computers. Once one of the employees deleted half of info by accident and we all lost that. We have a backup box and a flash drive. I have kept copies in these disks for myself. But, as soon as I insert the backup box or flash drive, it automatically updates from our share drive. So, last time after one of the employees lost half of the database, I thought I could use the flash drive or back up box. But, as soon as I inserted those in the computer they get updated from the sharedrive, with half of info gone. So, what is the purpose of saving? How can I stop the backup box and flash drive from saving automatically? I even gave the files in backup box and flash drive a different name, still it got updated automatically. Why does it save on file that has a different name?
MS Access Database help!!!!!!!!!?
I am designing one database in MS access with VBA form for input. There is one field in input form where i need to fill the time when customer request comes. I need to integrate this input with my system time so that automatically it will take that time... HOw to do that??? PLzz..... guide me guys.
Sharing an Access database - help please?
We have a small office with 3 computers who have access to a small network for shared files. We run from Windows Vista they have assured me we will get used to it We need to set up a customer database and am looking to by MS Access can we buy one copy for the administrator computer and the created database sit on the network as " read only" for the other 2 to access? Or do we have to install it onto all 3 computers which will mean 3 licences? Hope you can help simple language please Thanks can I just install the Access part? And will it work with Vista? Or do we still need to buy one copy of MS Access?Thanks
Access Database help?
i'm making a access database project for my college project, where i've created a shop. i've got the database working but i can't get my invoice ID to be a autonumber because it's a forign key in another table with a one many relationship. is there any way i can type some code it to automatically find the next avalible numberalso is there any way i can make the form default to being a new record when i open them?thanks
|
Books
The following books are my personal recommendations for all levels of Access database users and developers.
Enjoy!
Access 2007
- Dummies
This is a great book for beginners. It takes you through from the very beginning without too much jargon 'computer' talk and adds a little humour to your learning.
This is one of my favourites and is a starter recommendation for my students.
Access 2010 Bible
Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology.
You’ll want to keep this soup-to-nuts Access reference close at hand!
Access 2007 VBA
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object–oriented programming and ADO. Two comprehensive case studies presents you with the hands–on experience in building real–world solutions using the concepts covered in the book.
It's the one I use as a reference for VBA students!
|
