Search results

Is there a method I can use to total related child records for the parent record without making the records not updateable? A totals query gives me what I am after, but you cannot update a totals query. Long story short, I am adding cost modifiers to an original cost where the modifiers are in...

Im having another slight issue with this same module. I am working on a different file now and trying to find if a string beings with an asterisk, but I cant seem to get my if statement to ever return true. If Left(.Range("D" & i), 1) = "*" Then sNote =...

That is pretty neat!

I see. Thank looks soo much simpler than messing with a tree view. Thanks MajP!

Thought of another topic in regards to form design. Is there a means to replicate the drop down/tier list like you can see in tables? It would be pretty neat for a few forms I have if I could replicate that kind of functionality. Edit: Looks like the control I am looking for is the TreeView...

That was the problem. I expanded the range to not be just a single column, but from A to C and now it is going into the second for loop on the correct lines but now the copy/paste isnt doing anything :ROFLMAO:. Ill just fix that after lunch. Edit: Fixed it. This works exactly how I wanted it...

Minty, for some reason my condition is never met for line 4 and I can't seem to figure out why. Did I mess up the syntax on it? With ws.Range("C:C") LastR = .Cells.Find("*", ws.Cells(1, 3), xlFormulas, xlPart, xlByRows, xlPrevious, False).Row For i = LastR To 2...

Yeah I have learned that you do tend to get creative to make Excel files work with your table structure in Access. Sometimes Excel files dont have a lot of rhyme or reason to their formatting.

Now why didn't I think of that as that is simple. This what I get for trying to code first thing in the morning. Thank you Minty!

Not sure if this should be in the Excel subforum or the modules as it is being done from Access but dealing with Excel. I can't seem to word my question right for Google to provide me direction, so I apologize if this is a really simple one. Below is a snip of an example file: I am looping...

It appears so. I am just going to go the route of using a "helper" field that will allow me to sort as needed.

That is very informative Doc, but also way over my head :ROFLMAO:. I get the idea of what you are saying though.

I understand what you are saying Doc :giggle:. How the table itself looks when viewed, is of no consequence as I know it can get all messed up but as long as the data gets inserted into the table sequentially, that will enable me to take my queries for a form and sort by the autonumber field...

Correct. I am just trying to make sure it ends up in my destination table correctly as I can then set the data to sort via the autonumber field in my queries. Previously I had a field where the user could input the order in which they wanted to sort by was received overwhelming feedback on how...

The method I had used in the past was just a simple transferspreadsheet and while it would work most of the time, about 1 out of 6 or so imports it would append it in a full garbled mess. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "tblTempImport", strfile, True This is what...

I assumed as much and figured adding a sort of "helper" field that I can sort the data by regardless of the order in which it was appended to the table would likely be the way to go.

What would be the best method to import an Excel file into a table aside from docmd.transferspreadsheet? The main reason I am avoiding it this go around is that you cant guarantee the order in which it will write to the table and I need to maintain the order of the data. I know one simple...

No worries here. Just wanted a discussion on form designs and such and am having fun learning the various details I had no clue about.

I try to not do more than 3 or 4 subforms on any given form and never more then 2 deep (main -> subform -> subform in subfom) as the referencing gets screwy past that but thankfully have never run into a situation where I had to go any deeper and dont know why someone ever really would have to...

I think the most I have ever managed to cram onto a form was 4, maybe 5. I did not know Access had a limit on that but it makes sense that it would. That is good to know!