Search results

  1. M

    Synchronized 2 or more database

    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
  2. M

    Synchronized 2 or more database

    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...
  3. M

    How to Implement Password to Harsh form

    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 =...
  4. M

    Continuous form with Combo for searching Multiple Fields

    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.
  5. M

    VBA to Update, Append other tables from current form

    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...
  6. M

    VBA to Update, Append other tables from current form

    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...
  7. M

    Continuous form with Combo for searching Multiple Fields

    Ok, please show me a simple way of how to go about this Give me relationship and explain how to call those fields Thank you for your concerns
  8. M

    Continuous form with Combo for searching Multiple Fields

    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...
  9. M

    Search multiple fields in one textfield in Continuous form

    Hi, how can i design a textbox or combo to search for multiple fields from another table Thanks in advance
  10. M

    UML for Hospital Billing

    Hi, Can someone help me with a good UML to design a hospital billing solution with ms Access Thanks in advance
  11. M

    Design Multiple Branch Inventory

    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...
  12. M

    Update, Append other tables from sales form using VBA

    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...
  13. M

    Multiple Barcodes in one textfield or combo box

    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...
  14. M

    Multiple Barcodes in one textfield or combo box

    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...
  15. M

    Implement vba code on sharepoint Access web

    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...
  16. M

    Question How to design a FIFO database

    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...
  17. M

    Question Expire Items Solution

    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...
  18. M

    Question Expire Items Solution

    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-...
  19. M

    Question Expire Items Solution

    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...
  20. M

    Open report using date on a form

    Hi,how can open a report using 2 unbound textbox on a form as user input date criteria thanks
Back
Top Bottom