|
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
|
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 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.
Upload an access database which connects my ASP website?
Hi there. I'm a bit of a beginner when it comes to dynamic websites. I have built an ASP site offline using my local machine as a test server. The site makes use of a Microsoft Access database. If i now want to put the site online, ie, using a Remote server as Dreamweaver calls it , how do i do it? Do i need to convert to SQL? Do i upload the MDB? Any advice would be great. My webspace supports MySQL . Thanks.
Free web hosting site for asp.net website and ms access database?
Free web hosting site for asp.net website and ms access databasei dont know what ISS mean ..sorry
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
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?
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
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 to insert date & time in ms access database using vb.net windows form?
Vb10 with access database?
i've an access database table which i included in the form, now i need to deal with each column as a separate array within the codefor example the first column is for First Namenow i want to take all the first names and copy it to the clipboard or a txt file or any such thing, how to do this?thank u in advance
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.
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
Minimize Access Database Without Minimizing Form?
I'm trying to find a way to minimize access, but have the form remain restored and focused.When i minimize access, the form goes with it and restore works similar.If easier, i would be fine having the form alone have focus, and not the whole of access so i can have the form on one side, and notepad on the other, and have focus of the form without notepad being placed behind the main access database.Any help? Do i need to make this clearer?I've somewhat made do by resizing access so that its simply out of the way... but still i would like a better way to be able to actually send access away without sending the form with it.
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?
|
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!
|
