Member Avatar for Hakeemiredia

I need and interface sample for supermarket inventory that work with access data base. I am sorry i am new to vb and i got assignemnt which i have to complet real soon..help out

  • 5 Contributors
  • 4 Replies
  • 111 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by AndreRet

Dani AI

Generated

A compact, practical plan for a VB + Access supermarket inventory (for ), expanding on points raised by , and others and clarifying common pitfalls.

Core data model (minimal):

  • Products: ProductID (Autonumber PK), SKU (text, indexed, unique), Name, CategoryID, SupplierID, UnitCost, RetailPrice, ReorderLevel, Active.
  • Categories, Suppliers: simple lookup tables with contact fields for suppliers.
  • StockMovements: MovementID, ProductID, MovementType (Purchase/Sale/Adjustment/Return), Qty (positive/negative), UnitCost, DateTime, Reference, UserID.
  • Sales and SalesLines (or POS + POSLines): Sales header plus line items referencing Products; record a corresponding StockMovement for each sold line.
  • PurchaseOrders and PurchaseLines (optional for receiving workflow).

Design notes and gotchas:

  • Compute on-hand by summing StockMovements instead of relying only on a stored CurrentQty; if needing a cached CurrentQty, update it inside the same transaction that inserts movements to avoid race conditions.
  • Use Autonumber keys and index SKU and foreign keys for performance. Keep transactions that affect stock atomic (begin/commit) so sales + movements stay consistent.
  • For barcode scanning, keep the POS form focused and update records in batch rather than row-by-row UI operations to reduce lock contention.

Access- and deployment-specific tips:

  • Split the database: back-end (.accdb/.mdb) with tables on the server/share and front-end with forms/reports on each workstation.
  • Match provider/bitness when connecting from VB (ACE vs Jet and 32/64-bit), compact regularly and keep backups.
  • For more than a few concurrent POS terminals, consider moving the back-end to SQL Server or MySQL for reliability and scalability.

Minimum deliverable for a quick assignment: product maintenance, receive stock, basic POS that posts movements, a stock-level report with reorder alerts, and a simple supplier list. Note the forum policy mentioned by regarding full homework solutions; the community can help clarify specific implementation issues and errors encountered while building these pieces.

Recommended Answers

All 4 Replies

Member Avatar for abu taher

nobody can give you the sample. better way, you will get lot of sample in internet. so try to search with right key word with any search engine. like google, ask or other.

Member Avatar for debasisdas

That may be delivered to you, if you are ready to pay for your assignment.

Member Avatar for ben25x

one of the requirements for Daniweb is we can't help w/ homework assignments. sorry!!

Member Avatar for AndreRet

There are tons of samples available if you search for "Inventory sample in vb6" on google.

Once you have the sample code, ask a question if you have any errors etc on the code. Please show some effort before we can assist.:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.