How do youget access to suggest an entry from previously entered field data likeExcel
I have Windows XP sp3 with Excel 2007.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Data will be entered in an access form initially and then the same data will be re-entered again in access using a separate form.
I am needing to have a pop up message appears that alerts the second data entry individual that the current field entered did not match the initial record entry. I also was wanting to highlight the records and fields that did not match the initial data entered.
My first thought is to use the macro tools.but I am not sure if this is the right direction. I am new to using Access in the manner and appreciate any help or advice which can be given.
For example: I enter 3 new products on my form that populates my inventory table. Once I've entered the basic data, I now want to go back, search for the first product I entered, have the data I entered appear on my form and update its status to "Shipped".
This would of course update the status in the table. I will need to go back a few times to update the status and I wantto avoid having to go into the table to do this.
Can I use the data entry form to also update previous information? If so, how?
This is an accounts payable operation and the invoice numbers come from our vendors. The purpose of this application is to track incoming invoices.
The form works but the user has to populate other data in every field before Access tests if the data is valid. What I would like is for Access to test if the data is valid as soon as the invoice number field losses the focus.
I have read up on DOA and ADO, but I am a little confused, can someone please help to get me started.
1. I would like to use the Examine Data function to retrieve the data using a select statement.
2. Not sure how to start.
This subform entry will effect the data in the query once it is entered , so what I would like to do is enter the data, save and requery to have the other subform's query update with the new information before I close the mainform.
I need to be able to see the change in that query before I leave, The last field to enter is a number field - what event can I use to tell access that I'm finished with my entry, save and requery all the under lying tables and queries?
You don't want to be trying to ship an order to a company that does not have address details associated with it. If you don't have a contact name associated either, you can't even call to find the data. Creating a Microsoft Access macro to require data entry into certain fields will prompt the database user to complete this vital information. This will in turn deem your data to be more accurate and useful to all database users.
We're using Access