Search results for query: *

I am trying to create a dialog box that allows the user to navigate from box to box using mostly the down arrow key. I cannot find the keyascii# for those keys. Does anyone know how I can acomlish this?

I get this error ("unable to locate database") trying to connect to database "New". I am writing this script to 123 v9.5. I am able to connect with the Querry addin, but I need to automate this task. I know the path and names are correct. Here is the line of code that...

I have a form with 4 graphs on it.&nbsp;&nbsp;When form is closed a warning appears that must be clicked &quot;ok&quot; to continue.&nbsp;&nbsp;This warning occurs 4 times (4 graphs).&nbsp;&nbsp;<br>It reads&nbsp;&nbsp;&quot; 'i'&nbsp;&nbsp;'The object is locked, so any changes you make will be...

Worked perfect!&nbsp;&nbsp;Thanks Ricky

Thanks...This looks like the right direction.&nbsp;&nbsp;I'll give it a try. I sent my email address...would like to look through the sample database.&nbsp;&nbsp;I think it will help me ubderstand how to implement the code. Thanks very much.

When choosing the &quot;auto&quot; option access makes the minimum y scale to zero.&nbsp;&nbsp;This wide scale hides the details.&nbsp;&nbsp;Is there a programmatic fix for this?

I need scale on y axis to change based on query results, so that;<br><br>minimum on y scale =lowest y value-1 <br>and<br>maximum on y scale = highest y value +1<br><br>Is there any way to do this?

I need to use this table as a &quot;template&quot; to hold 25 records with 2 fields that never change (and a dozen fields that do). This is to &quot;draw&quot; control limits on an SPC graph. And yes, I'm afraid that someone (probably me) will go too far and enter another record.

Is there any way to limit the number of records in a table?

Does anyone know of an add-in or something for developing better graphs? I am in desparate need of something straight forward with as many options as possible.<br> <br> Thanks

I have a graph embedded in a form that plots a values from calculated fields in a query. The graph needs to be updated after each new record is added. I do not want to link fields since that isolates the graph view to the current record only.<br> Doing a requery does not help. The only way...

WORKS PERFECT!<br> Thank you very much ! <br> dcb

Exactly....<br> This is the "range" in a sample of 3 individual measurements for an Xbar&R chart.

I have 3 fields in a query that hold like numerical data. I would like to find the difference between the highest number and the lowest from these 3 fields in each record.<br> In a spreadsheet this is easy(@max-@min)...column or row made no difference.<br> <br> I can use Dmax and Dmin within...

in Access 97-<br> &quot;=Date()&quot; is being used as a default value in a text box in a form. When the form is open there is an error msg. &quot;#name&quot;<br> <br> 2000 version takes this and shows it fine...anyone know what might be wrong?

Works perfect! Thank You!

very new to this. combo box is attached to query. i want the min() value in the query to be default value. tried many expressions with expression builder...can anyone help me?