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!

  • Congratulations SkipVought 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. ZylaWonder

    Open new form with new record for option picked from other form

    I apologize for the delay in my answer. My job really screws up my free time. Ok we want to accomplish 2 things, first we want Form B to open for data entry and then we want to set a value for NameID. First on the command button OPEN at the event for the ClickEvent use DoCmd.OpenForm. In the...
  2. ZylaWonder

    Open new form with new record for option picked from other form

    I'M NOT SURE THAT I CAN HELP YOU BUT I WILL TRY. FIRST, LET ME MAKE SURE I UNDERSTAND YOUR PROBLEM. FORM A POPS UP AND THE USER PICKS FROM A LIST BOX A NAMEID, THEN CLICKS ON COMMAND BUTTON, TO OPEN A NEW FORM, SAY FORM B. ON FORM B ALL YOU WANT TO SEE IS THE NAMEID SELECTED FROM THE LIST...
  3. ZylaWonder

    HELP W/ ADO AND SUBFORMS

    cmmrfrds; This is a very helpful link with lots of good info. I did download the sample database from Charlotte Foust. However, the example is about the same as I have seen elsewhere. Again the example refers only to one table and not to multiple tables as I have. Should I be using an array...
  4. ZylaWonder

    Adding new fields to an existing form

    Wemeier is correct. If you used the wizard, an "embedded query" was built for you. Therefore, you must add the new field you would like to use. Right click the black square by the ruler (at the top left),click on properties then click the DATA tab, click the 3 black dots and the...
  5. ZylaWonder

    HELP W/ ADO AND SUBFORMS

    Thank you for your reply. I apologize for the lack of clarity. The exact document being posted is a check. The solution is all coded in A2K, and the database is A2K. The subforms is linked to the main form by the check #. The main form contains base information such as date, payable to...
  6. ZylaWonder

    HELP W/ ADO AND SUBFORMS

    In an accounting solution I am writing it is necessary to use Transaction Processing and Rollback. I have created an unbound form and am using ADO to insert data into the table after certain validation rules are met(check amount not blank, etc.). I actually love the amount of control ADO gives...
  7. ZylaWonder

    using custom help in access

    Microsoft has a tool called HTML WORKSHOP. It is included with the developers edition, but it can also be downloaded from the micorsoft web site. It is not located in the DOWNLOADS section from the main page. If you will enter it into the search engine, located in the upper left hand corner...
  8. ZylaWonder

    WIN 98SE ICS (TIRED SUBJECT?)

    OK I GIVE. I know all I care to know about ICS! Basically, it will work but the thing is that sometimes it just won't. I find this solution to be unstable at best. For the effort spent it is not worth the end result. As those wiser before have stated: ** AT NO TIME did I use ICS for the...
  9. ZylaWonder

    WIN 98SE ICS (TIRED SUBJECT?)

    THANKS EVERYBODY FOR YOUR INPUT!! Timebomb: Great response!! "The problem is that sometimes it just don't work" I LOVE IT! ROFLOL!! Jakespeare: Ok you may be exactly right. I am not using the right tool. No argument here! But, when I read documentation from Microsoft they...
  10. ZylaWonder

    WIN 98SE ICS (TIRED SUBJECT?)

    Hi EdFair! I am checking out DSL routers NOW! I decided on the ICS solution because it was already there and looked fairly simple. It's that now it has become a mission. Even if it is a mission I might not deploy just now. I have to date not read or spoke to anyone that has used this...
  11. ZylaWonder

    WIN 98SE ICS (TIRED SUBJECT?)

    IS THERE ANYONE IN HISTORY WHO HAS SUCCESSFULLY USED ICS? TO QUALIFY MY QUESTION, I HAVE READ 16 DIFFERENT KB ARTICLES ON THIS SUBJECT. I HAVE 4 COMPUTERS CONNECTED VIA HUB; HOST COMPUTER HAS 2 NIC CARDS; 2ND NIC CONNECTED TO DSL PIPE. 1) PEER TO PEER NETWORK WORKS CORRECTLY. 2) HOST CAN GET...
  12. ZylaWonder

    BAREBONES SYSTEM

    jexter and ceh4702; Thanks for your response. Logic always makes a good basis for a decision. Joshs328; I have only participated on this board. However, I have precious little extra time and participating in multiple on-line chats is just not my style. I have no clue what you are talking...
  13. ZylaWonder

    BAREBONES SYSTEM

    Sorry for the dealay in response. Thanks everybody for the input! I am going to try a combination of all suggestions. I will search for "name brands" at the best price, either on the net or local.
  14. ZylaWonder

    BAREBONES SYSTEM

    Ed: Thanks for your response. As you can tell by the fact I asked the question, I am kinda scared. If it were my money I would not be as hesitant. This purchase will be for a Police Dept that has either old or very poorly equiped boxes. A local hardware vendor has charged $1500 - $1800...
  15. ZylaWonder

    BAREBONES SYSTEM

    Has anyone purchased and built some of the "barebone" systems that are advertised pretty cheap on the net? If so, a) How did they work for you? b) Which is the best supplier? Thanks in advance for your response.
  16. ZylaWonder

    Why does app on user machine reset ADO to higher priority than DAO

    cmmrfrds: Looks like a trip to Barnes & Noble this weekend. I have the Access 2000 Bible and my most used book is by Allison Balters, Mastering Microsoft Access Development. She uses alot of ADO in this book. I do use it for most things. But, I guess when we find something familiar, it is...
  17. ZylaWonder

    relational setup help

    So after I have mulled: Before we go to last year vs this year: You will need the Family ID field in the [Child] table! See, mulling is good! I do understand about holding a child back based more on size than age. This happened to my son. After the "windy" [League] & [Team] thing...
  18. ZylaWonder

    Link to tables on network start up.

    John; Please forgive me for incorrect info.[blush] I would like to watch this thread and see how this works out. I wonder if ADO code might work here by passing the log-in and password?
  19. ZylaWonder

    Use one DB to launch other Access DB's?

    JavaTurkey: Great question. I have the same situation. Dany527: Good Answer. But.. if I develop the "Main Menu" with the appropriate command buttons on my machine, then move the application to a client worksataion, the database I am trying to link or open will have a different...
  20. ZylaWonder

    relational setup help

    ...After that windy [Teams] vs [League] speech I see in your Child table..[League last year];[League this year];[Team last year];[Team this year]. Actually I saw it before but I wanted to make a point. And it is: Your previous question was "...Kittens...Don't I have to have the team id and...

Part and Inventory Search

Back
Top