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...

excellent thank you.....works like a charm.

error invalid argument I hope you've answered this already. Emailing databases is a tricky practice at best. If there's a way to transfer the DB across a network or burn it to cd and transfer it that way, I recommend it. 1) Make sure you're running the same access version she is. 2) Try...

already did I did that, and it didn't work.

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...

Then... Would it be more appropriate to approach this using code?

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...

You mean you want to know the total cakes sold between a given range of dates? Try a crosstab query...it should allow you to manipulate the totals. Kate

One more thing...you may need to include the actual fields in your query before you can condense them, but I won't swear to it. In other words, all subscription fields will need to be in there and then you can go to the blank and fire away! Kate

In your query, go to a blank column and in the FieldName row you are going to "create" a new "field" that combines the three. I can best show you this by example...in my table I have a field for First Name, Last Name and Trial ID. In my query, I go to my blank column and type in the first row...

Well, the code for sorting a table is OrderBy = "[Field you need to sort by]" OrderByOn = True Or in a form, go to the form properties and go to the "Order By" field...there type: "Name of Field you wish to sort by, no quotes if one word but use brackets if its not" ASC or DESC, for Ascending...

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, Thanks for your ongoing advice/discussion...I realized the point you made, Jack, after trying several combinations of "updating" on a dry-erase board.The query would have to apply the "+1" only to values between the original priority (let's say 5) and the new priority, assuming the...

Would there be a way to automate this procedure for an end-user? I understand his concerns, but in this company, they would never be an issue. We would ALWAYS want the trials "bumped" so to speak, into the next priority slot....thanks for your advice so far.

Hi, let me see if I can explain better....There is a table containing numbers...1-15, and another table containing, along with copious additional information, trial numbers....the tables are related such that a lookup box searches the Priority table (the one with the numbers) and assigns a...

Thanks....I saw that after searching.

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