Search results

  1. E

    Update or Append? and how to accomplish this?

    thank you all btw, I used George's example and got it to work. Thanks.
  2. E

    Update or Append? and how to accomplish this?

    USERID is what is the 'common' and 'unique' data for each employee
  3. E

    Update or Append? and how to accomplish this?

    Hello everyone, I have 2x tables: 1) TBL_EMPLOYEES this table has 800 records (employees), 200 of these records have null value under the "e-mail" column 2) TBL_EMPLOYEES_MISSING_EMAILS This table has, 200 records, these 200 records are the ones from table 1 that with missing emails. *...
  4. E

    changing UPPER CASE letters to lower case doable?

    Thank you both for your help
  5. E

    changing UPPER CASE letters to lower case doable?

    Suppose I have a table, that has 2x columns: FIRST_NAME and LAST_NAME some of the data in these fields are all in UPPER case while in others are all in Lower Case. Because, these are first and last names, I would like to change them to have the first letter to Upper case and the rest of the...
  6. E

    Question Access_Form and Outlook: How to email a pdf attachment?

    Thank you for your prompt reply. Sure CutePDF will work? I saw CutePDF also has a nother program that is not free, called "PDF Writer". http://www.cutepdf.com/solutions/pdfwriter.asp This is exactly what I need by the looks of it, except this is not a free program, "PDF Writer" some of its...
  7. E

    Question Access_Form and Outlook: How to email a pdf attachment?

    Is there a free pdf program, that behaves just like the "Adobe PDF Writer" does? specifically for what I am trying to accomplish? I know there are tons of PDF programs out there, but finding one that is free and will work for me, is a little difficult especially when I am not too sure as to...
  8. E

    Question Access_Form and Outlook: How to email a pdf attachment?

    so I am assumign ADOBE PDF Write, inbeds itself into access, so that when I am doing my vba code, PDF will become an accepted format? if this is indeed the case, then I will try to get adobe pdf writer
  9. E

    Question Access_Form and Outlook: How to email a pdf attachment?

    Hello all, I have a MS Access 2003 and MS Outlook 2003. I have an Access database, where I have a form which I use to automate a process to send emails through outlook and I attach a 'report' with that email. The thing is this report is sent as SNP format, I am wondering if it is at all...
  10. E

    moving textboxes/labels through vba?

    I have a line I am trying to move through vba: CASE "ECO" .line26.left = 60 .ine26.width = 10980 'This code works, my line displays fine This code does not work: CASE "LAN" .Line26.Left = 1140 .Line26.Width = 9900 'notice i reduced the width so that it fits in the same page. Even if I...
  11. E

    moving textboxes/labels through vba?

    Text6.Left = 2773 Cool thanks! now to play around with the twips number lol ah guessing time I guess ;o edit: actually there is 1440 twips in 1 inch, and lucky the property box of any label/textbox tells me their position in inches, so it should not be too hard. thanks all.
  12. E

    moving textboxes/labels through vba?

    Through the help and suggestion of this board users, I have a CASE driven code for my report I am working on. I am hiding/showing (visible=true/false) some textboxes/labels. Now, I am wondering if I can also move textboxes/labels through vba coding? For example, What would be the syntax to...
  13. E

    Syntax wrong? or what could it be?

    thank you all.
  14. E

    Syntax wrong? or what could it be?

    wow i like this, it has a cleaner look to it. I will implement it. BTW, suppose if case was "ECO" say I wish for: .FinalRecert_subrep_01.Report.Text31.Visible = True 'ECO .FinalRecert_subrep_01.Report.Label32.Visible = True 'ECO these two, to move closer to each other, or say i wish to move...
  15. E

    Syntax wrong? or what could it be?

    Sorry for not replying, im at work and have a ton on my hands. I am not that experienced with coding. I am not sure how to beging with a select caase statement? Though, I have asked a friend at work abuot my issue and he fixed it for me. Apparently I had the code in the wrong spot. Instead...
  16. E

    Syntax wrong? or what could it be?

    Hello all, I am making a report, that containts a subreport. I am hiding and showing (visible =false/true) on some textboxes/labels to achieve the display I want. I have somewhat accomplished this but not exactly. Let me post my code first: Option Compare Database Private Sub...
  17. E

    Problem with my little code

    thank you guys for you help, I will try to get this to work, if not Ill have to ask for help tomorrow or so. THank you once again
  18. E

    Problem with my little code

    Im not sure I understand you, sorry
  19. E

    Problem with my little code

    thanks that was great information. the name of my subrep on my report is Child12 so that is the container name I am assuming. Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Child12.Report.Text7.Visible = False Me.Child12.Report.Text10.Visible...
  20. E

    Problem with my little code

    Thank you for help BobLarson. I am submitting the screenshot of my design view, and the error I am receiving after implement your suggestions. On the design view screenshot: on the subreport in the detail section, where the textbox uid appears, there is two other text boxes behind it, text7...
Back
Top Bottom