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



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

Evner: Programmering af database, Excel, Microsoft Access, Visual Basic

Se mere: access query multiple tables same fields, create a query that joins two tables, access union query make table, combine tables in access, examples of queries in access, access combine two tables with same fields, union query access, access query criteria, access multi select form table, sort access 2007, access 2007 forms user input, access 2007 runtime sort filter, sort option form access 2007, enable right click sort access 2007, sort form access 2007, access 2007 add sort form, sort form data access 2007, access 2007 form events sort, access 2007 sort form field data, access 2007 filter forms using user input

Om arbejdsgiveren:
( 40 bedømmelser ) Chelmsford, United Kingdom

Projekt ID: #18032211

10 freelancere byder i gennemsnit £31 på dette job


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 Flere

£100 GBP på 1 dag
(282 bedømmelser)

[login to view URL] I have gone through your project requirements and the document file. I will do exactly as per your requirements regarding the drop down of suppliers in the POVO form I will do it within 1 day only My rati Flere

£23 GBP på 1 dag
(494 bedømmelser)

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 Flere

£30 GBP in 2 dage
(181 bedømmelser)

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 Flere

£30 GBP på 1 dag
(68 bedømmelser)

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 Flere

£20 GBP in 5 dage
(35 bedømmelser)

Hi, I have a good experience in Database programming and MS Access, etc... But I'm a new freelancer so I doesn't have lot of reviews in these relevant [login to view URL] I confirm you I can do this project very well. Pleas Flere

£14 GBP in 2 dage
(24 bedømmelser)

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 Flere

£20 GBP på 1 dag
(36 bedømmelser)

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

£20 GBP på 1 dag
(13 bedømmelser)

Hi there! I saw that you're looking for someone knowledgeable in database manipulation. With the scope of work you've given, we will go back to basics and practice the database entity relationship. I've made a demo Flere

£33 GBP in 3 dage
(4 bedømmelser)

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å 1 dag
(0 bedømmelser)