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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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.
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...
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...
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?
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...
...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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.