Search results

Okay, I feel like this should be terribly simple, but I can't seem to work it out. I have a DB that tracks data in a patient survey by month. In other words, Patient ID, Patient Name, and then a series of questions about the effectiveness of their treatment, rated on a scale of 1-10. So the...

Question: I have a query that returns 5,997 records from a larger table of 16,000 records. On the report, I only want to see 150 of that 5,997. How do I tell Access to only show me the first 150....so that my report isn't over 500 pages long? Yes, I've tried setting the total records returned...

This is a complicated one!!!! I need some assistance with the following problem with which I surmise is a query-related problem but there could be other ways to solve it but I'll start here. I have a table that contains the following for a given record: Start Date Finish Date # of Patients I...

Hi all, Need a few pointers, please. I have a table in one database that contains a non-primary key called "Trial ID" as well as budget information by year, "2000","2001" etc...now I have a table in MY database that is for another group of users across the network to use, with a primary key...

Hi, I'm using a form with command buttons to link to related records, in a db with the window normally hidden and everything form-driven. I use an administrative account with, of course, full permissions on every object. If I F11 and try to enter a table, called "NSI", no problems....I can see...

Hi all, I have a form with two list boxes...one to select the current record for the form, and then the second to assign a manager to the record. Is there a way, once a user has selected a value in the second list box, to prevent them from choosing another on that current record alone? Meaning...

Hi all, I posted a similar question in the VBA forum, but I've since simplified and refined to adjust this process. I have a table that has a certain number of "trials" or records, with a field called "Priority" that designates (by sorting) how they should appear in a report. Hence, Trial...

Hello, This is probably a classic question, but how on earth do I get Access to autoresize the windows without using those ridiculous (an in a corporate environment, illegal) shareware resize programs? thanks, Kate Berenson

Hello all, Question...the database I'm writing monitors several clinical trials (a four digit number/primary key) at a given time. They are assigned a priority number for reports...trial #9999 has priority 1, #9998 priority 2...etc.... HOWEVER, the priority number is reset on a monthly/weekly...