Search results

:D:D:D This works flawlessly as far as I can tell. We will be running it from now on and hope it does ok. Thank you so much for your assistance, its been invaluable here.

still nothing.. :( to clarify, i want this to display the sum value of "JobValue" for whatever month that record is in. So if your working with a record from June ("JobDate"), it would be appropriate for this to display the total value ("JobValue") for June... regardless of what month it is...

nufin... just leaves the text box blank like before. theres something missing i just dont know enough to be able to find out what it is.

Thanks for the tips, ive switched the column names and applied the dsum as follows but it doesnt seem to display anything... =DSum("[JobValue]","[2009]","Month([JobDate]) = Month(Date())") I guess thats better than the #error that I got... did I miss anything?

Hello again friends. I have attempted to go on my own and try to write this myself but I guess there is something wrong. I am new so dont laugh if its really really wrong. I am trying to display in a text box the sum of the field "Value $" in table "2009"... but for the current month only. So...

Ah perfect! Works exactly as I wanted. Thanks SOS :D

This forum has been great so far, thanks to everyone! I am wondering if there is a way to prevent our staff from being able to make changes in the datasheet in a split form. We only want the datasheet in split form for navigation purposes and for a visual representation of our current jobs. Is...

Thanks for the clarification.. ill give it another shot. I think my problem is that I have about 15 colors to produce images for which gets to be a bit much.. something is not working just yet.

Thanks, it was the trusted location. It works now, and Ive tried in vain for the last while to get it to work on my DB but I just cant get it working... I just dont get how to set it up from scratch... I dont know what to copy and where. Just doesnt make sense. I would prefer throwing the...

thanks for the example, but im not seeing any changes based on selection... seems nothing happens?

I would like to set up a picture in the form that changes based on a combobox selection, for example if you select "red", a picture of the color red will appear in the form. I know this can be done because I have done a lot of searching on the subject, the problem is everything says to just...

Looked into this ctcombo... its a $399 extension!!! really not worth some images. If anyone else has any suggestions were all ears!

This would work well.. i could just supply a small gif of the color selected. Where can I find more information about how this is set up? :D

Well.. thats disapointing.. but thanks for the info guys, much appreciated.

One of our dropdown selection boxes is for shipping color, which is used for color coordinating different shipments. What we want to do is change the color of the selection in the dropdown box according to the color selected, so red would be red text (or background), green would be green etc...

Yes I realize this.. but the reason we have 2 seperate tables, is because once we get the job, we need to record a totally different set of data, its just way easier to use for us to have current jobs in a seperate table and have potential jobs in another because of the variation in data. Ill...

Hello, I am new to VB but would like to take advatage of it for our access tables. Heres what I want to do. We have a datasheet with potential jobs from customers, on the datasheet we have a combobox with "yes" and "?" for that record. When we get the job we select "yes". We also have a...