Bob

I have a table tblRecords

I have a form frmReports

I have a query qryFindName

The user populates tblRecords by a combo box cmbTechName (and other fields). The query finds all the records with Name = cmbTechName

In the TechName fied of qryFindName I have = [forms]![frmReports].[cmbTechName]

The user hits a button called cmdFindTechName with the code:

Private Sub cmdFindTechName_Click()

DoCmd.OpenQuery "qryFindName", acViewNormal, acEdit

End Sub

It runs the query, but I get no records. I believe the TechName is correct because the same combo box populates the records table and the query. I can't figure out what I'm doing wrong.

Any help?

thanks

I have a form that I use to complete a mail merge of a single document and then store the raw data in tables. One of the fields is a part number code and another field is the part description. How do I insert the table lookup for the part number so that the user enters the part number code and the description pops up, but also gets written to the data table? It seems like I have to link the field to 2 different tables, and Access doesn't allow that.

I can write VBA code to load stuff if I have to, but I'd rather let Access do it.

I have to calculate the average weight of a jelly bean, when I have 3 large containers of them and don't know the container weights. I know the number of jelly beans in each container and the weight of the beans + container. Can I just graph total wt vs number of beans, then do a linear regression

y = mx + b => total wt = (wt of a single jelly bean) * (number of beans) + container tare wt?

I have a hand-written document that I need to attach to an electronic customer report. There is information on the hand-written document that the company doesn't want the customer to see. Normally, I scan the document to a PDF and attach it, but hiding the information is the tricky part.

1) I can't use market to cover it up due to company rules against using markers.

2) We only have Adobe Reader, and I won't be able to buy any of the Adobe writers or any other editing software.

3) I have tried adding the document as an image to MS Office documents, but the conversion leaves the handwriting illegible, especially when I would have to print it and scan it again to get it into PDF form.

4) I'm stuck actually cutting out pieces of paper to cover the information I don't want passed, and then scanning it again.

Any ideas?

And if it is, don't they want you to be cruel to them? So being kind is actually being cruel, which is being kind..... Help, I'm very confused.

I have a stock that I purchased in December. It went up, then fell pretty far (~25%) in August (but is still positive overall). The 61.8% Fibonacci line gives a support level at $25 (the stock is above $25 now) if I look at a year's worth of data, but the Eliot c corrective wave would force it below $25 to complete the correction. Using a month's worth of data, I have a support level at about $24 and a ceiling of $27.75. Any suggestions about which I should believe?

I'm talking about when there is a crescent but you can still faintly make out the remaining portion, due to earthshine.

As in "less than good due to lack of use or practice"

For example:

"Since I have not spoken it in several years, my German is rather rusty."

There are rocks that are fairly common where I live in east central Pennyslvania, usually found in stream and creek beds. They are orange-pink, usually with lighter colored (almost white) veins. The appearance of the dry rocks is waxy or soapy, although the rocks seem to be very hard. While the rocks around them are smoothed and rounded by the water, these rocks usually retain squared or pointed edges.

I live in an area where the predominate stones are shale and slate, with some other types of sedimentary blue and brown stone. There is also a great deal of limestone and lime deposits around.

I'm trying to program a key (the Tab key specifically, but I'll take any key) to move to a specified cell when it's clicked.

I've tried this:

Sub Test()

Application.OnKey "{tab}", "Move5"

End Sub

Public Sub Move5()

Cells(Cells.activerow, Cells.activecolumn + 5).Select

End Sub

but it doesn't call the Move5 proc. Any help?

I'm talking about, for example, a deck of cards. I know how to make a single random number, but how does one get 13 non-repeating random numbers without checking each new number against all the previously generated numbers and just keep getting random numbers until one works.

I just use simple programming languages.

Construct a line segment AFOD such that FO = OD. Now construct a semi-circle such that FOD is a diameter and O is the origin of the circle. Construct a line segment ABC, non-colinear with AFD, such that C lies on the semi-circle and the line sement intersects the semicircle at B. (When you draw this out, it is easiest to see if you place C on the "D" side of the quarter circle and B on the "F" side of the quarter circle). If AB = OC, what is the angle measurement of BAO?

1) The angle measure of COD is 60°

2) The angle measure of BCO is 40°

A) This may be solved with eqn (1) alone.

B) This may be solved with eqn (2) alone.

C) This may be solved using eqn(1) and eqn(2) but not with each alone.

D) This may be solved with either eqn(1) or eqn(2) alone

E) There is not enough info from either eqn to solve the problem.

I said the answer was B but the correct answer is D. Can anyone explain?

Construct a triangle PQS such that angle PSQ is a right angle. Now construct a line segment PR such that R lies between Q and S.

How many degrees is angle PRS greater than PQR?

a) QPR = 30°

b) PQR + PRQ = 150°

A) I can find the answer with just eqn(a)

B) I can find the answer with just eqn(b)

C) I can find the answer with eqn(a) AND eqn(b)

D) Both of these equations together do not give enough info to get an answer.

Saying that QPR = 30° and that the sum of the other two angles is 150° is really the same piece of information, right? I know that PRQ + and PRS are complementary (=180°) but since QP and PR are not parallel, we know nothing about their angular measures. Or I am missing some piece of critical info?

If you know that:

a) a^n = 64

b) n = 6

A) I can tell the answer from eqn (a) alone

B) I can tell the answer from eqn (b) alone

C) I need both eqn (a) and eqn(b) to tell the answer

D) I can't tell from either one.

Please let me know how you came to your answer.

If you know:

a) x < y+ z

b) y = z

A) Yes, I can tell by eqn (a) alone.

B) Yes, I can tell by eqn (b) alone.

c) Yes, I can tell by using BOTH eqn (a) and eqn (b)

d) No, I can't tell.

I say the answer is D, but my teacher says it is B. Any takers?

For every positive integer n, h(n) is a product of even integers from 2 to n. If p is the smallest prime factor of h(100) +1, what is p?

a) 2<p<10

b) 10<p<20

c) 20 <p<30

d) 30<p<40

e) 40<p

I care more about the method for getting it done than the answer. Any help?

It seems like the freezer section of my garage fridge doesn't work in the cold weather - when the garage temp falls below 32°F. It works fine in the summer when the garage is warm or hot. In the winter, ice doesn't form and ice cream melts. Is the only answer to keep the freezer door open or can I do something else?