Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: Micron
Forum: The Watercooler Today, 11:09 AM
Replies: 31
Views: 278
Posted By Micron
Re: Enough!

I guess you're not a hockey fan then. NHL; Vancouver. Ring a bell now?
Playing golf in Florida with my friend. 2 Yanks made a joke about 'eh'. As we drove to the ball he says to me "I don't say...
Forum: The Watercooler Today, 10:39 AM
Replies: 31
Views: 278
Posted By Micron
Re: Enough!

You just confirmed what I said in the political post about Americans and geography. My apologies to those US citizens who don't fall into that category as I realize you can't put everyone in the same...
Forum: Politics & Current Events Yesterday, 07:42 PM
Replies: 19
Views: 213
Posted By Micron
Re: will trump really be impeached?

Yes he was, and I never meant to imply that he wasn't. However, when Congress votes to impeach, the Senate has to ratify it (vote on it). That's why DT has nothing to worry about but don't get me...
Forum: Politics & Current Events Yesterday, 02:20 PM
Replies: 19
Views: 213
Posted By Micron
Re: will trump really be impeached?

There was a harassment charge by some woman against BC. Perhaps she worked in the WH, I don't recall. At any rate one thing led to another and BC was questioned under oath about Monica. Remember "I...
Forum: Politics & Current Events Yesterday, 01:54 PM
Replies: 19
Views: 213
Posted By Micron
Re: will trump really be impeached?

OK, so where do Mr and Mrs President do "it"? OK kidding aside, different how? Clinton was impeached for lying under oath and obstruction of justice, not because of what he did with ML. I'm not even...
Forum: Forms Yesterday, 12:03 PM
Replies: 9
Views: 124
Posted By Micron
Re: Hiding checkboxes depending on the value of another field.

That sounds like the checkboxes are not bound.
Forum: General 11-12-2019, 02:31 PM
Replies: 11
Views: 181
Posted By Micron
Re: Grand Total shows #error

In a test form, this works
=Sum([chkyes]+[dsid])

this results in #Error
=Sum([Check32] + [dsid])

I once got the error "Ambiguous name detected" IIRC and identical names was the reason. I...
Forum: General 11-12-2019, 01:58 PM
Replies: 11
Views: 181
Posted By Micron
Re: Grand Total shows #error

If post 3 doesn't work then consider this: AFAIK, you cannot sum over the controls themselves, you must sum over the fields they are bound to. e.g. if your textbox is named txtNum and is bound to...
Forum: Forms 11-12-2019, 01:23 PM
Replies: 7
Views: 142
Posted By Micron
Re: Display correct value

Posts 1 and 4 are asking for an expression for a calculated control, thus sql doesn't apply? I don't think you can use Between in such an expression. I know this or any similarly bracketed expression...
Forum: Forms 11-12-2019, 08:33 AM
Replies: 7
Views: 142
Posted By Micron
Re: Display correct value

If field is null it's not equal to 0? I was thinking to use Nz but haven't figured the >= .25 part yet. On my phone using data so that's all for now.
Forum: Forms 11-11-2019, 08:16 PM
Replies: 17
Views: 194
Posted By Micron
Re: OpenArgs not evaluated in Current event

TDG - no problem. Your point is well taken in that Pat might have been referring to window modes and not form views or properties.
Forum: Forms 11-11-2019, 07:51 PM
Replies: 11
Views: 177
Posted By Micron
Re: Using an If statement for every record in a subform

Again, assuming it's a continuous form, this is what seems to work if you use bound checkboxes
Private Sub Check32_AfterUpdate()
If Nz(Me.Check34,"") = "" Then Me.Check34 = 0
End Sub

Private...
Forum: Forms 11-11-2019, 07:25 PM
Replies: 11
Views: 177
Posted By Micron
Re: Using an If statement for every record in a subform

If in a continuous form, each option would have to be in it's own frame, but the frame doesn't have to be visible I guess. Should work if each frame is bound to a table field. However that would...
Forum: Forms 11-11-2019, 07:09 PM
Replies: 17
Views: 194
Posted By Micron
Re: OpenArgs not evaluated in Current event

I think you mean modal? Dialog is a border property; popup and modal are form properties.
Forum: Queries 11-11-2019, 06:49 PM
Replies: 9
Views: 163
Posted By Micron
Re: Combining two rows into one..

Where does it state that there are 2 tables? Not that I agree with the notion that there should be either. Would anyone put names in tbl1 and then your birth date, gender, phone number, address, etc....
Forum: General 11-11-2019, 06:42 PM
Replies: 18
Views: 263
Posted By Micron
Re: Useful links

Not everything that I have but here's some that I refer others to often (and sometimes myself)
Ken Snell on Automation - automation between Access and Excel...
Forum: Forms 11-11-2019, 03:53 PM
Replies: 8
Views: 131
Posted By Micron
Re: Draw on a form?

I guess I had an entirely different definition of "draw". Or you are saying you can draw on the form with either of those?
Forum: Forms 11-11-2019, 03:00 PM
Replies: 8
Views: 131
Posted By Micron
Re: Draw on a form?

You want to open a form in form view (or maybe design view) and then draw on it with some sort of application tool and what you draw becomes part of the form itself? I'd say no way.

You can do...
Forum: General 11-11-2019, 02:20 PM
Replies: 18
Views: 277
Posted By Micron
Re: Help with new project

Post back just saying "I will post a db copy next." and that should get you the 10 posts you need to upload a db. This db should have data that we can use. Suggest you also add a Word document or...
Forum: Forms 11-11-2019, 01:21 PM
Replies: 6
Views: 158
Posted By Micron
Re: Opening forms

cross posted
https://www.accessforums.net/showthread.php?t=78837
Forum: Forms 11-11-2019, 12:44 PM
Replies: 7
Views: 142
Posted By Micron
Re: Display correct value

Perhaps something like

IIF([BobNewNear]<6,6,[BobNewNear])
Translation; if BobNewNear is less than 6, show 6, otherwise show BobNewNear
The above assumes BobNewNear values are numeric. Since it...
Forum: Forms 11-11-2019, 12:36 PM
Replies: 23
Views: 253
Posted By Micron
Re: Form property of a sub sub form

I know about the nesting. My post was all about the syntax for getting there. Can't help with OP's specific situation if I can't associate the levels with the object names, let alone read Italian, so...
Forum: Forms 11-11-2019, 12:10 PM
Replies: 23
Views: 253
Posted By Micron
Re: Form property of a sub sub form

I'm not disputing whether or not a subform design such as what was posted will work, but I can say that it is possible to drill down that far. See image that results from
msgbox...
Forum: Forms 11-11-2019, 09:34 AM
Replies: 23
Views: 253
Posted By Micron
Re: Form property of a sub sub form

I realize what you're code does, but what it doesn't do is drill down far enough from what I can see. If you find the subform control and the sourceobject property is not "" then you are calling the...
Forum: Forms 11-11-2019, 09:01 AM
Replies: 23
Views: 253
Posted By Micron
Re: Form property of a sub sub form

Well it's not clear if it really needs to be done that way as I think everything depends on the nature of the business at hand. F'rinstance, maybe the options distinguish one "product" from another,...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:05 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World