Recent content by Design by Sue

  1. D

    How much download / upload

    Yes, I would imagine it is using data. Way to check is look at your settings (on the iPhone it is in Cellular) and check your data usage. Then do some work on the database then check your data usage again. That should give you an idea of the impact of the data used by accessing the Access...
  2. D

    Adding Calculated field via VBA

    I am updating an existing database with a front and backend. I need to add a calculated field to an existing table in the backend. I have searched but can't find any info on how to do this. Anyone have any idea of how to accomplish this? As always, thanks Sue
  3. D

    Problems getting access to site

    My programmer wishes to be able to post to the forum. He has tried to sign up but has somehow gotten locked out. Every time he tries to log in he gets a yellow message telling that the account has not been confirmed. He clicks to get an email but it never comes. He has checked his spam folder...
  4. D

    Image in output to Word Document

    darbid -will look into your code, thank you! vbaInet Thank you for looking into this further. Your copy and paste seems to be what darbid's code is doing and the path to the image is where we started. Currently the images are in image controls. When we created this report, we looked into...
  5. D

    Image in output to Word Document

    Sorry "any other ideas" was what I meant by "anyone else". As I stated in my first post is that we are trying to avoid having an external file for the artwork that needs to be included in the Word document. The suggestions made, though I thank folks for taking time to offer suggestions, have...
  6. D

    Image in output to Word Document

    Thanks but no help here - anyone else?? Sue
  7. D

    Image in output to Word Document

    burrina -this needs to be automated. skipepl - will check out the links - thanks Sue
  8. D

    Image in output to Word Document

    We need to replicate an Access report we have in Microsoft Word. The report has a fixed, small image in the header and so we embedded it in the report (it is not in an external file). To put this image in the Word document the only way we’ve come up with is shown in the code below. Dim apWord...
  9. D

    Exporting with custom name

    Close but this doesn't give the user a window to select the location - the location needs to be programmed in - and I can't do that. Sue
  10. D

    Exporting with custom name

    When the file is saved, a browse window opens. In the browse window the file is automatically named with the name of the report and the user browses to where they want to save the file. (The user can manually change the name but we want to avoid this extra step) The could browse and save the...
  11. D

    Exporting with custom name

    Thanks - but we will not know the path to the saved document.
  12. D

    Exporting with custom name

    I have created 2 reports one that needs to be exported as an excel file and the other report as a PDF file. I have the exports working correctly for each on a button except this saves the files with the name of the report. The client wants the name of the file to appear as one of the fields on...
  13. D

    Alter Table statement to add field and make it unique

    Found it: For anyone else with this question
  14. D

    Alter Table statement to add field and make it unique

    I am using the following to add a column to an existing table. How do I make this column indexed with no duplicates? Thanks Sue
  15. D

    Deleting a table relationship in VBA

    Can someone help me with this please. I have an existing database and need to add a primary key to one of the tables. I can't do this because there are one to many relationships from that table so I need to remove the existing relationships before I make the primary key and then put the...
Top Bottom