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

    Replication Best Practices

    Do NOT use replication. It is a nightmare. The reason there are very few articles on replication is because few use it. My experiences with it were a nightmare. And i beleive that would be simimar to others who have used replication.
  2. iamareplicant

    Conditional formatting missing in menu

    wrong, it worked.....thanks ace...much appreciated
  3. iamareplicant

    Conditional formatting missing in menu

    didnt do anything, but 'preciate the help regardless...
  4. iamareplicant

    Conditional formatting missing in menu

    and nope, it doesnt exist in the regular menu bar :(
  5. iamareplicant

    Conditional formatting missing in menu

    yup, i am in design view when i right click on a text box to format it. And in Access 2003, condtional formatting shows up in the menu. So i assumed that in Access 2000, it showed up there as well. But it seems not? If any of you have Access 2000, right click a text box in design view and let...
  6. iamareplicant

    Conditional formatting missing in menu

    Experts, My client has an corporate-wide install of Access 2000. However, if I right click a text box, condtional formatting is missing (not greyed out, but completely missing). However, this works in the VBA code: txtText1.formatingconditions...etc... But I need to be able to get to the...
  7. iamareplicant

    Pass-through treats NUMBER like TEXT

    Excellent. Thank you very much.
  8. iamareplicant

    Pass-through treats NUMBER like TEXT

    Experts, Here is a good one. I have an A2K app with linked Oracle tables. I use pass-through queries to return data from the back end. When I run some (not all) of the pass-through queries, Access renders Oracle field-type NUMBER data as TEXT. That is, first, the alignment in the (what...
  9. iamareplicant

    Bound form w/Linked Oracle table

    Yes, i thought of the same thing. Populate the record right off the bat with temp values, then have them "updated" as the user enters vals. But, those temps would show up in the controls, etc. And the only way my pea brain could work around THIS is....well, back to an unbound form. 'Preciate...
  10. iamareplicant

    Bound form w/Linked Oracle table

    Experts, I have an Access 2003 app that utilizes linked Oracle tables. I have multiple pass-thru queries, sequences set up, all is well. At the moment, I am developing unbound forms. A lot more work, but they work and I have complete control of the data as I have set up the app so far as a...
  11. iamareplicant

    Using Oracle sequence w/bound form

    Shoulda mentioned that one work around i am aware of is to create a temp table for each form, then (to view a rec), grab the rec from the Oracle table, populate the temp table, and have the form bound to that temp table. Then, to create a new rec, populate the temp table with the new rec...
  12. iamareplicant

    Using Oracle sequence w/bound form

    Experts, I have an Access 2003 app that utilizes Oracle tables. I have multiple pass-thru queries, sequences set up, all is well. At the moment, I am developing unbound forms. A lot more work, but they work and I have complete control of the data as I have set up the app so far as a 2-tier...
  13. iamareplicant

    Loop through your own class?

    Thank you very much. I needed this code something fierce.
  14. iamareplicant

    Loop through your own class?

    Experts, I need to be able to loop thru a class that i have created and match the class's property to a value in my Access db (dont ask why i am doing this - it would too long a post). Is is possible to loop thru a self-defined class? Something like: ...dim prop as SomethingProperty ...dim...
  15. iamareplicant

    Does this look infected to you?

    It works!!!
  16. iamareplicant

    Does this look infected to you?

    Sir, you saved me today. I am under a ton of pressure and this issues is critical and i could not figure it out. THANK YOU.
  17. iamareplicant

    Does this look infected to you?

    Experts, I am using ADO (2.6) to insert into an Oracle backend from an Access 2000 module using VBA. However, I cannot get a date to insert properly, and I have tried formating the date with every combo i can think of. The date field inside of the oracle table reads '1/1/1920' or some such...
  18. iamareplicant

    KeyDown event won't read current value - HELP!

    Ugh. txtQuantity.text will do the trick.
  19. iamareplicant

    KeyDown event won't read current value - HELP!

    Experts, I need to use the keydown event in a text box to determine if the user has hit the enter key or the tab key. If they have, I proceed to another routine to process the contents of that text box. Problem: if I enter a value, say, "tr" into the textbox (key in "t", key in "r") then hit...
  20. iamareplicant

    New to PL/SQL and pass-through

    Much obliged for the responses. I appreciate it.

Part and Inventory Search

Back
Top