Search results

  1. M

    insert image button in 2007?

    ah - found it, thanks. I spent quite a while googling it and nothing showed up on this but I was snowed under with references on how to insert images to a database. I saw there was a button in 2010 but couldn't see it in 2007. Because I'm used to excel i didn't expect to find it in the control...
  2. M

    insert image button in 2007?

    I'm trying to add pictures to a form (not in the database, just a graphic on the form). In 2010 there is an "insert image" button. Is there one in 2007 and if not how would I do that?
  3. M

    adding images to a report

    in access 2010 there is an "insert image" button. Is there an equivalent in 2007
  4. M

    adding images to a report

    this is the form i'm trying to replicate: https://www.dropbox.com/s/z8pgm2f9d9wj65x/Screenshot%202014-10-16%2010.56.24.png?dl=0 The hospital trust logo is one jpeg and the values statement is another. I realise I could photoshop them into one but i want the flexibility to put them where i want...
  5. M

    adding images to a report

    I have to add 2 company logos and a phone graphic to a report. I can only seem to add one logo and if i try to copy and paste a graphic it just displays the file path. What ami doing wrong please?
  6. M

    getting relationship error when i try to change datatype.

    I'm in datasheet design view and I'm trying to change the data type of a cell and add a lookup. When I try to change the datatype I get an error which says I need to remove a relationship first - except I did. I deleted all the relationships, saved and closed the relationship view and closed and...
  7. M

    do i need a query or report?

    That's brilliant. I understand some of it but most importantly you've given me the keywords to follow up on for my learning research.
  8. M

    can't move individual fields when formatting form

    wow - agreed! I don't think I've ever come across that before. Presumably to protect you from being stupid and careless - in which case you shouldn't be trying to program access!
  9. M

    can't move individual fields when formatting form

    It seems I can alter the height of a single field in layout view but not design view.
  10. M

    can't move individual fields when formatting form

    First of all, I'm very new, just started learning access. I've just created a form and I'm trying to move and size the fields but they seem to be grouped together and whatever I do to one happens to all of them. I select one field and just that field has the orange outline but when I move it...
  11. M

    do i need a query or report?

    wow - it's like you're in my head! I have almost exactly what you suggest: appointments, therapists and patients. I've recently added a fourth simple table containing the appointment slots so I can select them from a pull-down. The therapist and patient tables are linked into the appointment...
  12. M

    do i need a query or report?

    I'll see if I can be clearer - I suspect it's my English, not yours! The group of 10 therapists will add appointments for the 25 patients throughout the day, every day of the week. (that's the bit excel doesn't like, simultaneous sharing by multiple users). When they make an appointment they...
  13. M

    do i need a query or report?

    so how might this work in practice? do i give my users a query to ask for a patient name and week, then a report to calculate it and print it?
  14. M

    do i need a query or report?

    I'm building an appointments database for a friend. Her team of 10 therapists will see many patients in a week, often the patients will have multiple visits from several team members in a day or week so she produces a timetable for each patient. Appointments go into a shared outlook calendar...
  15. M

    two fields in a lookup?

    i've managed to use the lookup wizard to show me two fields in the drop down list, first name and last name, but when i select a record I can only see the first name in the cell, not both. Is there a way to display them both together?
  16. M

    autofill sequence in a table?

    I'm so sorry Galaxiom, that's a bit technical for me! I think I understand that i have to use a query as the source of the lookup instead of a table but not certain about 'Cast the times to strings in a derived field' could you bear to elaborate for me please?
  17. M

    autofill sequence in a table?

    I tried cutting and pasting from excel and it worked fine. '08:00' etc filled the field as 36 new records were created. I changed the data type to date/time and they reformatted to '08:00:00' However, I went to set this up as the lookup source for my main table and i got an error saying this...
  18. M

    autofill sequence in a table?

    I'm creating a table with times of the day from 08:00 to 17:00 in 15 minute increments. I'm goig to use the table as a lookup to make it easier to enter an appointment time. I don't really want to type them all by hand - does access have an equivalent to excel's drag and autofill a sequence...
  19. M

    error when creating relationships

    ahhhhh... I think the mists are clearing. Thank you so much!
  20. M

    error when creating relationships

    let's see if understand that correctly: In my tblAppointments I use the therapist field as the therapist id and change the data type to number data type. In my tblAppointments I use the patient field as the patient id and change that to number data type Then do I use therapist field in...
Back
Top Bottom