|
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
|
Read/write access 2007 database using Visual Basic 6.0 standalone?
Hi,Is it possible to manipulate an MS Access 2007 database back end file from an executable created using the separate MS Visual Basic 6.0 development package? If so, What are some of the basic commands required to read write to the database file etc?Thanks,Kyle
Help with access 2007 database?
hi i have made a database with all my data in it about car models and there spec. i want to provide it for people to use. but how do i get it so they can just search the make and model of the car and for it to come up with the rest. i know you can query it but i want a friendly gui which they can search the database so they dont screw up my database. help pleasi work for a company and the databse will be held on the server and the workers will be able to access it. but i want to know how to put a gui on the front of the database for them to search it.
How do I make access 2007 database view only for other users?
I have access 2007, and I am trying to limit other users to view the records only, but not to delete, add, or edit records. How can I do this?
In access 2007 database, how do i get the fields to move individually?
In office 2003 i can move the fields where i want them to go thus designing my form the the way i want it, but in 07 they are grouped and move as a group when i try to move them individually.
Help with ms access 2007 database?
if you want to your database to preform optimally, you should use " compact and repair database" tool on a regular basis.is this true or false?
How do i create the sequence in which forms appear on my access 2007 database.?
i created a database but i want the login form to appear first and not lead to any other forms but i dont know how to go about it. i also dont know how to create other sequences.
Retrieving images from an access 2007 database into an asp.net web form?
i have uploaded images in the ms access data base with hyperlink datatypethe following is the code for uploading the image and saving it to the database in th form of hyperlink> > Dim myfilename As String Try If fileUploadPath.HasFile Then If cmbCategory.SelectedIndex 0 Then myfilename Server.MapPath " photoGallery model portfolio" & fileUploadPath.FileName ElseIf cmbCategory.SelectedIndex 1 Then myfilename Server.MapPath " photoGallery product" & fileUploadPath.FileName ElseIf cmbCategory.SelectedIndex 2 Then myfilename Server.MapPath " photoGallery nature" & fileUploadPath.FileName ElseIf cmbCategory.SelectedIndex 3 Then myfilename Server.MapPath " photoGallery gray world" & fileUploadPath.FileName Else myfilename Server.MapPath " photoGallery wild life" & fileUploadPath.FileName End If ' myfilename Server.MapPath " photoGallery " & fileUploadPath.FileName ' MsgBox myfilename fileUploadPath.SaveAs myfilename ' MsgBox " Success" End If Catch ex As Exception MsgBox ex.ToString End Tryi would like to display the image which is in string format i.e hyperlink on my web formwhat can i do?i am using asp.net 3.5 with access 2007 any help will be obliged thanx in advance
I have changed computers with my access 2007 database and now the code won't run?
I have a database that was created in an earlier version 2002. I have used it for years on several different computers and windows platforms. I switched computers at work, both Windows XP Pro but now the database is full of errors and the code won't run? I took the database and tried it at home on my computer and it works fine. Any ideas?I figured it out this must have been a pretty tough question for all the gurus
How can i connect my Microsoft Office Access 2007 database to my .aspx page?
How can i connect my Microsoft Office Access 2007 database to my .aspx page? what are the things needed to configure the web.config?i was trying to drag and drop the table , but it couldn't.
Access 2007 database? HELP!?
I have to make a database that includes the following participants in the CPR and First Aid training. I have to hide the address line 1, city, state, and zip fields. Sort by last name. This is the information I was given...Saturday, March 20, 2010 Coweta Meeting Room 9 00 a.m. 3 00 p.m. Participants Then it list four different participants with their title, first name, last name, street address, city, state, zip Saturday, March 27, 2010 Ogelthorpe Meeting Room 8 30 a.m. 2 30 p.m. Then it list four more different participants ect..I dont know what its asking me to do? I know I have to create it in Access 2007. But what do I do with the headings? Saturday, March, ect.
Is it even possible to create a login form for an Access 2007 database?
I've been searching all over the internet, Youtube and in books for a solution but can't seem to find one that actually works.I have a database on Access 2007 with multiple tables. Basically I want users to be prompted to insert a username and password before being given access to the switchboard with links to all the other forms.I have found line after line of code online but nobody has actually said whether it works or not. I can't find a definite answer anywhere. I can find solutions for 2003 and older versions but NOTHING for 07.Help
Please - I really need helping building a super-simple Access 2007 database?
All I need is the Student Database template stripped down with just one table Students and one form Student Details . I'd like to retain the ability to click New and Open on the table.In other words, I need to get rid of the tables Filters, Guardians, Settings, Student Attendance, Students and Guardians all of the queries the forms Attendance Subform, Filter Details, Getting Started, Guardian Details, Guardian List, Guardians Subform and finally all of the reports.Rather than deleting this off the template which is difficult because it's all connected , I think it would be easier to build one from the ground up, but I have no idea how to This program is really tricky if you don't know Basic Please help me. This is for my job and my boss and coworkers are counting on me to finish it.
How do you link an Access 2007 Database to a Visual C# 2008 Application?
I am trying to create an information system where the user can look up an " Employee's" information by typing in the " Employee Number" and clicking a " Find" button. Once the find button is clicked the remaining information for the employee searched for should appear in its appropriate textbox. Let me know if you are confused about my question. Thanks.
How can I connect to an MS Access 2007 Database stored on another computer?
Ok... here is the challenge.I have computer1 and computer2 both running Windows XP Pro i believe . From computer1 I can connect to computer2 using the remote desktop feature. This leads me to believe I should be able to create an ODBC or a data connection that can connect to computer2. I need computer1's access database to collect data from computer2's access database on a regular daily basis.The access database cannot be saved on a mutual network drive because they are not on the same network. The access database cannot be transmitted on any type of web server installed on computer2. I do not have Administrative rights on computer1 nor do i have admin rights on computer2The only makeshift solution I can come up with... is to write something in VB in access to query data, create a CSV file and email it to myself from computer2. Then on computer1 create something in VB in outlook that auto downloads attachments to computer1's hard drive. Then I would write something in VB in access to import the CSV file. As you can tell... i don't want to do this, but I have certain limitations that might prevent me from an easier method.Any ideas?
|
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!
|
