|
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
|
How to import an ms access database into oracle application express?
Hi,i'm having trouble importing a file from access to oracle express application, i'm using my browser to open oracle.it would help if you could give me detailed steps on how to import the database because i wouldn't want to create it all over againthnx...
How to build an access database?
I need to match regular prices to sales prices for 50 items in several different stores in cities across the country. All together, I'd have about 110 columns. We'd like to build a database for this, but I keep getting an error message saying " The number of fields from your table exceeds the maxiumum width in Access" . Surely Access can handle lots of data that's what it is for, right? I'm a novice at Access can someone help?
Message box when closing an access database?
I want a message box to appear when the database is closed to say remember to back this database up. I havent got a clue how to do it. any suggestions? Thanks
How can I make a calendar box in access database?
I need to make a calendar box in access table. How can I make it? I want a field in my database named calendar and just need to click and open s a calendar to I click in the day I want.
How to insert date & time in ms access database using vb.net windows form?
C# syntax error with access database connection?
So here is my code private void btnSubmit Click object sender, EventArgs e string strTag textBoxTag.Text string strAge textBoxAge.Text string strGender textBoxGender.Text string strExpenditure textBoxExpenditure.Text string strPlayHours textBoxHours.Text string SQLString " " SQLString " INSERT INTO tblXbox GamerTag, AgeYears, Gender, Expenditure, PlayHours VALUES '" strTag " ','" strAge " ','" strGender " ','" strExpenditure " ','" strPlayHours " " OleDbCommand SQLCommand new OleDbCommand SQLCommand.CommandText SQLString SQLCommand.Connection database int response 1 try response SQLCommand.ExecuteNonQuery catch Exception ex MessageBox.Show ex.Message database.Close Every time I try and submit my data however I keep getting the same error saying Syntax error in string in query expression " ' Any help from the coding community?
What is relationships in access databases?
people in my IT class talk about relationships and they share data around tables but i really dont understand them. how do they share data? does it mean when you insert data into one table it automatically gets put into another or something? how do they share data? what are they for? any advice and explantation on them would be great, thanks.....
Import excel data into access database in vb6 without enabling macros of excel..?
Hello... I am working on a application in vb6 but i am not able to import excel data in my access database through coding.. I have searched alot but didn't get any proper solution.. And one more thing i don't want to enable macros in excel just want to import data in access through vb6.. So can anyone help me with coding..?
How do I find the total using access database?
I have data in a table. I want to find the total number of deliveries per month using access. What is the formula? I added the sigma sign but dont know what to do from here.
Design and implement using an access database,a login facility which opens an ms word file?
Please tell me how to add any record in access database using c# form please give me code with explanation?
C sharp with DataBase
How to access database in SQL server from ASP website?
I was trying to connect database in SQL Server 2008.the error shown is Cannot open database " signature" requested by the login. The login failed.Login failed for user 'IIS APPPOOL DefaultAppPool'where " signature" is the name of database
How would you check in vb 8 if the data in the form is same as the data in the MS ACCESS database ?
i am trying to use the data retrieved from access database to process it and update columns back in the database. what is the code to do something similar?
Access database and visual basic help?
I have access database datainfo contain 4 rows ID ,Name ,Phone and Address .I want to build visual basic for it with 4 textboxes and a button for adding or saving new data from visual basic form to access ?please help
|
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!
|
