Recent content by DirkWagemans

  1. D

    Barcode

    Thank you! Does that mean the "barcode" is displayed as "clear text" in the table and with the "barcode font" on the form? Or will I need to apply the barcode font in the table as well?
  2. D

    Barcode

    Thanks for your replies, I don't know much about SQL yet. The IMS I am making is my first interaction with SQL / Access altogether. But that "barcode" should be converted to what looks like an image with stripes. Sorry I don't know the right terms :( Is there no problem that the "stripes"...
  3. D

    Barcode

    Hey guys, Quick question; Can I save barcodes as a text-field in my database so it'll be linked to an item? Table1 ID Item Stock Price per unit Barcode 1 1 Cable 10 € 5,00 (any barcode)...
  4. D

    History report

    You're completely right. It would be better to simply add a query to the "print report" that will prompt you to select the date of logged data you wish to view / print a report of. A .bmpr file is a Balsamiq Project file, which is a mock-up of the design of the forms (not the tables). I will...
  5. D

    History report

    Hello professionals, Only recently have I started working with Access as a starting IT-engineer. I currently have a project to create an Inventory Management System from scratch. What I want to program is a "history report". All changes made to the inventory database need to be registered on a...
  6. D

    Form fields not updating from combobox selection

    Resolved now. Somehow the relation was removed without anyone accessing the database in any way. Not sure how
  7. D

    Form fields not updating from combobox selection

    Dear Pro's, Completely baffled here. Nothing was wrong, but today when I opened my database: When selecting an item from the drop-down list (combobox) the other fields in the form used to update, now nothing will change except for the combobox showing the item. (so quantity will stay at 0...
  8. D

    barcode scan GUI

    Hello Minty, Thanks for your reply, it gives me a good understanding of what is possible. Now I was wondering, can I make a macro that would detect a barcode scan, saves that input in the background, opens a GUI, selects the correct field and inputs the data? This would make it so people don't...
  9. D

    barcode scan GUI

    Hey Minty, Thank you, I thought it might be too much for a single question. To kick off I would like the barcode scanned data to be input not in the selected field, but in a new field, inside a GUI where I can protect the field from having text entered manually, only through a barcode scan. So...
  10. D

    barcode scan GUI

    Hey guys, Only recently started to explore MS Access further and I was unable to find a solution to the following: At my company we have a barcode scanner that will input the scanned data as clear text into the selected field. What I am trying to do is as follows: 1) Scan a custom made barcode...
Back
Top Bottom