Search results

both tables already have the default id field - can i link those? It sounds as though you are suggesting a therapist id auto number field in both tables but if i made them both primary keys then i couldn't have another primary key for the appointments table. If it helps I'll list the tables...

Is a date/time field a special field or is it still just a normal date field? Not sure how that works.

the appointments table field called 'therapist' is text and is not a primary key the therapist table's id field is the primay key, the default field generated by access and a number format. I think I must be missing something basic. I thought you could link the primary key id field with...

newbie here... I'm getting the error 'relationship must be on the same number of fields with the same data types' and i'm not sure what to do. i'm trying to add a relationship between an appointments table containing a therapist field to the id field of a therapists table (which is the primary...

When my user enters the time for an appointment they only need to specify day and time as the year is implied and the minutes and seconds are irrelevant So when they enter the data, how do you allow day and time but still satisfy the general . date format requirements without extra typing? If...

i joined back then but only really started learning last week. It's good to get the opinions of someone who has recently experienced the same things as a new user. My instinct was to separate them but a couple of experienced users advised to keep them together - i think i'll go and ask why.

the link you gave me explained data properties for date and time. I've already looked that up so I know what format I need to use - it's the general format which includes the year all the way down to seconds. When my user enters the time for an appointment they only need to specify day and time...

Thanks, Conner. Apologies for the typo. I know what the formats are because I've looked them up as you suggest. My question is about how a user enters them rather than what they are and that has been harder to find on google, hence asking here. Is it necessary for a user to enter time and...

i'm designing my first db to record paient appointments. i've been advised not to split datas and times. Here's the newbie question: how does a user enter an appointment time without having to type the date and time in full? e.g. if i'm adding appointments for today at 11am and 1pm do i have...

...and hopefully will now put up with me, too!

Thanks, Reese. I'll look into google calendar a bit more, I think. The problem I may have with it s security. The NHS probably has a policy against putting confidential patient information in the cloud. My excel skill are fairly good so one of my options is to use excel to display appointments...

I've googled but its a no-budget favour and I can't find a free solution although I'm open to suggestions. The main purpose of the appointments is to create patient timetables and therapists won't book appointments if they know they are on leave etc. They use the outlook shared calendar...

thanks, Paul - that's very useful.

I used to have someone like that working for me. Set the department back 5 years! The team that will use it use outlook to record appointments and spend hours a week cross referencing and writing out timetables for patients so they are screaming for something to help - buy-in is a given. As...

I'm designing my first database for the purpose of recording appointments for multiple therapists/patients and i'm looking at what fields to include in the appointment table. When it comes to the time and length of the appointment, is it better to specify a start time and duration or a start...

I followed up on some of the links too. ms.com doesn't show any access 2007 templates - surely I'm doing something wrong there? Can anyone else see them?

Wow. So many I couldn't see the wood for the trees. I searched the samples for 'appointment' and only got one reference for a calendar. Are there other key words I should search for?

thanks for this. please could you point me at where i might find some? i've tried ms.com and they are difficult to search for - added to which i swapped my hdd for an ssd and now i keep getting blocked for not having genuine windows (it is!).

does any know of a free template for an appointments diary for a team of up to 15 people covering 25 clients between them? icing would be if it could compile cross reference timetables for each client too. tia!

Thanks, Dave. That's a really useful reply. After considering everything, this is my intended approach. Please leap in if you spot a problem... 1) learn access 2007 :o) 2) write the whole database at home on my laptop on access 2007 (I'll be using fake data because confidentiality will mean I...