Search results

Thanks for the help. I'll say I'll go for the extra column to say whether it's been confirmed or not. As just having the month in there provides in acurate info as the majority of dates have days months and years. It's strange that Access doesn't offer something more reasonible for this as...

Small prob giving me a headache here I have a list of dates in order. However the boss came up with some new dates a while ago, unfortunately they are incomplete dates. ie April, or TBD. My date format is 02/4/2003 or 2nd April 2003. I've tried changing the format on the time date field, but...

Everything seems to be working. But any ideas how to get two totals (made by unbound text boxes) into an other totals box. so I've two added up boxes "male" + "female". I'd like to add them together but because they're text boxes it doesn't seem to work??????? Just figured it, change the label...

Right, strange thing afoot. I tried that again, and it didn't work. But I then made a new DB, and it did?!! I don't understand why it would work in one but not another?? Ok yes I do. Two fields were in memo not number........ Listen thanks for the help I'll be able to add a few things up...

Thanks, However whenever I try this in a Form using an Expression the two fields [Males 8-11] + [Males 12-15] just place the numbers side by side like: Males 8-11 = 5 Males 12-15= 5 Total Males = 55 It does not add them up together??

I think this should be easy....... I've two fields with multible records. In each field a number is put in. I'd like a third field to add these numbers for a total. Can someone lay this out in laymans? Thanks

:) Thanks for the help Hayley. I'll continue on here with the problem. It's kinda strange because years ago I made email fields with no problem. Then upgraded to 2000 and nothing I do seems to work anymore.... either that or the brain's heading down hill! Thanks Again

Hayley, Thanks for the help, and file. I've copied everything I can think of into my DB that you had regarding the email. But still it tries to open in http. Yours does open in outlook. Now I can go into table view in mine and individually edit each email address and switch them to Mailto...

I've tried "insert hyperlink" done the mail to but to no avail. The form just sits there. In fact insert hyper link want's me to enter all the email addresses. I just want to click the email address on mu form and a new blank email opens.

Apologies in the Delay. I can't get the first part of this code to work Keeps coming up with compile error. This is just for the can't close form option Any Ideas?

Cheers, Unfortuately setting the field to Hyperlink does not work in this case as it seems to want to open up a website of the same name as the email address? I Just want a user to click the "hyperlink" to send an email

Maybe it's the 2 hours sleep I had last night, but I've totally forgotten how to set a field in a form up, that contains an email address, so you can click on it and it'll open up a blank email with the said address in it Any ideas? Thanks

Shame if that's all there was too it. It adds a nice touch to have an icon on each form.

I've the DB set up to have an Icon. It also has a pop up screen and then a Switchboard based on a form. How do I keep the icon on the top of each form that's opened from the options on the switchboard. In other words I open a form from the switchboard now, and the new form shows the Access...

Not sure if I totally follow you But, If you go into the report with the labels and select design view you can then select and center which ever line on the label you wish.

Thanks for the help, just got them :)

Cheers for that, back to code I guess :)

Any Ideas on how to change the color of a command button from the grey, all options in properties seems to greyed out?

I've a drop down menu in a form. I'd like users to select an option from this menu before being alowed to leave the form, or better yet before being allowed to enter data they must select from this. Can some one tell me how? Or perhaps post a link to this question in a previous topic? Thanks

Thanks for that. Worked a charm, and a lot easier than making lots of little Macros!! Cheers Dave