Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Microsoft Access Expert 23
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   7 years ago

Microsoft Access Expert Level 23 is 1 hour, 40 minutes long. In this class we will build a database for remote data entry. This will allow our sales reps or service technicians to add contact records on the road. We will learn how to import bank transaction data. We will learn about multi-field composite keys, and how to transfer related tables using XML data. Topics include:

- Remote Data Entry Database
- View Info, Add Contacts Remotely
- Synchronize With Main Server
- Import Bank Transactions
- Prevent or View Duplicates
- Multi Field Composite Keys
- Prevent Duplicate Sales Reports
- Transfer Relational XML Data
- Exporting Customers With Orders
- Maintain Relationships via XML Files

Click here for more information on Access Expert Level 23, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 22. The next class in the series is Access Expert 24.

Error message in Remote copy Upload Images   Link 
Robert Taplin 
7 days ago
Hi Richard,
When I try to add a new record in ContactSubFormF (15:19 in the video), I get error message: You cannot add or change a record because a related record is required in table "CustomerT". There is a notes field in CustomerT and the entries line up with the existing records that show in ContactSubFormF. Thank you, Bob Taplin
Richard Rost
7 days ago
Sounds like you're trying to add a child record without a related parent record.
Robert Taplin
7 days ago
For the previous note lines, the customer name is in the CustomerID combo box. When I tab to "new" note line, the CustomerID combo box goes blank. The control source for the CustomerID combo box is CustomerID, and the Row Source is: SELECT CustomerID, FullName, CompanyName FROM CustomerComboQ ORDER BY FullName;. All those items are in CustomerComboQ.
Add a Reply
Import csv Upload Images   Link 
Mark B 
5 years ago
Hi, thanks for your reply. Yes I did use the wizard, and it wasn't able to seperate the field names and the data.

When I open the csv file on my desktop, it loads up in excell there are like 5 field names, then the data below, then spaces below that, then another row of field names, then under that more data. Read More...
Add a Reply
Import csv Upload Images   Link 
Mark Bee 
5 years ago
I've imported a cvs file from my HMRC payroll software and the data looks like below:

Employer's Name,,,Tax Year,,,Accounts Office Ref,,,PAYE Ref
Mark Bee,,,2015,,,238746guu3242,,,777/jjhs7733
Add a Reply
sync with server Upload Images   Link 
Kelvin Yew Kuan T 
5 years ago
I would be interested in learning how to edit records and then sync with the server.
Add a Reply
Append Query Upload Images   Link 
Brian Jensen 
5 years ago
I have a question as to why use an append query on the AppendCustomerServerQ and not a make table query?  Wouldnt using an append only add new records to the remote DB and not update other customer's info? I would think we basically just want a copy of the backend customer list need to append. Read More...
Add a Reply
Error with my Sync with Server event Upload Images   Link 
vicki Hudson 
6 years ago
I get an error with my Sync with Server event.  everything is the same as in the video.  the error is: "SELECT* cannot be used in an INSERT INTO query when the source or destination table contains a multi-valued field." It does complete the sync, appends to Server tables and deletes all info in ContactT and CustomerT. Read More...
Add a Reply
PayPal Upload Images   Link 
Jeffrey Ervin 
6 years ago
To Many Problems with importing from paypal they have changed there interface or updated there website, not sure if thats an issue but maybe you may have a look and see if things have changed? The main error I get when i try to import and click finish is "The search Key was not found in any record" Read More...
Add a Reply
Upload Images   Link 
Kenny Nelson 
6 years ago
NOTE:  This works great with queries also!
Add a Reply
Converting European Dates Currency Upload Images   Link 
michele finizio 
7 years ago
Hi Richard, for your "European customer" could you teach the following issue while import data:
date : EU format for date is dd/mm/yyyy instead of mm/dd/yyyy. When we import date (like we have in that sample) we have problem to convert Read More...
Add a Reply
synchronize data between the databases Upload Images   Link 
7 years ago
Hi Richard,
I would be interested in learning about how to synchronize data between the databases as discussed at 15:40.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

7/24/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access expert 23 remote data entry composite keys import bank transactions xml  Page Tag: whatsnew  PermaLink