Search results

I'm not sure I can see how a subform would change the issue, it would only allow me to display the table data, as I do now, but it still doesn't let me simply display a list of the values and let the user choose one line of factors to use. Thanks for the suggestion though. The more I think...

Trying to use a form based on a table to choose a recordset of values, and pick the ID of that recordset to include in another table as a foreign key. I am not sure how to even search for what I'm trying to do, though I've tried all the variants I can think of anyway. The idea being that there...

To further expound upon this, I needed to simply find the number of days in a month, from a format of month/day/year, which I obtained by modifying Valery's formula in this way: Day(DateSerial(Year([dteFcstPrd]),Month([dteFcstPrd])+1,1)-1) in the query. There may be a simpler form of this...

I resolved my issue for anyone else looking at this: I put an afterupdate command on my combo box that set the value of a hidden text box to be equal to the associated column from the combo box unless it was "All" in which case it set it to "*" such as this: Private Sub...

Thanks, that's a variant I hadn't tried, but no dice. I still get a blank selection set.

First I apologize if I'm not supposed to post on a <Solved> problem, but for me this does not solve my problem, but it does match my situation. I've encountered this issue as well, but the statements above do not fix my problem. I'm attempting to write the query so that it's not hard coding...

Excellent, that did exactly what I was looking for. I was just over-complicating the procedure with a function call that wasn't necessary. *Note: In answer to my earlier question it appears that fso.command is simply for external file manipulation while inside of an excel file. For instance...

Thank you, but I've tried that, this is what I get-> run-time error '438': Object doesn't support this property or method Unfortunately that is my issue. Unless there's another implementation I'm unaware of in my searching. Edit: hmm, unless you're referring to the Excel.Application command...

I'm attempting to set up a locked excel file to be used as a framework that has a command button with vba code attached that will save the edited file as a new file name. The code seems to work, insofar as it does time stamp and rename the file as I intend. The problem I'm encountering, is that...

That got me pointed in the right direction, thank you. I didn't end up using a union query, but otherwise matched what you suggested. making using of the running count, I was able to split my temporary data table into two query's, and append the two back into another temporary table (I had an...

Hmm, yes that does sound viable, and was what I was working towards, but unable to determine a method for doing. Let me fiddle around with it and see what I can come up with. Thank you.

I'm sorry, but that still doesn't make sense to me. if I used the even count number on a data set such as I appended then the calculation would be based off point number 356. However, that point is in the middle of the line, and if I attempted to do a distance calculation between the beginning...

Actually no, that doesn't make sense to me. Allowing that I might be misunderstanding, if I used your example above, you'd be having me do a calculation between the number 2's, as in between hole 39 and hole 40. But they're not correlated data, they're from two separate holes. I'm actually...

Well, the problem with the running sum is that it fails if there's ever more than two points to a hole, and that will almost always occur for at least one entry in each job. and that could be either an odd, or an even number of points. Hence my preference to key off the combination of...

There is the possibility of having more than two points per hole, though they are usually only two. Calculations are all on a per hole basis, for this particular step, though there are subsequent groups, and summaries that would be generated downstream in the reporting step. Points will always...

Using the data in the jpg, I will need to start by doing my calculations between line one and line two. Then between three and four to get the next set of results, etc. Previously I've always manipulated data on a line by line basis, much like an awk script would do. What I'm attempting to do...

That is not an incorrect representation though. Point 39, and point 40 represent spatial coordinates on the state plane survey system for Alaska Zone 1, and show the beginning and the end coordinates of a line segment. I'm attempting to coalesce the coordinates from the two lines within a query...

I am currently attempting to import a CSV data file that lists information in a top down format that I need to convert to a compacted flat file form for further calculations and manipulation, but cannot figure out how to to do so. I believe I'm missing something basic in how I'm doing my select...

I haven't even been able to find the right criteria to search for in the forums to get meaningful information, so I'll pose this question, and hopefully someone can answer, or point me to the correct keywords. I wish to make an update query which would populate a table based on the number of...

Solved my own question finally. Took quite a bit more digging through answers and examples. :banghead: The criteria needed to be changed to check the table for null values, as the <1 evaluation doesn't check correctly to pull the blank toggle items out of the table: SELECT tblHdngNm.txtHdngNm...