Search results

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

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

Keep getting this error.

My IT is having difficulty figuring out this problem. We tried a different server but the same result. Anyone else having this 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.

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

Thanks guys for the additional ways to accomplish this. Very appreciated. #tricksofthetrade#

Thank You! You made it clear to me now. I’m going to print this out and tape it to my computer. Thanks again.