Search results

Good afternoon. I have to build load sheets for a web based third party application my company uses. - I build the data in Access. - I export the data out to a text file using DoCmd.TransferText. - Once the text files are saved I need to manually open each one. Once open I use File -> Save As...

Honestly I have never even heard of it.

I had a union query. I found some issues with the source data and had to make some changes. When I went to run the union query I got an error message. I did not want to go through the 20 separate queries to figure out what worked and what did not. This data is used to build load sheets. My...

Another question. This is setup to put this data into a table. Is there a way to call the data up from the module in a query?

I figured it out. There format of the numbers was different depending on the field. Examples of what I needed are: 0.90 2.405 61.00 24.05 This is how the data is stored in the table that feeds Query3. I do not need the Nz function on all the fields so I removed them. I added a Format function...

No. Half of the attributes are text and the other half numeric. I know I can manually go in to each field in the query and write a format statement. I do not want to do that. The data sets support specific product lines. The one I am working on now has (20) fields. My other product line has...

If you are talking about setting the Property Sheet for the field in the query to something like General Number, Fixed, or Standard with two decimal places I have tried that. It looks like the code converts all the Attribute Data to text. I have used union queries in the past. I have about...

Waking this thing up from the dead. I am using this code and it is working great with the exception of one issue. Here is what I am using for code: Option Compare Database Public Function ReverseCrosstab() Dim rstin As DAO.Recordset Dim rstout As DAO.Recordset Dim fieldloop As Integer Set...

That worked perfect! I tried "If Not IsNull([Expression]) Then". I did not know to add the "rs!" to it.

Are you saying that I should have two mapping tables, use one for cleaning and the other for importing?

@arnelgp - I have a question on the CleanExcel function. I am working with (52) fields. It takes (12) minutes to format the data. In an attempt to shorten that time I tried leaving the expression field in the mapping table blank for the fields that do not need formatting. I get an invalid use...

@arnelgp - that is pretty much what I did. The data that I am importing has a date field denoting when the data was either added or changed. It is changed due to errors. I needed the previous date so I can see what has been added or changed since the last update. Thanks everyone for your help.

I used the one you initially posted. That was what was there when I clicked on the link. I updated it and am getting the result I need. So now how do I use it in an update statement?

No, it is not. I do not want the most current date. I want the date just prior to the most current date.

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!