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

Mbyllur Postuar 5 vite mё parё Paguhet në dorëzim
Mbyllur 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

• Email

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

Programim Bazash të Dhënash Excel Microsoft Access Visual Basic

ID Projekti: #18032211

Rreth projektit

10 propozimet Projekti në distancë Aktiv 5 vite mё parё

10 profesionistë freelancer dërguan një ofertë mesatare prej £31 për këtë punë

schoudhary1553

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ë

£100 GBP për 1 ditë
(282 Përshtypje)
7.6
sumon355

Hello, As an expert in ms access, i am very much interested to do this work. I checked your attached spec. file, but i am not fully clear. I think it would be best if you can show me in your database what to do in a s Më shumë

£30 GBP për 2 ditë
(181 Përshtypje)
6.9
alaeddindhahri

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ë

£30 GBP për 1 ditë
(68 Përshtypje)
5.8
crypthne

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert Më shumë

£20 GBP për 5 ditë
(35 Përshtypje)
4.7
prasannjeetp

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ë

£20 GBP për 1 ditë
(36 Përshtypje)
4.2
dataexplorer

"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ë

£20 GBP për 1 ditë
(13 Përshtypje)
3.4
DanialPITG

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

£18 GBP për 1 ditë
(0 Përshtypje)
0.0