Search results

Hi Bob, Nope, now it just counts the total number of "yes" responses and adds them to each speciality. This is SO frustrating, and I know you are trying really hard to help, and that makes it worse! Ok, deep breath! Imagine I have two specialities: Respiratory and Cardiology. I have seen...

Thanks Bob. This looks really good, but I run upagainst the same problems that I had before. Namely, I can't add a new Patient at the same time as adding tests. This was the original issue, as the database has to be ultra-user-friendly, and be able to add a patient and new set of tests at the...

Hi Bob, That worked, thanks, but won't seem to work when I have another field that I want to sort by. Specifically I want to count the yes/no fields for the various specialities (see previous messages). I get an error which says "You tried to execute a query that does not include the specified...

Hello again Bob! I've also seen this solution posted. Sorry to be amazingly dense, but I'm not sure where to type it. All the query fields in Access 2007 seem really prescriptive and don't seem to accept calculations. Please spell it out as you would to a child!!!!!

Thanks for replying so quickly. Unfortunately this doesn't seem to work. I followed it to the letter and the query now returns no results at all. I thought the criteria field was used to filter results? Have I misunderstood you?? Thanks again, Mark.

Dear all, I have seen this query posted in numerous places before, but I have been unable to locate a complete answer. I would like help please with counting a yes/no field in a query/report. I understand that Access counts a "yes" as -1 using the "sum" Total function, and I have seen...

Hi Bob, It's nothing to do with my ego, honest! If I'm to be specific enough to get this resoved, then it can't be over an open forum. Can I pm you, and I'm sure you will understand when I explain. Regards, Mark.

Hi Bob, I didn't mean to cause any offence, and you clearly know far more about this than me. Would you mind if I emailed you privately to try and resolve this please? I have good reasons for requesting this; not just not wanting to display my ineptitude for all to see on this forum...

Hi Bob. Thanks for replying. I am sure it doesn't need to be as complicated as that! Using your format, this is how it is set up at present: tblPerson PersonID - PK (Text) FirstName LastName DoB tblTests Person ID Test Date Maths English Science Person ID is linked one to many. Now...

David, thanks for the response So what should I do? The unique Identifier is alphanumeric and not serial or random so I don't have a choice? Is there a solution?? It seems ridiculously simple, but still seems tricky??? Mark.

Dear All, I have used this forum with great success in the past, and I am embarrassed to say that my current problem is so humiliatingly simple that I feel I should apologise for insulting your collective intelligence! However I don't seem able to solve it so here goes!: I'm using Access...

Please help! I have just finished creating an Office application to store, manipulate and report data. I enter data in Access. Excel imports and manipulates it, nad then a Word mail merge outputs the report. I had been working with test data that worked fine. I deleted the data in access, and...

I think it turned out that the file was corrupt. When I re-created it it worked fine.

Hi, I'm not sure if this is an Excel Problem or a Word one, however if anyone can help I'd be very grateful. I'm starting a mail merge, and trying to connect to an Excel spreadsheet (xlsm format and has a simple macro within it). I cannot connect to it as I get the error message "External table...

Thank you Exodus You got me thinking! I realised that there was probably code hidden in menu button items in my switchboard. It turns out that this code was forcing the report to open in report view and not print preview. I changed this and it now works. Thanks for the push in the right...

Hi there, I've used this forum successfully in the past, so hopefully you will be just as helpful again. I am trying to produce a report that takes its data from a query, and filters by way of another form with unbound text boxes for inputting report criteria. When the report is produced it...

Solved! Thanks boblarson; This solved my problem and also helped me to understand how it happened in the first place. Thanks Again Mark.

I am sorry, but I can't believe I don't know how to do this in Access 2007!!! Not meaning to insult everybody's intelligence, I have created a Form, and now I am not able to resize text boxes individually. Whatever I try, changing the width of one text box (by dragging or changing width...

Thaks for the info Peter. Back to the drawing board I guess!

Hi There, I have recently upgraded from Office XP to Office 2007. I had an Access database which worked fine in Access XP. In it I had a table linked to an Excel spreadsheet. When I entered data on an access form, it updated the Excel spreadsheet [source document] accordingly. This does not...