Search results for query: *

I will preface my post by saying I am very new to access. VBA skills are very limited. I would like to know the best way to accomplish the following: I want to create a form that has a combobox with all client's last names. Once the user picks the last name, I would like the address fields...

It works for the fields that have a "0" (zero) in the field. How do I eliminate control labels that have Null or no value? Thanks. Gretchen

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Do I have to change this line? When I run the report this is showing up highlighted in yellow.

Thanks Duane, you have pretty much written any fancy code this database has. How would I add multiple fields to the code. If I want more than one field and label to not show up if there is no value? Thanks for the help! Gretchen

I would like to have several fields (and their labels) in a subreport NOT show up on a report if they do not contain any value. Is it possible to have fields visible on a report depending on it's value? if field = 0 then do not show that particular field on the report. I am creating an...

I need help big time. I am not sure if what I am dealing with is a bug or user error (mine). After re-opening a database I have lost the ability to generate several queries and reports. I had several backups of the database and some of them were working after closing the application and...

The clients are represented in BillingGroup. The fields used in the query: [BillingGroup] [SumofTotalAccountBalance] [RateTable] [ValueDate] then the query expression 'GetQtrRate([SumofTotalAccountBalance]) should return the [QuarterlyRate] This expression should look up whether the...

The Field is [tblBillingGroupRate].[RateTable] and the potential values are "old" or "new". Thanks! Gretchen

I don't understand where in the code there is a reference to the field name [RateTable]. How does the program know to look up the value of the [RateTable} to determine whether it is a "old" or "new" client? Duane said, "The function and code I sent to you assumes your field name is [RateTable]...

Thank you both for your help. I feel terrible to be taking up so much of your time. I wish I was more knowledgeable on this VBA. But, now after showing me the power of it... I don't want to quit - I have to make this one piece work. Duane you asked and the below statement is exactly right...

I don't think the code is ever saying look specifically at the "RateTable" to check to see if it says OLD or NEW. The RateTable field is included in the query that I am trying to insert the arguments into. Does it need to specify where to look??

I am getting a "Compile Error: Syntax Error" and these lines are being highlighted I don't think it likes the third line below Public Function GetQtrRate(dblSumTotAcctBal As Double, _ strOldNew As String) As Double If strOldNew = "OLD" Thanks for all your help in this. I am amazed.

I am sorry, you have lost me. The code that you provided above is for the NEW Table however no where in the code does it identify that it is the NEW ratetable. I also will need to add the exact same thing for the OLD rate table but include different values. Like This.... OLD Public...

Yes, SumOfTotalAccountBalance is a numeric field. No there are no Null values. And I got the same thing as you answer of 2.57075471698113E-03 which is .00257. And now I just tried to run the query again and it WORKS!! I have no idea what changed since yesterday... I am so excited... I...

The logic on the final line is that asset management fees over $2 million are calculated as follows: Assume the total assets are $2,650,000. The first $2 million are billed at 0.3% the amount that is over $2 million (in this case $650,000) is billed at 0.125%. For the client invoice, I need to...

Thank you both for your help. Ok, I tried the Code. You are correct I mis-typed the "/". I wanted to Divide. in the code section do I need to spell out "SumTotAcctBal" so that it is the same wording as SumTotalAccountBalance? Currently, following exactly the steps Duane outlined above, I...

I am not sure if I am accurately describing my problem in the subject line. I have the below entered in a query. QuarterlyRate...

Thank you both for steering me in the right direction. Looks like I have some more reading to do. I have found that getting clarification on what it is I should be learning about to solve my problem is a huge time saver. Best Regards, G

Thank you both for your help. I have noticed many responses containing "myvalue" "myform" - does this just indicate whatever my particular form in my database is called? I apologize for the ignorance. In addition, is Dlookup the best way for me to produce the result I am looking for in a...

I am a very new user of Access 2000 so please bear with me. I am a financial planner and am trying to create a database that will handle invoicing our clients quarterly. We charge a percentage rate based on total assets at the end of each quarter. Unfortunately not all clients are billed...