Search results

  1. E

    I want to create a type of pick list

    I have 2 tables. The 1st one is tblRooms. It contains a list of all the rooms available to projects. tblRooms contains just 2 fields: RoomId (key) RoomName The second table is tblProjectRooms. It has 4 fields: ProjectRoomID (key) ProjectID RoomID RoomSortOrder tblProjectRooms contains...
  2. E

    Edit fields in an outer join query

    I have 2 tables (tblItemsQB and tblItemInfo) that have a 1 to 1 relationship linked by the "PartNumber" field. The tblItemsQB table contains a description field and 2 price fields (this table is downloaded from Quickbooks). The tblItemInfo table contains additional fields with information on...
  3. E

    How do I manage Quickbooks and Access apps

    I'm setting up an access database to use for creating proposals for our Home Automation clients. I'm currently doing it with an excel spreadsheet, but it is very clearly an Access application. Before I get myself into too much trouble I wanted to get some wisdom from those of you with way...
  4. E

    Technician appointment calendar

    I've searched and read and got a lot of ideas for creating an appointment application to schedule our technicians, but haven't stumbled across exactly what I am looking for. Since I am much better at excel than access, I had created the attached appointment spreadsheet but it is obviously a db...
Back
Top Bottom