Search results

As I read you last post I knew something was wrong... I looked back and found an error in my original post which I think may have confused the question. A change was made from the previous post and bolded. As you can see, I'm only dealing with one form (that has a subform). I just want to be...

Thanks for the reply! Basically, all I'm trying to do is create a really easy to use form that my users can use in order to create a custom query (which is a daily occurance). In regard to switchboards that are created by Access, this is not that. I just have a habit of calling my primary...

Nobody??? If I need to clarify anything just let me know.

I sure am having difficulty with this. I'm trying to have the criteria in my form refer to a text box within one of my forms which is the text as I would write it myself within the query design view. Query's [DEST_ZIP5] criteria = [Forms]![Mainswitchboard]![QueryWizard].[form]![calcDestZip5]...

Thanks for the reply. You're probably right... it's still a pretty neat challenge though.

This is more of a curiosity than anything else. I was trying to figure out a way to convert numbers to text strings for various reporting purposes; example below: 1 = One, 1st, First 2 = Two, 2nd, Second 3 = Three, 3rd, Third etc... It didn't take long for me to decide to bag this challenge...

Aggregate Queries keep coming up in my searches but I'm having no luck there either! Must this really be so darn difficult to report only ONE RECORD BASED OFF OF A MAXIMUM IN A SUBREPORT! Arrggg.

Here's another idea... since I always want the max phase perhaps a descending order on my form and a filter to only show the first record would work. I tried created a control =1 with running sum and then applying a filter to the form to only show that field when it's equal to 1 but that didn't...

I've tried and tried and tried to get a DLookUp to solve this problem but Im having no luck. I'm thinking a query in the record source or a cleaver filter of my subreport may solve it but I wouldn't know how... here's the problem. I have a report based off a table called ASSOCIATIONS. The...

Ahhh.... Gotcha! That makes sense why it isn't working. Alright, I suppose I'll just raise the white flag and submit to tagging my controls. Wish me luck! And thank you very much for the insight.

You almost answered your own question. The reason I thought to use the ".name" property was to OMIT that control from being locked (as that is the control I intend to use as the option control for locking/unlocking the form). As you can see, the loop does loop through all controls in my form...

Can someone help me fix this... I'm just trying to create an Option Button that will Lock/Unlock a SubForm upon change. I've seen and read many other threads on this topic but still cannot get it to work. Other threads recommended adding/changing the tag on all the forms controls. I thought...

ByteMyzer! WOW!! This is awesome! ...and how simple! I never knew of the Eval() function before! What a lifesaver! (ok... enough exclamation points.) But seriously, this is amazing. Thank you!

Very interesting... It sure seems like an easy way to accomplish a calculation in Access (err... Excel). But, the formula only works on a specific field. The challenge was really looking to create a function that would work on ANY active numeric field. It sure sparks some ideas though...

Alright... I'm no programmer. I dabble in Excel and Access VB but that's about it. Recently my users demanded a calculator for my database and found one on MVPS.org (http://www.mvps.org/access/resources/downloads.htm). That works just fine... but it sparks a thought... Many of you are...

AH HA!!!! I figured it out! I'm very proud... :D I kept searching... Found these sites: http://www.utteraccess.com/forums/showflat.php?Board=83&Number=1443807 http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=1265454 Ultimately, the solution came from using the function...

Hello. I've searched the threads and Google and have not come up with a solution to this; let me explain. 1) I have a continuous form 2) Each record in the continuous form has a cost code associated with it. This cost code is in this format ##.###.### 3) The numbers in the cost code have text...

Perhaps I wasn't clear enough in my description. Because unless subreports have attributes that I'm unaware of... they don't work like I'm needing. If it does somehow involve subreports (which I doubt due to the fact that all of the data is pulling from one table), the subreports would need...

I'm bewildered by the fact that I can't seem to find any threads on this... Nevertheless, I am trying to create a report from my Access Database that will list my records (up to 20) in the header of my report. Then, in the details section you would see all the field names on the far left...

Of course... you're correct. I forgot to mention that in my previous post. Certainly I realize I can make a new report to solve this problem. The point was trying to come up with a solution that would not force me to make a second report. I don't like having duplicates of anything in my...