Recent content by Jucius

After detecting the error condition, you might want to add an exit sub so that the code after the stuff you have above is avoided.

Perhaps one (built-in) function you are calling disables the hourglass.

You're gonna kick youself because the solution is simple ... :-) Controlling the hourglass is very easy in VBA: DoCmd.Hourglass True 'insert many long calculations here DoCmd.Hourglass False Also, make sure you enter DoCmd.Hourglass False into any error handling sections of the function...

It's a text string that I want to print sideways (basically as an axis on a dynamically generated chart.) The string is found via a DLookup statement which takes variables from another form. It's not critical that it get there because there is an alternate way I was going to present it.

If the form/table/whatever you are using to enter new records was called by VBA, make sure you OpenTable/OpenForm, etc has the correct parameters attached. It's possible you opened it in 'update-but-not-insert' mode.

I suggest that you use the expression builder for this. Open up the properties of the [addy] text box, select the 'Control Source' and then a small button with three dots on it will appear next to the control source field. Click this button. You will enter an interface where you can easily...

Obviously it's vba but what are you going to get the VBA to do?

You could use an aggregate SQL function (e.g. sum() ) with an extra query to find the total number of orders and then update one of the duplicate records with the total value. Then use another SQL query to delete all records with that order number where the quantity is not equal to the total...

What kind of VBA code do you want to write once the string is parsed? An SQL statement in VBA?

I don't think there's a specific 'right' way to do this but here is a possible method: You could create a module with a global variable: Global LastForm as String And whenever a form loses focus, it could update this variable with its name. This way, the variable could read/written from...

Thankd Doug. It seems I am out of luck then because the text is dynamically generated.

I have read that there is a way to do this, but I do not know what it is. In some cases, I have just changed the autonumber to an integer, did any changes I needed manually, and then changed it back.

A note about reading selection boxes: Even though your selection boxes are full of text labells, all access cares about is the primary key attached to those options. So if you select "Some Option" which has a primary key of 59 in a text box called "MyTextBox1" and then try...

This seems like a pretty obvious question but I didn't find anything on it in the faqs or a search of this board. It's simple: How do I create a text box where the text is sideways, so that you would have to rotate the page 90 degrees the see the field normally?

This is a shot in the dark, but you might want to try installing the latest MS Jet Database service pack (#6 I think) that shows up on windowsupdate.com on the users' machines and see if it makes a difference.