3 Quick Q's

[anoob]

Hello,


I figured I would post these as one question since they are probably quite basic. Help would be greatly appreciated:

1. When you use the form wizard and select a style, such as "Vista", it seems like you are unable to edit the background color/image for the header. Is there a way to unlock this topmost section?


2. I have a text box that is only on my form that is supposed to return the minimum date for a field. This is the default value. It works - but only when I put my cursor in it. Is there a way to make this happen automatically when the form loads?

(There is also a Max date field that has the same problem...)


3. I have a third "Sum" field that reports all the income on record. When the form opens I would like it to sum EVERYTHING (which is why the previously mentioned min and max date fields are important).

However, I would like the user to have the option to change the start and end dates on the fly. How would I set up my sum field to total the transactions between date 1 and date 2?


THANK YOU!!

[ajetrumpet]

1. When you use the form wizard and select a style, such as "Vista", it seems like you are unable to edit the background color/image for the header. Is there a way to unlock this topmost section?

There is no such thing as locking it. It's a pre-determined format, not a template. Those themes are simply formattings and stylings via the property sheet and pre-stored resources that can all be changed.

2. I have a text box that is only on my form that is supposed to return the minimum date for a field. This is the default value. It works - but only when I put my cursor in it. Is there a way to make this happen automatically when the form loads?

generally, if you put an expression in the cs of the box, preceeded with an equal sign, it will populate just fine:

=dmin([field])

3. I have a third "Sum" field that reports all the income on record. When the form opens I would like it to sum EVERYTHING (which is why the previously mentioned min and max date fields are important).

However, I would like the user to have the option to change the start and end dates on the fly. How would I set up my sum field to total the transactions between date 1 and date 2?

can't possibly answer, as there isn't enough information to use to effectively help.

[anoob]

Thank you for the response, and please excuse my vagueness.
I'll try again.
Let's say that I have 4 items total (or objects, I don't know the lingo yet).


I have the field TRANSACTION DATE, which is stored in my table.


I have a MINIMUM DATE and MAXIMUM DATE that show the oldest transaction date on record and the most recent transaction date respectively. These are only on the form, not in the table.


I have a field TOTAL VALUE that sums up the total of all transactions between the minimum and maximum date.


If I were to manually change the MINIMUM DATE and MAXIMUM DATE, how would I code a button called "Show Totals" to refresh the sum of TOTAL VALUE based on the new dates? So that it just totaled the value between date 1 and date 2 - hypothetically?

For example, I create the button... but now what?
Does that make a little more sense?

I'm more asking for the functions of method to do this, not an actual typed up answer that I can copy paste.

Thanks!

[ajetrumpet]

in general, dates have to be wrapped in # signs. And if DSUM() is the function that does this sort of thing, you can modify the criteria section of that function to get what you need:

private sub button_click()

   variable = DSum("total value", "table1", 
                  "[datefield] >= #" & Me.textbox1 & "# AND [datefield] <= #" & Me.textbox2 & "#"))

'do something with variable

end sub

[anoob]

Well thank you very much.
I have one more... well, two more generic questions...

1. Have any of you ever done anything like this:

I have a very small web development company, and we do hosting for a handful of clients. On the 25th of the third month of every quarter, I would like Access to generate new invoice records for each client signed up for this service, so all I have to do is print and mail.

I'm not looking for an answer so much as just a general idea - is this something that is possible? Is it practical or far too involved? (I know it will save me time and allow me to quit using post-its for my hosting billing reminders...) Any online tutorials or projects or forum posts related to something similar to this that you have seen?


2. Are several of you employed in a place that you essentially manage data all day, be it with Access or otherwise? I'm just curious if knowing Access can land you a job.

I mean no offense, I'm just ignorant to the field and wondering if I should have paid more attention in my MS Office 2000 classes...

Thanks all.

[ajetrumpet]

I'm just ignorant to the field and wondering if I should have paid more attention in my MS Office 2000 classes...

Thanks all.

Actually, knowing office won't get you job. Everyone is expected to know that, literally. And just knowing Access alone won't get you very far, because no companies really use it as a stand-alone anyway.

In this day in age, you'll have the most luck applying for jobs if you apply for something that's related to your background. Breaking into new stuff almost 100% requires some inside knowledge or connection.

But that's here in Iowa.