Search results for query: *

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

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

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

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

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

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

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

Experts, I am writing my first PL/SQL statements in my Access2K3 pass-thru queries. I need to convert exisitng Access queries from native Access to PL/SQL. I have had some success, but mostly frustration. Here is one query that, if I can get a handle on, would serve as an example to hammer...

Experts, I have a complex 2k3 Access form that is unbound. The data for the form comes from several different Oracle tables that cannot be joined, etc. There are several subforms on this form, and several groups of controls on the form, all unbound. My question: Is there a way to simulate a...

Experts, I am trying to update a linked Oracled table in my 2003 Access db. For testing, I created a pass-thru query that runs the SQL statement perfectly. However, when I run the SQL statment from an ADODB command object, the date field in Oracle stores "1/1/1920 5:00 am". Here is the SQL...

Hi experts, I have an Access2K3 database and am attempting to link tables via ODBC to Oracle 9.2. In the Oracle tables, we have tried a zillion combos of INTEGER(x,y) for a data type in a test table, but still, in Access after I link to the oracle table, the data type for that field shows as...

OCBC tracing experts, I have been given a request to use ODBC tracing to try to capture a large number of ODBC connections made to Oracle during our morning batch routines. When I did a test on one Access database and one of its pass-thru queries, what was captured was not quite what I need. I...

I am new to vbscript. I have some test scripts set up that look like this (the parent instantiates several class objects from a child script, one of which is a timer): (PARENT SCRIPT .wsf file) <job id="Job1"> <script language="VBScript"...

I am a VBA programmer new to VBscript. What I would like to be able to do is create a child script that has several classes in them, then be able to call/instantiate those classes from other VBscripts. All of my VBScript files will be run as Windows Scripting files (cscript) etc., and all...

I have an Access app that has a bound control tied to an Excel chart in a workbook. Here is code that is in the Excel chart that captures the user's click event on a histogram: Public Sub Chart_MouseUp(ByVal Button As Long, ByVal Shift As Long, ByVal x As Long, ByVal y As Long) Dim...

Experts, I have read about 100 posts and still cannot add a mouse_up event (and event code) to an Excel chart that has just been created from within my MS Access app. This chart in Excel is not a chart on a sheet, it is, well, a chart chart. It IS the entire "sheet." In the Excel ojects...

Experts, I have a chart that I need to view in Access. I created the chart in Excel using the info from here: http://www.tushar-mehta.com/excel/charts/normal_distribution/index.htm OK. In Excel, when you run your mouse over the bell curve in the chart, you get the mouseover text that displays...