Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. docliv

    help with placing data on form

    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...
  2. docliv

    help with placing data on form

    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...
  3. docliv

    help with placing data on form

    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...
  4. docliv

    help with placing data on form

    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...
  5. docliv

    help with placing data on form

    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...
  6. docliv

    help with placing data on form

    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...
  7. docliv

    help with form limitations

    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...
  8. docliv

    help with form limitations

    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...
  9. docliv

    comparing a vertical list with a horizontal list

    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...
  10. docliv

    Making an option button "yes or no"

    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...
  11. docliv

    Making an option button "yes or no"

    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...
  12. docliv

    Running a parameter query in a macro

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

    Running a parameter query in a macro

    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...
  14. docliv

    Getting data from a subform

    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...
  15. docliv

    Getting data from a subform

    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...
  16. docliv

    Getting data from a subform

    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...
  17. docliv

    Using the In (..) statement in a query

    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...
  18. docliv

    Using the In (..) statement in a query

    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...
  19. docliv

    Using the In (..) statement in a query

    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...
  20. docliv

    Using the In (..) statement in a query

    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...

Part and Inventory Search

Back
Top