Search results

sharing solution Thanks to the above post I put together a simple solution; I'm sharing it in case someone may be looking at this post for the same reason I was. I created a function because I was going to use it for several phone controls (cell, home, other, etc..) In a module: Function...

Thanks barno, that does help. However, if I requery the subform on gotFocus, then the subform gets requeried every time it receives focus. However I only need to re-query it after the EditRecord form closes. Isn't re-querying the subform on each gotfocus make the DB perform worse, or maybe I...

Hi, I hope someone can help. I have a MainForm which I had to create instances of. I found this solution on creating instances: http://allenbrowne.com/ser-35.html and used it "successfully" up to this point. The MainForm has a subform from which I open EditRecordonSubform form. Once the record...

Thanks. IsNumeric does it; I didn't know about this function :o

I have a control called GoToId which afterupdate moves the user to a specified record where ID=GotoID. I want the control to only take numbers as input. I used input mask: 999999;;" " but with it the user can still press a letter on a keyboard and even though the letter doesn't get typed in, I...

I was wondering if there is a way to create a button on the form which would do the same as clicking from the commandbar: Window->Cascade. If not, then my second choice would be to hide all the commandbars with the code I found on the forum: Dim i As Integer For i = 1 To CommandBars.Count...

solution http://allenbrowne.com/ser-35.html

I have a form with two controls: DateFrom & DateTo I want to filter based on those criteria but when the criteria is ommitted (NULL) I want to display all. In case of other controls I have an SQL as follows: ... WHERE (tblClassesOffered.Course = Forms!frmClassReport.class Or...

Hi, I bet this is somewhere on the forum but I ran out of ideas how else to search for it. I have a vba script that uses docmd.sendobject which opens an email message addressed to an email list. Although I want to be able to edit the message before sending (which I can) I would also wish to be...

This may be related to your problem: http://www.mvps.org/access/queries/qry0013.htm

Thank you for the solution and the explanation. I was able to clean up some other stuff with this function too. (function Replace saved me some time too)

My Db had an email_address field which was a hyperlink. For various reasons I had to change it to a text field. However, now every email shows as: some_email@domain.com#http://some_email@domain.com# Is there a simple way of cleaning this up so I am only left with the email address? In other...

I have a form bound to a table which stores contact info for a person. I have two controls that are email_address and website_address. I set them both as hyperlinks. So now when the user clicks on the email_address Outlook opens a new message with an email_address in the To field. (I had to use...

Thanks Paul. I actually have more then two controls as the criteria for the query and thanks to your hint I approached the problem in SQL view which made it much, much more comprehensible. Everything works well now and it looks clean (understandable to me) with all the controls filtering...

Thanks. This makes more sense now. However, I'm still stucked on the problem: when having that criteria for more then one field in the query, the query doesn't work as I want it to, meaning: I have 2 controls on the form. Both should filter the query or not when NULL. When I leave control1 as...

This is driving me crazy :( So the method: [Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null works well with one field. But when I have two controls: [Forms]![myForm]![myControl_1] OR [Forms]![myForm]![myControl_1] Is Null and [Forms]![myForm]![myControl_2] OR...

Oh, I see what happened: the query in the design view ads at the end: [Forms]![myForm]![myControl] and under criteria OR: Is Null ... so it didn't disappear but I still don't understand the syntax when the control becomes the field name in the query. Could someone translate it into plain...

Thanks. It looks nicer and doesn't use IIF like the solution I just ran into, which was: IIf([Forms]![frmReports]![Software] is not null, [Forms]![frmReports]![Software], [Software]) and I'd like to use what you pointed me to: [Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is...

solution Found this by "accident":) while looking for something else: Yeah, I figured this out some time ago that wildcards don't work properly when you try to do this. You have to use the originating field name. IIf([Forms]![frmReports]![Software] is not null...

I think this solves my post: In the properties of the query I specified Unique Records to YES. (It is the same as adding DISTINCTROW after the SELECT in the SQL view)