Search results for query: *

Bill, Just a quick note to let you know I got everything working with your Transposer code. It is a great piece of progamming. I got my data into a 25 by 25 grid like I wanted using your transposer to make 25 fields. I don't know if access is going to let me do what I wanted to do...

Billpower, Thanks for the download of transposer..I am still getting an error when trying to open the form..When I look at the references, I see a Missing: Microsoft ADO ext. 2.7 for ddl & security in the list. I am running win98 with office 2000 (including access 2000). Do I need a...

Billpower, I hate to bother you again, but I am (thru my ignorance I'm sure) having troulbe getting your code to run. I keep getting a ByRef agrument type mismatch and if I get by this I get a compile error (centered on the Dim db as database "statement") The help file...

Billpower, Thanks ever so much for the code and the explaination of same. I can't wait to give this a spin. You might consider posting this info as a FAQ here, since I haven't seen any post addressing this (I did look at FAQ's and ran several keyword searches before I posted). At any...

Bill, Thanks ever so much for your help. One question I have before I give this a spin...will this work in my case since I have about 626 rows of data in one field that I want on the form. If this function turns the rows of data info fields in a "dummy" table, will I run up...

Hi, this is driving me crazy, I've posted several times with different attacks on the same problem and still I have no solution. I think I could solve my problem if I could just get data from my table on the form in the "form" I want it to be. The Problem...I have a table with the...

Thanks Mazeworx, but that's not what I'm talking about. I need a way to show a field on a form more than once. I would like to have a blank form with say "fieldx" data from row 1 listed, than beside it have data from row 2, then row 3, or maybe row 4...but still all from the same...

Hi, I'm having all kinds of trouble trying to get my application to display data on a "grid" type form. It is a 25 x 25 grid (625 points) using option buttons that are on or off. My problem was the crosstab query limit of around 225 fields or so, got around that by using 3...

After looking over what I'm trying to do, I'm more lost than ever. My query returns values in a field that are listed vertically, and I would like to represent those values (with an option button on or off) on a grid. This means do some sort of scanning horizontally. I guess I need to know if...

Hi Nathan, Thanks ever so much for your response. After looking over what I'm trying to do, I'm more lost than ever. My query returns values in a field that are listed vertically, and I would like to represent those values (with an option button on or off) on a grid. This means do...

Hi, Maybe since I'm new at Access, I'm trying to do things different than they should be done, but my beginning application is coming along anyway..My problem is I have a query that runs fine and gets the information I need. What I would like to do (if it can be done) is display the...

Jeremy, Converting the macro to code and running that took care of the "problem", thanks for the suggestions. Terry

Hi all, This seems like a simple problem, but for the life of me...I'm not able to figure it out...and I feel like I'm missing something simple. What I have is a parameter query that runs fine. It comes up with it's own box that prompts the user for "data1" with an...

FancyPrairie, thanks a bunch...you hit the nail right on the head...your code example was exactly what I needed..Thanks ever so much..I just made a vote for you for tipmaster of the week. I am amazed at the body of knowledge out there and the expertise of people like you. I hope you all are...

Thanks for the info, I'm sure I wasn't too clear on what I was trying to do. Basically, my subform will have a grid containing 25 different codes. Right now i just pick the code that is in the correct grid position and enter it in the field that needs this data on the main form. It would be...

Hi all, I'm fairly new at access, but I'm jumping in deep and designing an application right now. Despite the hair pulling and gnashing of teeth..it is an interesting undertaking. My problem..or should I say what I would like to do is get data from a subform on to the main form. What I...

Ken, Thanks again so much for your help...what you wrote may very well work, but it is way above my abilities right now. I didn't want to get into VB code or procedures to do this. I'm not sure where to put the code or call for it. I just wanted to be able to fill out the criteria field...

Hi Ken, Thanks again so very much for trying to help me, I apologize for not being very clear.. it comes from me just trying to get into this "access" database program..I had used Paradox in the past (and thought I was pretty good at it...maybe not :>).. At any rate, the table...

Thanks KenReay for the response.. Can you tell me what the exact syntax would be for this statement in a criteria field of the query, if for instance my list that I wanted to use inside the prints() of the In() statement is stored in a table called Mytable in a field named List. thanks so...

Hi, I'm new at access and have hit a wall. I have a query where I use the.. In(a05,a02).. in a field to find all records that have "a05" and "a02" in that field. I want to be able to change the criteria that is in prints() on the fly using cut and paste or some kind of...