Search results

It sounds like you're using text fields to store month names, yes? You might want to consider converting them to Date data type. Then to format them to show only the month name use the following: Me!TheDate = Format(Me!TheDate, "mmm") Then Access will order them properly. Another option is...

Instead of Me.[BillTo], use forms![YourFormName]![BillTo]

I'm having a similar problem. Using the format suggestion to reference the subform and requery doesn't seem to work. The details of my situation are as follows. The main form is unbound. The two subforms are placed on seperate tabs of a tab control. Since the main form is unbound, there are no...

Try it like this: ="Your savings is $"& Format(Int(Abs([Sum[Savings])), "Standard") However, that will show the number with a decimal point and two zeros. If you don't want that, I think you'd have to replace "Standard" with "#,##0"

Thanks for your reply. Unfortunately using the Visible property doesn't work either. Even if a control is invisible, if it's bound, it will still look for a control source. Actually I figured out a workaround. Since my underlying queries are all built programmatically at runtime, I simply added...

In a nutshell (a large nutshell!), I have a complex Budget vs. Actual expense report made up of multiple subreports - 36 in all - one for each calendar month for Budgeted, Actual Labor and Actual Other expenses. Underlying queries for subreports are all built on the fly based on user input. I...

I'm relatively new to the coding side of Access any maybe this is a silly question, but how do I return multiple values from a function? Can I return an array? If so, how do I refer to each element in the array that's been returned to the calling subroutine? For example, if I have a function...

Hi all, I have a couple of issues I need some direction on and I'm under a bit of a time crunch so I'm not above begging! Here's some of the background info without going into excruciatingly boring detail, so hopefully it's enough to provide an idea of the general structure: Reports are...