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
Pagado a la entrega
+++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
Nº del proyecto: #18032211
Sobre el proyecto
10 freelancers están ofertando un promedio de £31 por este trabajo
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ás
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ás
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ás
"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ás
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
