If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Mark Davou

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-10-12, 12:59
Mark Davou Mark Davou is offline
Registered User
 
Join Date: Aug 2012
Posts: 2
Exclamation Mark Davou

Hello, everyone. I want to write a code, to link my Database table with my VB forms i designed. And also it should enables me to delete any wrong record entered. Waiting for your responce please...
Reply With Quote
  #2 (permalink)  
Old 08-12-12, 18:11
Missinglinq Missinglinq is online now
Registered User
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,237
In Form Design View
  1. With the Form itself selected, Go to Properties - Data
  2. Use the dropdown arrow to set the Record Source to the appropriate Table or Query
  3. Now, Select a Control
  4. Go to Properties - Data
  5. Use the dropdown arrow to set the Control Source to the appropriate Field
  6. Repeat Steps 3-5 for each Control

If the Form is based on a single Table, it should be editable, allowing Additions, Deletions and Edits.

If the Form is based on a Multi-Table Query, it may or may not be editable. If the Form proves to be Read-Only, you may have to go to a Main Form/Subform scenario.

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #3 (permalink)  
Old 08-13-12, 06:08
Mark Davou Mark Davou is offline
Registered User
 
Join Date: Aug 2012
Posts: 2
Thumbs down

tanks so much, missin....
Reply With Quote
  #4 (permalink)  
Old 08-15-12, 09:39
Missinglinq Missinglinq is online now
Registered User
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,237
Glad we could help!

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On