Recent content by Weekleyba

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

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...

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...

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...

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?

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...

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?

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.

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...

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...

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.

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?

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...

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...

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...