Search results

Thanks a lot, i tried to create new table, but the same message i faced. "No unique index found for the referenced field of the primary table".

I intend to design new Access databased, I created 3 tables 1- tbl_room, PK roomID "Short Text" 2- tbl_bed PK roomID "Short Text" AND bedNO "Number" 3- tbl_item PK itemID "Number", bedNO "Number" AND roomID "Short Text" I want to create correct relationship between them...

thank you for your efforts; can i used VBA instead of query

i have database to manage the visits of my teams to the customers, so i need to calculate the duration days between the last visit and the current visit, (I have solution for the first visit in case we do not have previous visit date) but when the team visited my customer and they want to...

in the main screen "Master", it's contains a subform "Visits Subform", inside the sub form i have fields "Visit_date" and "Countd". when i click on add button for new record in the subform, i want to subtract the last record in "Visit_date" field and the current record that i want to add now...

Hello,, I have on the main form two subforms, the first one named (Referral_Date) contains one field "Referral date", while the second subform named (Visits) contains "Date of Visit" and "Days"; I need to calculate the difference between the "Referral Date" and current date on field "Days"on...