Search results

Where did you go? You asked a question and then left while I'm trying to help. :mad: Well In any case here is a answer. Create a query SELECT YearlyRatio.CODE, YearlyRatio.year, YearlyRatio.value1 FROM YearlyRatio WHERE (((YearlyRatio.CODE)="A")); Save that as qry_A. Change the criteria to...

Well I don't think you need to go to the extent of creating some elaborate code. Again what is your experience with creating a query?

You already have table Yearly ratio? Have you ever done a query for anything? What level do I need to explain? Is there a relationship between the two tables? I'm guessing it year.

Liam, Hey just thought I'd give you a shout and let you know that he accepted it the way I had it. If I had to do it over again for a one user I don't know if I would do it differently. I'll have to wait to see if any problems arise. If there was going to be twenty hands in the db then...

I read a few posts on this but nothing definitive on how it's done. I'm trying to duplicate a present day paper form that my company fills out. They enter(write out) the info on this form top to bottom. It's like a crosstab but not quite(I think, never did one in access) Dealer...

Works perfect. Thank you.

I have a workable code Select Case Me![country] Case "USA" Me!phone.InputMask = "!\(999) 000\-0000;0;#" Case "US" Me.phone.InputMask = "!\(999) 000\-0000;0;#" Case "CA" Me.phone.InputMask = "!\(999) 000\-0000;0;#" Case Else Me!phone.InputMask...

Thanks for your advice Liam, However I'm pot committed. A Poker term. I'm going to see what he says about and what he thinks. Maybe he will pay me to change it. Or maybe my conscience will get the better of me and I'll fix it anyways. After I give it to him. Because of my inexperience...

I've gotten half and need to present final product for the second half. It always seems like enough when you make the deal... In anycase I think I'm going with it the way it is. The query he is putting his criteria in is a multiple join with many tables. He cannot edit the tables from the...

Maybe I misunderstood "Freelance". I met this company and sold him a bill of ideas. He took me up ion it and paid me. I've done maybe a dozen and 5 of them I got paid. This is not my fulltime or part-time job. Something to offset our cost of living and I don't have to claim it.

Yes I am. Why you need a need someone to build you a good db?LOL:D

By the way namliam... My wife is a Belgian. We where at one time thinking of moving there. What is the job market there, at least in the Netherlands, for entry level IT guys?

That is what namliam is suggesting as well. I'm not great or good with code. His sample db makes it look simple. and If I had only one field then.. I'm stuggling here with getting paid and eating or spending another 2 weeks doing right but doint it over, again.

That worked I like it but 2 things. 1) I would have to do that to all 32 fields. And for space I would have to do it in a seperate form. 2) Use of wildcards. He is going to want to search,filter, for like "*b*" or > or < or between and etc. unrelated if there is a "#" symbol in the fields...

Sorry my goof. It should be 1,2,4 I'm wasn't worried or concerned about the order by for this forum but it is 1,2,4 You are right. IF the mainform has no custID as 3 then the subform cannot and will not display it. Filter or not. Again, my misytake cause I rush things. I should have said...

My skills in code are NULL. well almost. Untill this db I was doing everything with wizards or macros. Yeak I know... However I think I have learned a bunch(In the realm of things I think my bunch is still a grain) I have tried, not hard on opening up a rar file with no success. I'm sure it's...

MainForm CustID 1 2 3 4 Subform CustID, OrderID 1,1 4,1 3,3 2,5 2,1 criteria in subform OrderID=1 subform results 1,1 4,1 2,1 Mainform results 1 2 3 4 I want mainform results 1 4 2

Rabbie, You are right They do have one to many and they are parent to child. However, and maybe I'm not doing something right, if you filter your subform it will filter the records in that recordsource. It will not filter the mainform and show only the records in the mainform that meet the...

I did post my db's in there. db1 and cardgunner2 database. db1 was before I created the filter by query. cardgunner2 I had it created the filter by query and had some issues on how to reset the query and a couple others issues. As far as the casacding boxes I looked at the present form and...

For lack of a better way to filter a form with subforms. I have a form with subforms. He wants to set criteria for a field in the subforms and filter the records of the subform AND the mainform. We have Asubform, Bsubform, and Cmainform. In Asubform field AID he wants to see all 1 values. In...