I am creating simple little database for food & shopping. In the form
which is set up as continuous form, the food I order is set up in
descending order, so at the top is the most recent orders of food. The
problem I'm finding as I add more and more data, If I want to add a
record I have to scroll all the way down the form to get the new
record part for adding a new food product, very annoying.

Is it possible for the new record part to be at the top of the form,
so I don't need to scroll all the way down anymore to add additional
food products?

e.g.

ID Food
1 Fish
2 Potatoes
3 Carrots
*4 New Recrod*

I am calling an event from the on click event of a command button. I
cant however figure out how to refrence "which" button was clicked in
the first procedure, in the second procedure... In simplistic terms I
would like the system to know which button was clicked on the parent
form so that it can pull specific requirements within the other
section of code... any help is greatly appreciated...

I am using Access to organize data from a survey which uses a Likert
scale to measure response- the scale is 3 points- "I agree", "I don't
know" and "I disagree". The numerical value of each response (1, 2 or
3) varies- such that for some questions "I agree" is = to 3 points,
and other times "I agree" is = to 1. I created an "answer key" table,
such that each record is a question, and for the fields of "I agree",
"I disagree" and "I don't know" I enter the appropriate numerical
value. I also have the "survey results" table, in which each record
is a respondent, and the questions are in fields. I want to create a
combo box/ drop menu for each question so that the data entry person
can simply choose "I agree", "I disagree" or "I don't know"- I want to
link the combo box for each question...

I have 4 combo boxes on a report for the fields, City, County, IBCCP
Agency Name, and Other Agency Name.

The row source for City is: SELECT DISTINCTROW [Cities].[ID],
[Cities].
[City] FROM [Cities];
This allows the values selected on the combo box on my main form to
show up on my report.

The row source for County is: SELECT DISTINCTROW [Counties].[County
Code ID2], [Counties].[County] FROM [Counties];
This also returns the values selected on the combo box on my main
form
to show up on my report.

However, I am not successful in getting the correct row source for
the
fields, IBCCP Agency Name, and Other Agency Name.

Can you help point me in the right direction?

Thanks,

John

I have 4 combo boxes on a report for the fields, City, County, IBCCP
Agency Name, and Other Agency Name.

The row source for City is: SELECT DISTINCTROW [Cities].[ID], [Cities].
[City] FROM [Cities];
This allows the values selected on the combo box on my main form to
show up on my report.

The row source for County is: SELECT DISTINCTROW [Counties].[County
Code ID2], [Counties].[County] FROM [Counties];
This also returns the values selected on the combo box on my main form
to show up on my report.

However, I am not successful in getting the correct row source for the
fields, IBCCP Agency Name, and Other Agency Name.

Can you help point me in the right direction?

Thanks,

John

The questions are toward the bottom of this post.

Situation is this:
1) Access 97
2) Multi-user appplication
3) SQL Server 2000
4) Sporadically (i.e. less than 1%% of the time) encounter the
following error:

3218 Couldn't update; currently locked

in a particular function (function name is
GetFullyQualifiedTableName).

The code from the GetFullyQualifiedTableName function is below:

I've found a painful bug when running an Access 2003 database under
Access 2007. It manifests in both XP and Vista.

Some combo boxes on some forms become transparent when they lose
focus. It seems to be completely random as to which combo boxes on
which forms are affected. I've tried importing the forms into a new
A2007 database, but the bug persists. It seems that if the forms were
created in A2003 they have the potential to manifest the problem.

The only fix that I've found so far is to create a new form, copy all
the objects from the original form to the new form and then copy the
code to the new form. Very labour intensive. Fortunately I only have
a few forms that are affected.

Has anyone else seen this and/or heard of a less time consuming fix?

I have used Sum(Abs([field])) to convert my neg. (-) values to pos.
(+) values how can I obtain the correct percentage.

For example, here is my expression from my query trying to calculate
the correct percentage, in this case, 2/2+3 = .4*100 = 40%%.

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))

Expr18 returns 400%% instead of 40%% due to using Sum(Abs([field])).

How can I correct this?

I am so close to completing this report.

Thanks!,

John

I have used Sum(Abs([field])) to convert my neg. (-) values to pos.
(+) values how can I obtain the correct percentage.

For example, here is my expression from my query trying to calculate
the correct percentage, in this case, 2/2+3 = .4*100 = 40%%.

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))

Expr18 returns 400%% instead of 40%% due to using Sum(Abs([field])).

How can I correct this?

I am so close to completing this report.

Thanks!,

John

Is recordcount a little messed or what?

For Each tdf In dbs.TableDefs
If Left(tdf.Name, 3) = "tbl" Then
Debug.Print tdf.Name
Debug.Print tdf.RecordCount

it prints the correct name but the RecordCount is off on 8 out of 30
tables. the only thing is all the correct ones don't have any records
LOL

3 of the 8 show 20 records but the tables contain 21
2 or the 8 show 12 when they have 15
3 or the 8 show 17 when they have 18

what am I doing wrong?