Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 25-06-2009
Member
 
Join Date: Oct 2008
Posts: 79
How to Automatically access the fields of an Access 2007 forms

I'm trying to figure out how to get Access 2007 to fill in one field based on what is put in another field that means it would be automatic that if it has been updated on one field of a sheet,then it should be updated on the other desired filed. I am trying to format a form in Access where users could check off a box and have the home address.
Reply With Quote
  #2  
Old 25-06-2009
Member
 
Join Date: Dec 2008
Posts: 202
Re: How to Automatically access the fields of an Access 2007 forms

AutoFormats in Access 2007 let you do more than just apply an existing format, however; you can choose which elements of an AutoFormat to apply, create new AutoFormats to match the formatting of an existing form or report, or modify an existing AutoFormat.
  1. Open the form or report you want to format in Design view.
  2. Click the Arrange tab.
  3. Click the AutoFormat group.
  4. Click AutoFormat Wizard.
  5. Click the AutoFormat you want to customize.
  6. Click Customize.
  7. Select the Create A New AutoFormat option and click OK.
  8. Type the name of the new AutoFormat in the New Style Name dialog box.
  9. Click OK to close the New Style Name dialog box.
  10. Click OK to close both the Customize AutoFormat and AutoFormat dialog boxes.
Reply With Quote
  #3  
Old 25-06-2009
Member
 
Join Date: Jan 2009
Posts: 143
Re: How to Automatically access the fields of an Access 2007 forms

You may place any number of combo boxes on your form as per your requirement.
---------------------------------Employee Combo Box---------------------
Properties
Name: Combo1
Control: Employee
Row Source: SELECT * FROM ...................(Table name VBA)
Combo1_AfterUpdate()
Me.Combo2.Requery
(and the below you may use the function on which you want to update the field)
------------------------------------------------------------------
Reply With Quote
  #4  
Old 25-06-2009
Member
 
Join Date: Jan 2009
Posts: 99
Re: How to Automatically access the fields of an Access 2007 forms

you can apply one of the AutoFormats installed with Access, Access provides a convenient spreadsheet-style datasheet view for entering data into form, it isn?t always an appropriate tool for every data entry situation.You can change the appearance of individual elements in your Office Access 2007 objects, but an easier way to change the format of an entire form or report at once is to use an AutoFormat that is included with Access. If you?re working with users you don?t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Automatically access the fields of an Access 2007 forms"
Thread Thread Starter Forum Replies Last Post
In Access 2007 I need to combine multiple tables into 1 having identical fields djbbenn Software Development 4 09-05-2012 09:21 PM
Access 2010 file in Access 2007 gives Unrecognized Database Format Roakman MS Office Support 3 11-12-2010 11:45 PM
Mouse wheel does not work properly in forms of Access 2007 mahaFEB Windows Software 5 30-11-2010 11:21 PM
How to add two fields in ms access? lootera Windows Software 3 03-09-2009 09:18 PM
Access does not allow Primary key with two fields Reckon Networking & Security 2 16-06-2009 03:48 PM


All times are GMT +5.5. The time now is 06:30 PM.