Access 2007 sort out the ability for a user to select a supplier from another table of data and add into a single field of a purchase order
£10-20 GBP
Paguhet në dorëzim
+++D NOT BID UNLESS YOU HAVE READ FULL SPEC***
***RANDOM BIDDERS WILL BE REPORTED AND DELETED****
Access 2007 sort out the ability for a user to select a supplier from another table of data and add into a single field of a purchase order
Please provide a written instruction as to how we can do this we CANNOT send out the database due to data protection
We have a form called frm SubContractors, linked to a query qrySubcontractors, linked to a table called SubContractors. This is used to store all suppliers.
We want for our purchase order screen to pick up this data so that a user can put in a supplier rather than type it in each time
Field names
• Contact
• Address1
• Address2
• Address3
• City
• County
• Postcode
Note there is also a field in the table called lbStatus (pink one above) we do not want anyone with “Do Not Use” to be picked up
We then have a purchase order screen
We want this data to shown in a combobox on a form called frmPOVOFormView, linked to a query called qryPOVO, linked to a table called tblPOVO so the user can select a supplier (expect those with lbStatus is not Do Not Use) and then name and address fields appear in this one box and saved in the table, the field the data is to be concatenated and stored in ultimately is called Supplier in the table
ID Projekti: #18032211
Rreth projektit
10 profesionistë freelancer dërguan një ofertë mesatare prej £31 për këtë punë
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Më shumë
Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you with Më shumë
Hi, I am a professional developer with very good knowledge of VB.NET. I will make a programme in VB.NET that will access the database and run queries to update or modify any table/record in the personalized way, you Më shumë
"Hi Dear, I’m an efficient data entry worker. I’m familiar with Google docs spreadsheet and I’ve experienced about collecting data from websites and enter into Excel and Google docs spreadsheet. I would love to tell Më shumë
Hello, this can be done using the index function. Send me the work and ill have it done for you within the hour. Thank you