Problem updating a combo Box 1 184 (3/19/2007 9:44:17 PM)
I have a couple of subforms : (Diagnoses, ActiveOrders) on a main form (Residents) and I wish to be able to associate a diagnosis with a particular order. The diagnosis field on the ActiveOrders subform has t...
Harry

runtime error '2001' 1 542 (3/19/2007 4:52:20 PM)
i am trying to run a piece of code that i know works to look up the value of a query stored in a table, but when i try to run it, i get a runtime error 2001 message. can anyone help me? the code i am using is: ...
michael

Count Age Grouping 1 450 (3/19/2007 11:51:49 PM)
I have an access 2k database in which I need to count groups of records of individuals by that age groups such as 14- 20 no of individuals 21-30 no of individuals 31-40 no of individua...
Nemesis_uk

Create a Variable from First 4-5 chars of a existing value ?? 3 125 (3/19/2007 11:43:17 PM)
In a current table, the values in a particular field are all items like: MD45 Tuesday PM or TX341 Friday AM or FL12 Monday PM ...in other words...2 parts seperated by a space. The first part is always a ...
kev100

Access Query not functioning completely. 3 126 (3/19/2007 4:30:15 PM)
I created a query with two tables, ID numbers in common. I joined the IDN in both, but only the information from one table is showing in the results. I've done a hundred other queries like this. Did I "set" s...
Utf

Getting rid of ties in Top 5 2 235 (3/19/2007 5:58:10 PM)
Hi Everybody, I get 9 records when I get Top 5 because there are some matches or ties ... is it possible to get rid of these, it is driving me crazy. Please help, Thanks Teresa ...
Utf

Updating Single Field Multiple Times 0 219 (3/19/2007 5:43:18 PM)
I have a list of 1000's of products that I would like to categorize based on their names. I expect to have about 50 categories and prefer not to have 50 different update queries. What I have now is: Product...
Utf

Custom Function 6 202 (3/19/2007 12:15:33 PM)
Hi, I am stuck with a date function, I think it is just something silly I am missing, please could you advise. Many thanks for your time. Kerry ______________________________________ In a Module named Funct...
Utf

Access Query Output to report Summation problems 2 253 (3/19/2007 1:00:18 PM)
Hello, I have a query that I output into a report. When I use the sum function in the report control source property field I get a mismatch error when I run the report. example CURRENT DOLLARS 2.00 - 3.00 - ...
Enrique

How to implement the outer join in ACCESS for more than 2 tables? 1 706 (3/19/2007 9:45:05 AM)
I have three tables (Employees, Outsourced and Projects). Projects table include project_id, project_name, emp_id as foreign key to Employees.id and Outsourced _id as foreign key to Outsourced.id. I need a ...
Utf