I mean to update the databases on different laptops, desktops and other devices as are connected to the main server on a Local Network, not internet.
Such that every changes made by different users will be synchronized to one another
Thank you
Hi,
I am just thinking how i can implement 2 or more database to synchronize automatically every 5 minutes such that when databases exists, old ones should be deleted while new ones should be synchronized and if path does not exist, users should be prompted for new path.
Thank you for your...
Hi,
I got some code for converting text to harsh password but my problem now is how to really implement the code such that when i type anything as password, it should be automatically be converted to harsh text. Here is my code below:
Global g_Enabled As Boolean
Public Const Salt As Long =...
Thank you for this relationship example.
But I am still confuse a little because i am intending to use a form/subform and the subform is continuous form.
Now how do i select item using code? or query?
Please be kind enough to still show me rough example.
I think you may not understand what i meant.
Update is to update QtyAvail and Update Customer Account with amount ordered
Append is to append current records to a table where existing records for today will be deleted.
This is to keep history of Item inventory by their dates
Most especially, I...
Hi,
I need VBA codes to Update records in 2 or 3 tables with Criteria like ItemID
Secondly, I need VBA codes to Append records to another table with Criteria like ItemID
Thirdly, I need VBA codes to Delete records from another table with Criteria like ItemID
Fourthly, I need VBA codes to...
Hi,
I have a simple inventory which has an order form (continuous form)
I want to be able to scan barcode from 2 or 3 fields in a table like, an Item can have UPC or JAM or EAN code. So when any of the code is scan, the same Item show pop up.
Below are the tables with their fields:
tbItem= ID...
Hi,
I wish to request if it is possible to design an inventory where multiple shops or branches can be accessed from the same place
or
multiple shops can use the same program with a centralized database, such that every user can only access his or her report from anywhere they login from...
Hi,
I want some vba codes to update Item table from sale table using criteria
fields to update are Item.QtyAvailable [Item Table] deduct sales quantity from Available Quantity in Item table
Customer.Account [Customer Table] debit this account of total Amount ordered from sales table
my sales...
I think you do not understand my question or i did not frame it well.
What I want is supposing you have all the coca cola products (fanta, coke, sprite, etc) at the same price and the shop owner says please input everything of coca cola as same item with their respective code scanned. Instead of...
Hi,
I have an inventory access program that a sales outlet uses.
Since the barcodes of the same group of items are always changing, I want to figure out how I can scan all related items into one textfield, where at selling point, any item code can serve for that group without recording each one...
Hi
how can I implement an update code on Access Web on SharePoint
I have a web form where the supplier /customer account balance are present. I want a VBA code to bill the customer account of the order made and also the supplier account of items ordered until payment is made
for help,the unique...
Hi guys,
As a follow-up of my recent questions on Item expiration, I have discovered that the solution should be a FIFO system (first-in,first-out).
My question here now is how do i go about this FIFO designing.
Does anyone has an idea or rather sample FIFO database for me to learn from?
Any...
Hi,
the big picture is that it is complete package that includes even the customers and suppliers.
What i am trying to avoid is duplication of Products/Items in the same table.If I enter Items expiration date for Perishable goods,let's say 1/1/2015 and before those Product/Items where totally...
Thank you for your replies.
I was away for sometime to a remote place outside of network.
The tables are:
1- Items(ItemID,ItemName,CatID,AvailableQTY,CostPrice,UnitPrice)
2- Purchases(PurchaseID,ItemID,PurchaseQTY,ExtendPrice,PurchaseDate)
3-...
Hi,
I have an Inventory solution.
I am ready to deploy it to a client, but the client ask me if the solution contains Items expiration date?
My puzzle now is that, which table will carry the expiration date and how do i do away with it when that Item has either been sold before the expiration...