Recent content by ehamike

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

thanks I'll set it up that way instead of running the query first

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

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

thanks for the replies. I did check some of the stuff on Jeffs list but I will check through the rest to see if I missed something that might get me going in the right direction. The dbi stuff looks really good, i'll have to weigh my cash available against my time available (more time than...

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