Search results for query: *

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.

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

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

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

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

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

Excellent. Thank you very much.

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

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

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

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

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

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

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

It works!!!

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.

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

Ugh. txtQuantity.text will do the trick.

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

Much obliged for the responses. I appreciate it.