My account: Login | Sign Up
Loading... 

Auto fill Data on a form in microsoft.public.access.forms | Thread profile

Thread profile page for "Auto fill Data on a form in microsoft.public.access.forms" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Auto fill Data on a form in microsoft.public.access.forms", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity, which are reported in a table below. Additional thread profile information is also shown in the following ways:

1) Top Contributing Authors
2) Related Threads on "eBay Auctions"
3) Related Threads on Other Sites

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a thread's popularity and/or exact posting volumes at any given reporting period.
Title: Auto fill Data on a form in microsoft.public.access.forms
Site: Discussions in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile
Forum: microsoft.public.access.forms  microsoft.public.access.forms - forum profile
Total authors: 4 authors
Total thread posts: 7 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Thread posts in Auto fill Data on a form in microsoft.public.access.forms:

1. 
Started 1 month, 3 weeks ago (2008-10-09 08:36:00)  by Ed-Masto
Hello: I have what seems to be a very simple request for help. I have a customer table (with address info, etc) and a sales order header table and a sales line table. When creating a new order, the first field to be completed is the customer number (which is a lookup to the customer table). After the customer ...
Size: 942 bytes
Customize:  Customize "Auto fill Data on a form in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
2. 
Started 1 month, 3 weeks ago (2008-10-09 10:08:00)  by NetworkTrade
ok first - database best practices is that you don't need any duplicate info - just put in the valid cross reference field value for that customer into your sales record. second - this requires you work via forms and not directly in the table themselves...because one can load the vb to do this autowriting into a form but can ...
Size: 1,820 bytes
Customize:  Customize "<b>Reply 1</b>: Auto fill Data on a form in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
3. 
Started 1 month, 3 weeks ago (2008-10-09 10:40:00)  by Ed-Masto
Thanks for the reply. First, I agree that there is no need to duplicate information, but sometimes the address info needs to be changed for just one order. Therefore, I cannot just get the address information from the customer record every time the order prints. I am not a very good vb code jockey. Can you please just give ...
Size: 2,677 bytes
Customize:  Customize "<b>Reply 2</b>: Auto fill Data on a form in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
4. 
Started 1 month, 3 weeks ago (2008-10-09 11:17:00)  by John W. Vinson
On Thu, 9 Oct 2008 08:37:02 -0700, Ed-Masto <Ed-Masto@discussions.microsoft.com> wrote: >Hello: > >I have what seems to be a very simple request for help. > >I have a customer table (with address info, etc) and a sales order header >table and a sales line table. > >When creating a new order, the first field ...
Size: 2,086 bytes
Customize:  Customize "<b>Reply 3</b>: Auto fill Data on a form in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
5. 
Started 1 month, 3 weeks ago (2008-10-09 11:30:00)  by NetworkTrade
like this in the AfterUpdate event of the combobox that is looking up the customer...and presuming that combobox has several fields such as Name, Street, City, etc. Me.NameField=me.CustomerCombo.Column(2) me.AddressField=me.CustomerCombo.Column(3) me.CityField=me.CustomerCombo.Column(4) that's the idea.......
Size: 3,423 bytes
Customize:  Customize "<b>Reply 4</b>: Auto fill Data on a form in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
6. 
Started 1 month, 3 weeks ago (2008-10-09 12:24:00)  by Ed-Masto
I see. Thanks! That looks pretty easy. Lemme give it a whirl. ;) "NetworkTrade" wrote: > like this in the AfterUpdate event of the combobox that is looking up the > customer...and presuming that combobox has several fields such as Name, > Street, City, etc. > > Me.NameField=me.CustomerCombo.Column(2) > me....
Size: 3,892 bytes
Customize:  Customize "<b>Reply 5</b>: Auto fill Data on a form in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
7. 
Started 1 month, 3 weeks ago (2008-10-09 13:35:00)  by Klatuu
If the Ship To address needs to be changed from time to time, you need an additional table to handle ship to addresses. That would include the customer's default Ship To address. The order header table should then have a foreign key field that points to the correct address record. Then in your form, you could add an additional ...
Size: 3,891 bytes
Customize:  Customize "<b>Reply 6</b>: Auto fill Data on a form in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
 

Top contributing authors for Auto fill Data on a form in microsoft.public.access.forms

Name
Posts
Ed-Masto
3
user's latest post:
Auto fill Data on a form in...
Published (2008-10-09 12:24:00)
&nbsp; I see. Thanks! That looks pretty easy. Lemme give it a whirl. ;) &quot;NetworkTrade&quot; wrote: &gt; like this in the AfterUpdate event of the combobox that is looking up the &gt; customer...and presuming that combobox has several fields such as Name, &gt; Street, City, etc. &gt; &gt; Me.NameField=me.CustomerCombo.Column(2) &gt; me.AddressField=me.CustomerCombo.Column(3) &gt;...
NetworkTrade
2
user's latest post:
Auto fill Data on a form in...
Published (2008-10-09 11:30:00)
&nbsp; like this in the AfterUpdate event of the combobox that is looking up the customer...and presuming that combobox has several fields such as Name, Street, City, etc. Me.NameField=me.CustomerCombo.Column(2) me.AddressField=me.CustomerCombo.Column(3) me.CityField=me.CustomerCombo.Column(4) that's the idea.... -- NTC &quot;Ed-Masto&quot; wrote: &gt; Thanks for the reply. &gt; First, I agree that there is no need to...
John W. Vinson
1
user's latest post:
Auto fill Data on a form in...
Published (2008-10-09 11:17:00)
&nbsp; On Thu, 9 Oct 2008 08:37:02 -0700, Ed-Masto &lt;Ed-Masto@discussions.microsoft.com&gt; wrote: &gt;Hello: &gt; &gt;I have what seems to be a very simple request for help. &gt; &gt;I have a customer table (with address info, etc) and a sales order header &gt;table and a sales line table. &gt; &gt;When creating a new order, the first field to be completed is the customer &gt;number (which is...
Klatuu
1
user's latest post:
Auto fill Data on a form in...
Published (2008-10-09 13:35:00)
&nbsp; If the Ship To address needs to be changed from time to time, you need an additional table to handle ship to addresses. That would include the customer's default Ship To address. The order header table should then have a foreign key field that points to the correct address record. Then in your form, you could add an additional combo that would allow you to either select an existing ship to or create a new one. You would need...

Link a excel form to data in Access in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Link a excel form to data in Access in microsoft.public.access.forms
Link a excel form to data in Access in microsoft.public.access.forms
Conditional data entry access to fields in forms in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Conditional data entry access to fields in forms in microsoft.public.access.forms
Conditional data entry access to fields in forms in microsoft.public.access.forms
Error 424 in Auto Fill in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Error 424 in Auto Fill in microsoft.public.access.forms
Error 424 in Auto Fill in microsoft.public.access.forms
Auto-fill in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Auto-fill in microsoft.public.access.forms
Auto-fill in microsoft.public.access.forms
How to make automatically fill in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile How to make automatically fill in microsoft.public.access.forms
How to make automatically fill in microsoft.public.access.forms
How can I add a report preview to a Microsoft Access 2003...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile How can I add a report preview to a Microsoft Access 2003 form? in microsoft.public.access.forms
How can I add a report preview to a Microsoft Access 2003 form? in microsoft.public.access.forms
Microsoft Access Combobox with SP3 in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Microsoft Access Combobox with SP3 in microsoft.public.access.forms
Microsoft Access Combobox with SP3 in microsoft.public.access.forms
How can i configure a Crystal Report Viewer in microsoft...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile How can i configure a Crystal Report Viewer in microsoft access fo in microsoft.public.access.forms
How can i configure a Crystal Report Viewer in microsoft access fo in microsoft.public.access.forms
Creating Lookup Fields with Microsoft Access 2003 in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Creating Lookup Fields with Microsoft Access 2003 in microsoft.public.access.forms
Creating Lookup Fields with Microsoft Access 2003 in microsoft.public.access.forms
Linked data entry/edit forms - Combo box auto fill...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Linked data entry/edit forms - Combo box auto fill problem in microsoft.public.access.forms
Linked data entry/edit forms - Combo box auto fill problem in microsoft.public.access.forms
Fill Lines after Data for Access 2003 in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Fill Lines after Data for Access 2003 in microsoft.public.access.reports
Fill Lines after Data for Access 2003 in microsoft.public.access.reports
Microsoft Access Importing Data in...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile Microsoft Access Importing Data in microsoft.public.access.gettingstarted
Microsoft Access Importing Data in microsoft.public.access.gettingstarted
Microsoft Access Data Base (Auto Date/Time Stamp) in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign - site profile microsoft.public.access.tablesdbdesign - forum profile Microsoft Access Data Base (Auto Date/Time Stamp) in microsoft.public.access.tablesdbdesign
Microsoft Access Data Base (Auto Date/Time Stamp) in microsoft.public.access.tablesdbdesign
Exporting access v1 data to access 2007 in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Exporting access v1 data to access 2007 in microsoft.public.access.externaldata
Exporting access v1 data to access 2007 in microsoft.public.access.externaldata
Linking SharePoint data to Access - Access File become...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Linking SharePoint data to Access - Access File become corrupted. in microsoft.public.access.externaldata
Linking SharePoint data to Access - Access File become corrupted. in microsoft.public.access.externaldata
Analyzing data in Access in...  Discussions in microsoft.public.office.access.forms - site profile microsoft.public.office.access.forms - forum profile Analyzing data in Access in microsoft.public.office.access.forms
Analyzing data in Access in microsoft.public.office.access.forms
Tagging FLAC data from Microsoft Access data  Slim Devices : Community : Forums - site profile Ripping / Encoding / Transcoding / Tagging - forum profile Tagging FLAC data from Microsoft Access data
Tagging FLAC data from Microsoft Access data
Microsoft Access Data Base in microsoft.public.access  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Microsoft Access Data Base in microsoft.public.access
Microsoft Access Data Base in microsoft.public.access
Using Active Directory Data in Access in...  Discussions in microsoft.public.access.odbcclientsvr - site profile microsoft.public.access.odbcclientsvr - forum profile Using Active Directory Data in Access in microsoft.public.access.odbcclientsvr
Using Active Directory Data in Access in microsoft.public.access.odbcclientsvr
Exporting data from Access to the specified sheet of...  Discussions in microsoft.public.access.macros - site profile microsoft.public.access.macros - forum profile Exporting data from Access to the specified sheet of Excel in microsoft.public.access.macros
Exporting data from Access to the specified sheet of Excel in microsoft.public.access.macros