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...
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...
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...
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.
Ah, it seemed that the problem was something different:
I had closed the form before doing the comparison, so the checkbox could not be read.
Silly me.
Thanks all, it works now.
FYI: I tried both the '.' and '!' syntax after I delayed the form's closing and both worked. I am going to stick...
I have created dynamic graphs based on a dynamic querydef, but I can't do checkboxes. It is so sad.
I am getting an odd error on this on a form:
If Me.checkbox1 = -1 Then
' some code
' more code
End If
The error is on the line with the comparison: "The expression you...
I had a similar quandry recently.
I ended up creating an intermediate table which summaried the relationship between (my equivalent of) the customer ID and whatever keys were in the second table. I had to merge some fields and such so the relationship could be created.
Then I was able to do...
That is strange ... I know one other guy who got the same thing to work by the same method I am trying.
I'm going to ask him to look at my code the next time I see him.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.