Lukket

Create search function in access using VB.

So I have to create a database where it stores stock (tblStock), and also keep track of sales (tblTransactions).

I have created both of these tables, I have also created a form (frmStock) where I can add, delete and edit information from tblStock.

I have created a query where I can search for specific stock so that it displays all the information relative to that item of stock (qrySearch) but I feel that I need a stronger search function put in place through a form (VB coding behind a search button).

And finally I need to actually create a sale form where I search for the product using the PartNo from tblStock, which I can then select if the product is new/used, then select wether the transaction is a sale (when updated the quantity is taken from tblStock relative to the quantity purchased) or wether the transaction is a refund (quantity is increased, opposite to a sale), then a button which updates the transaction and amends quantities relative to the sale/refund. ------------------- THIS IS THE FORM THAT I AM CURRENTLY HAVING PROBLEMS WITH, THE CODING THAT I AM CURRENTLY USING IS BEHIND THE SEARCH BUTTON ON THIS FORM.

In my tblStock I have a field named "LastUpdated"... I don't know if it's possible but when a transaction occurs is it possible for this to change to the date of which the last transaction for that product occurred?

This is a time sensitive project and must be completed within 2 days so I'm asking only experienced VB coders with experience in Microsoft Access database creation/manipulation to apply.

Kind Regards

Gareth

SORRY GUYS THE FUNDER OF THIS PROJECT NO LONGER REQUIRES THE PROJECT TO BE COMPLETED. THIS IS NO LONGER AVAILABLE FOR AWARD.

THANKS FOR ALL THE INTEREST AND MY DEEPEST APOLOGIES.

Færdigheder: Microsoft Access, Visual Basic

Se mere: search function access, create search function access, access search function, create search form access, search function access using, using search function access, search using access, create search function database, create search, create search function, vb creation, this is a search, search for coders, named query, coding add search function access, create search function using, search function access database, search function button access, field access using, search function using access, create search access using, create search button access form, search function , VB coding, visual search

Om arbejdsgiveren:
( 0 bedømmelser ) newbiggin by the sea, United Kingdom

Projekt-ID: #951984

11 freelancere byder i gennemsnit $87 for dette job

eperfections

We have developed 250+ projects. Please check inbox for my message. Thanks ePerfections

$100 USD in 2 dage
(28 bedømmelser)
4.9
DrTech76

Hi! I've sent you a message. Thank you.

$40 USD in 0 dage
(20 bedømmelser)
4.3
florinserban

Hi. Please check PM for details. Thanks!

$75 USD in 2 dage
(12 bedømmelser)
4.2
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$50 USD på 1 dag
(11 bedømmelser)
4.1
VenturSum

Keep me in mind if you need this work later or with another project. I have 15 years experience building Access projects. Along with an MBA in Finance. I've done this type of work for years.

$100 USD på 1 dag
(1 bedømmelse)
3.1
decato0110

hi, im ready to do this job

$30 USD på 1 dag
(9 bedømmelser)
2.9
takitsolutions

Hi there, I am a professional database developer with 15 years experience in dealing with ms databases particularly ms access database and vb .net and am absolutely sure I can help you in this and can deliver the so Mere

$75 USD på 1 dag
(0 bedømmelser)
0.0
webdevelopersss

PLS CHECK YOUR PMB

$150 USD in 5 dage
(0 bedømmelser)
0.0
allspark

yes sirr...let's do it

$100 USD in 2 dage
(0 bedømmelser)
0.0
jpmiano

Hi Gareth, I understand your requirements and I can these as specified. I hope we can begin immediately. Thanks

$30 USD på 1 dag
(0 bedømmelser)
0.0
bakuwa

I can do it.I'm a graduate in in Computer Science.

$50 USD in 4 dage
(0 bedømmelser)
0.0
MaulikBuddh

Our Service is your commitment.

$200 USD in 15 dage
(0 bedømmelser)
0.0