Search results

  1. W

    Solved PNG Logo in Generated PDF not Printing Clear

    Thanks Crystal! Linking the image resulted is a very clear pdf.
  2. W

    Solved PNG Logo in Generated PDF not Printing Clear

    I have a pdf that is generated with the following code. The problem I have is the logo in the upper left corner, that I brought in as a png, does not print clearly once the pdf is generated. If I print it directly from the report, it prints nice a sharp. See comparison below. Any ideas how to...
  3. W

    Solved Table Not Sorting Correctly

    Thanks guys for all the responses. I think this was either a user issue (maybe deleting and re-entering data) or a glitch somewhere. I deleted the seven entries and inputted them back in and all is well. I choose to do this after spot checking a half dozen of other records in the same table...
  4. W

    Solved Table Not Sorting Correctly

    I have a table that is used in a database that does not seem to sort correctly for one particular data number in the a field. I'm puzzled on this one. See below. I've sorted for only ContractID: 147. Note both the ContractLineItemID and LineItemNum do not sort Ascending. I've check other ones...
  5. W

    Solved Combining Two Queries with Same Field

    They are both queries but I think I may have figured it out. I used a union query and it seems to give me what I want. I really needed to get all the ProjectIDs in one query to use as input for a chart. Does this seem like the correct use for a union query?
  6. W

    Solved Combining Two Queries with Same Field

    I have two queries A_Q and B_Q. (simplified the names) Each gives a list of projects that will be funded, based on different funding limits for each and uses a Balance field where the criteria is >0, to show only the projects that can be funded. Both queries have a unique ProjectID, but have...
  7. W

    Solved Referring to Custom Field Name Within Query

    Well, it appears that you cannot review to renamed field within the same query. I guess... I got rid of the renamed fields and referred to the field with the related query that it came form. Is that reason?
  8. W

    Solved Referring to Custom Field Name Within Query

    How do I fix this? I have a query, were I've renamed a field. I then am referring to that field in another fields expression. When I do, it asks for the renamed field parameter. See below.
  9. W

    Solved DoCmd.RunSavedImportExport for linked Table

    It worked! Maybe I spent two much time on it last night... When you Import a text file and chose Append, you cannot change field type. It just does not show up. See below. But for Import and Link, you can change the field type. The way I have it set up now, is table is linked to the csv file...
  10. W

    Solved DoCmd.RunSavedImportExport for linked Table

    I think I'll give up on trying to link it. I'll just have each FE import the file when they open the database. Even though the file is 16MB (125K rows), it will still work. It's not live, but the csv file it's linked to, is only generated once a day at the most. One of the complications...
  11. W

    Solved DoCmd.RunSavedImportExport for linked Table

    When I link the external csv file to the tempBE table, I get a different looking table. See below. The link then to the FE, no longer works.
  12. W

    Solved DoCmd.RunSavedImportExport for linked Table

    So Pat I don't quite follow. I get that my FE table is linked to the tempBE table, but how is the tempBE table updated? How then does the tempBE table get updated from the new csv file? How does the "Append to the table linked to the tempBE" work?
  13. W

    Solved DoCmd.RunSavedImportExport for linked Table

    I’m on the road right now but I’ll be able to look at it again later tonight and tomorrow. But when I try to redo the import it gives you three choices. Import, append, link. I am trying to import data from a text file CSV. The only option that allows you to save the import is the first option...
  14. W

    Solved DoCmd.RunSavedImportExport for linked Table

    For some reason I'm not tracking here. If I go through the steps to Import, it does not import to my BE but rather to my FE. I'm trying to get the FE to import the table in the BE. Below is what I have. VBA for the "Import" button circled in red. I think the problem is this is not able to...
  15. W

    Solved DoCmd.RunSavedImportExport for linked Table

    Yes, that is correct. So now I see why it doesn't work. Now....I'm stumped on how to fix it. Here's what I'm trying to do. Our admin downloads a large Excel csv file from another program. My database imports the new data from the csv file via the Import command button. Prior to splitting the db...
  16. W

    Solved DoCmd.RunSavedImportExport for linked Table

    I have split database that has a Import button the executes the DoCmd.RunSavedImportExport command which first runs a query to delete data in the table to be imported and then executes the saved import. The saved import take a MS Excel cvs file and imports the data to single table in Access...
  17. W

    Database Suddenly Won't Share - laccdb Issue?

    Keep getting this error.
  18. W

    Database Suddenly Won't Share - laccdb Issue?

    My IT is having difficulty figuring out this problem. We tried a different server but the same result. Anyone else having this issue?
  19. W

    Database Suddenly Won't Share - laccdb Issue?

    Ah....MS strikes again I see. This fix is out of my wheelhouse. I'll send it on to IT and see if they can fix. Thank you for your response.
  20. W

    Database Suddenly Won't Share - laccdb Issue?

    I have four different split databases that have there backends on the same server. Yesterday, suddenly only one person could work in them. The rest would get a runtime error. I also noticed the laccdb file will not close when everyone has closed the database. This happened to all four...
Top Bottom