Recent content by Lukasz337

Awesome thanks! Setting the bound column to 1 resolved my issue.

Hi All, So I created a search form which filters my results. Apparently I don't have enough posts to link to the source of the code though. The code is from this website, /forums/showthread.php?t=188663 I then wanted to allow users to double click a result in the listbox to take them to the...

I was thinking about using one table, but would that still be as functional? Do you mean one table for all the data or just one table for all the hardware? -For one thing I would want to account for something like multiple monitors. A typical location has 1 user, 1 desktop, and 2 monitors...

Hi Everyone, So I'm making a database for an office and I'm having a little trouble getting the information linked together. This is my first access project. Here's the information: Desktops_TBL Desktop ID (PK) Location (FK) Serial Number Product Number Operating System etc User_TBL...

Could I simplify everything down to one table? Each row corresponds to one Wire and all associated equipment and users. Run Queries from this table to break down the information (Queries for users, desktops, monitors, etc). Then set a VB script that performs along the lines of: On lost...

For the Wires --> Monitor and Wire --> Phone relationships I guess my question is how do I do this without creating double entries, Wire 1:Monitor 1 and Wire 1:Monitor 2? Setting it up I this manner produces 200 entries for me as opposed to 100, since each monitor creates a new row in the Wire...

So if I understand this correctly, all equipment, regardless of its whether its a monitor or desktop or whatever, would be in one column? I'm not sure I understand why the Serial Number would be under tblUserEquipment.

You're right. I figured it just adds an additional tier of complexity which is out of the scope of my question. Maybe 20 users have personal printers, however there are 5 main printers everyone has access to. There is no shared equipment (other than a few printers). As of now, there is no...

Hi Everyone, So this is my first project with access, and I was wondering if I could get some advice/direction with the project. I was asked to create a new database for an office of about 100 people (all information has already been collected). The database consists of the following...