Recent content by bretdunlap

  1. B

    access to Outlook Choose From Email

    I can't seem to find an easy solution. I have a default email in outlook but when I call an outlook email from access, I get the outlook "from" address no the default one:banghead:. Is there a solution?
  2. B

    Creating a ms publisher document

    Thanks for the suggestion I have tried placing in almost every spot I can think of and sill nothing. I even tried placing set in front of your code. Any more suggestions?
  3. B

    Creating a ms publisher document

    I can successfully create a ms Pub doc and import what I need the challenge is I can't seam to figure out how to change the orientation to landscape. Private Sub Command393_Click() Dim wObj As Object Dim SText As Variant Dim PubDoc As Object Dim pbshape As Object...
  4. B

    Export to excel problem

    glad it helped :) this form has helped me so much I am glad I could give a little back.:):D
  5. B

    Export to excel problem

    In addition I had to click the Microsoft Excel 12.0 library
  6. B

    Export to excel problem

    Found a work around added this to my merge code basically it opens and saves the file. Dim XLapp As New Excel.Application Dim ObjXL As Excel.Workbook Set ObjXL = XLapp.Workbooks.Open("C:\Users\James Bret Dunalp\Desktop\Office Forms\Import excel\Family to exce query...
  7. B

    Export to excel problem

    I have a challenge with an export. I can easily export my query to excel when I open it is there. The challenge is when I use ms pub or word to merge the data. I have a tab that calculates some of data. so I need to use that data, I can see it whne I open it as well. The problem is wehn I...
  8. B

    Copy Form data

    I don't have any of that just a basic table with data the auto number changes when I cop it and the student Id is unique but I only make the Id after I have copied the file.
  9. B

    Question Ms Publisher VBA

    Can any one direct me to VBA/code for MS publisher 2007 I want to do some date calculations in a text box when I open it much like Ms word. I have look and can'r seam to find any resources.:D
  10. B

    Copy Form data

    "not quite right and is not properly normalized" in what way
  11. B

    Copy Form data

    Basically I was doing this to save me time re typing 90% of the info
  12. B

    Copy Form data

    Repeated fields when I copy it ? every thing is repeated if that is what you are saying I have a unique field in the id but I don't generate that until after I change the name of copied record ie I copy john smith then open it up and change it to sally smith then I hit a button the creates a...
  13. B

    Copy Form data

    does any one have an idea?
  14. B

    Copy Form data

    Hi I have a form and a button it to copy the data to save me time when 99% is duplicated Ie If I enter 2 siblings data I fill one out then copy it and only change the siblings name a bdate. Then problem is it does copy the data but locks up the form. I have t X out the form when I do a...
  15. B

    Ms Publisher and Ms access mail merge?

    I am running windows 7 and access 2007 same with pub When I do a mail-merge from pub I can see some Queries but not all. and thoughts?
See more
Top Bottom