Search results

OK thanks. I never such problems existed. I ran the code and got the the latest pull date.

You have more experience than I do but I have never seen an autonumber field not kick out the next sequential number from the last number it generated. There would not be an earlier date with a higher ID value. I do not want the latest date, I want the second to latest date in the field. Using...

When I hear the words calculated field I think of something else but as I am mostly self taught IDK if I have been thinking incorrectly all this time. The date values in Table2 are added to the table by the code that refreshes the data in Table1. The ID field auto-populates. The latest date...

The dates are stored as records in another table. How is it a calculated value?

I have two tables. Table1 is updated once a month. I have added a date field named "last_pull". I am attempting to populated that field with data from Table2. Table2 has two fields - an autonumbered "ID" field and a "pulled" field. The pulled field is a record of all Table1's update dates. The...

@arnelgp - I finally got a chance to use this and it works great. Thanks for the help with this!

Thanks for the replies guys. @arnelgp - I played with what you sent me and it worked on doing a quick test. I have something else I need to get done before a meeting tomorrow so I will not get a chance to do anything with this until after that.

I did that and have the code but do not how to use it in VBA. Yes I did that before I posted on here.

After you posted that I did the import and saved the steps. I tried using DoCmd.RunSavedImportExport but still had a problem. The Excel file has has multiple sheets so it would need more steps to convert it to a CSV. I found this here and tried this with one of options listed about 3/4 of the...

I went to try your idea and Access. When I import a text file there is an Advanced option that lets me save the import specs I have set up. I am not seeing that when I import an Excel file. All I have is the "Save Import Steps" at the end. Would this be the same thing?

I use the data in the Excel to build (7) individual data sets that are used as load sheets to get our data into another system. I have a macro set up that runs all the code/queries to get it done. I am looking for something that can be added to that macro so it is done automatically. I do not...

That sounds like a plan. Would it require : - "blanket" code that automatically looks at each column and adjusts as needed - Individual code be written for each one of the (90) fields There is nothing here. When I say nothing I mean there is no leadership. There are no...

Good morning all. There is an Excel file that was created and is maintained by multiple coworkers. I have to work with the data in that file so I currently have it as a linked table in my Access db. I ran my query and found empty cells where there should be data. Looking at the linked table I...

I have no experience exporting/building an XML file from Access. I am also not an Access wizard. I am looking for specific and hopefully easy to follow instructions on how to do what I need to do.

I did some of the tag pairs in Notepad and saved it as an XSD file but I am not sure how to "connect" the two. When I use Access's export feature I am not seeing where I can select my own schema.

Good afternoon. I use a program that builds a data set in an Access db and then converts that data into an XML file. I modify the data in the Access db and then go into the program and run out the XML file. I have to do this multiple times as we need different XML files. The XML file is in a...

It is not bad data. These are vehicle makes and models. It is also includes offroad/aggricultural/industrial stuff such as generators, combines, backhoes, whatever. It is a pretty wide array of stuff so there are going to be variances in the model names. We also use our own custom names at...

It is not consistent and as we add more data the patterns could keep changing so I figured out another way to link to our Make and Model tables.

I am all set. I did not figure out how to split them up but I did figure out how to link the data to our Make and Model tables and get the data that way.

I have some data in a field. It is basically Make and Model data. Some fields have vehicle type added in: AUDI-RS5 / RS5 SPORTBACK VOLVO - TRUCKS - MEDIUM / HEAVY DUTY-VNM SERIES WHITE - TRACTORS-2-110 CASE - EXCAVATORS-688B CK I would like them to be separated into two different Make | Model...