Search results

I wish! I have too much data in it now ... sorry ...but thank you..... Question... I'm starting to wonder if I really even need the the "change request number" field ont he Assessment form ..I mean really ...the form itself is linked so when I do enter data on the Assessment form it will it...

Hello DK ! here the answers ... (A) - it is as you stated (B) - the format is set to match the format of the "auto number" field on the Change Request form

Okay ... I think I've confused myself to the piont that I might not be able explain my issue ...so forgive me : ) I have a form called "change request" with a linked form called" assessment" ... On both forms I have a common field called "Change request Number" the change request number...

Holy S#$! BATMAN ! It worked exactly how I wanted it to ! ! ! ! dkinley ...you are FREAK'in awesome ! This is unreal! ....can you be cloned and be sent to Canada? Thank you so very much! bless you ...wow !

LMAO ! Thank you so much ! .... okay this is working ....kinda .... I have done exactly as you stated and this is what happens .... I click on the cmd button the records gets saved : ) My Outlook opens up with an Attachment and in the "to" field it has "Change request number" ...

Just wondering ... where would I put this code? Dim stDocName As String stDocName = "rptnewsletterdatabase" strWhere = "[Reference Number] = " & Me.[Reference Number] DoCmd.SendObject acReport, stDocName, , strWhere Thank you in advance

LMAO .... I can't believe this ...i actually posted the same question a while ago ..... sorry http://www.access-programmers.co.uk/forums/showthread.php?t=155673&highlight=send+email

Well .... I would like to send email without a email client .... I have searched the forum...and nothing really stood out out for me ... i'll search again ... in the meantime ...if anyone has any suggestions ..please and could share them with me ...I would really appreciate it. Thank you in...

Hello, I've been searching the forum for a while and haven't found what I'm looking for ...at least thats what i think : ) Okay ... I have a form that I would like to save and have it send an email to me when someone clicks on the "submit" button..... can I have the "Submit" button...

Thank you Fozi ! ! ! I need stronger coffee then ..... I appreciate all your help! take care

Sure I can .... The form in question is called ARVIN system customer Access Thank you so much

Okay ...this is a wierd one .... for me anyways ......... I have a table that stores user information ... I have a form that is used to view the user info within that table ...... The form is setup so that when you select the "comapny name" it will autopop a few more feilds... the issue is...

I've been searching the net and here for awhile and can't seem to find the answer ...so here goes ... Basically, eveytime a new record is added, the app will email a report to me as a notification that the a new record has been added to the tables. The problem I'm having is .... the report...

Hello, i'm kinda new at access .... I would like to a default value for a combo box that has a table bound to it. The default value will come from within the table that is bound to the combo box .... am I making sense here ? ...if so ...please help .... Thank you in advance

"I avoid macros like vampires to sunlight." LMAO ! ! ! Thank you for your replies ...I will try the second idea ....

or this Dim stDocName As String stDocName = "rptnewsletterdatabase" strWhere = "[Reference Number] = " & Me.[Reference Number] DoCmd.SendObject acReport, stDocName, , strWhere Thank you in advance

Would this work ...... this is just an example ..... Macro Name Action ----------------------------- mcrPrintRecord RunCommand OpenReport mcrPrintRecord Actions...

Thank you so much for your replies! I chose the After Update event ont he form and it works great ....but now :) I noticed that it emails all of the records when I only want to see the new entry... is that possible? Thank you in advance

Hello, I have a form where the user will fill it out and hit "submit" and I would like it to save the information to the table and send an email to me. what is the best solution? Can one command button preform 2 functions. Thank you in advance

Okay ... I think Access hates me ... i tried doing the same thing you ....with another combo box ... and no luck ... it displays the data fine int he cbo but doesn't auto pop the other text boxes .... I made sure that the textboxes are unbound .... and have copied exactly what you did .... wierd...