Search results

Im so bad at naming. I went from one extreme to the other and didnt even notice it.

Here are the changes I have made to the loop so far. I changed the recordset variables again to have better names (I have a really bad habit with keep them as short as possible). I dropped all the With blocks per Pats suggestion. I also removed the INSERT INTO query I was creating and running...

I immersive myself in a task, generally a game and start with a goal to achieve such as unlocking something. The act of accomplishing that typically helps pop me back out of the funk but sometimes it takes several days. In the summer rather than a playing a game, I will go outside and fire up...

So to remove the With's, rather than doing With....!FieldName I would just remove the With and do RS.FieldName? Edit: Figured this one out quickly enough.

So many replies since yesterday. I read everyone's thoughts and will start making some revisions based on the input and see what I come back with. It makes sense to not open the recordset every single time within the loop, so that is most definitely an adjustment I will make. I will also add...

Could the With block be removed?

That is fair. I already am going to backtrack on that as just glancing through all my modules, it would be quite the pain to make that change at this point.

I just ran a check and that first one got flagged (yay option explicit) where I missed it when renaming all my variables per Sonics suggestion. I didn't notice that with CurrentDB and honestly didnt know I could do that. I will make that change :). I did notice that in one form or another, I...

I just noticed when I moved setting the second recordset higher up before posting that I moved it up to before I set that value. Derp. I moved it back down to just above where I work with said recordset. For the second part, it is mostly due to the fact I know how to exclude them this way and...

As this was one of my first ventures into DAO without seeking help I wasn't sure how it would behave if I started naming my variables the same as the fields themselves. If that doesn't cause issues, I will most certainly change it. Actually, I will make the change regardless and just add a...

I just wanted to post one of my modules that I successfully wrote from scratch with more or less no help for once and see how I did. This works exactly as I intended it to for committing essentially transactions to various reels of wire and solves an ongoing problem I had been having with...

For argument sake, here is the full module that I added the query into. Was a super simple query but was unsure how it would interact within the workspace/transaction environment. Dim rs As DAO.Recordset Dim Crs As DAO.Recordset Dim wrk As DAO.Workspace Dim SID...

I was thinking that it was unlikely that docmd would work. I can easily break the queries into strings and do database.execute. Actually, that would probably be the more preferable way as I can pass variables into the queries more easily to get what I am after.

I wasn't able to find a straight forward answer to this so am hoping one of you could answer it before I invest time in something that wont work :giggle: . When dealing with DAO and transactions, if I have some update queries run in the loop, if for whatever reason the process fails, will what...

When the problems progressed beyond just memory management, I had completely wiped my primary hard drive and reloaded a fresh install of windows and the problem didn't improve at all. I did manage to test the PSU last night and Doc was right, the voltage was was higher than it should be and...

That would be correct as I would assume if it was under voltage, I would have gotten temperature shutdowns from the hardware overheating due to it. Either way, the computer will likely be "office spaced" when its all said and done.

I had considered driver problems and such. Not long after having tested the RAM I had completely reformatted my drives and did a fresh windows install and update and the problem persisted. I did not however think the PSU could cause the problem. I will pull it out and run a voltage test on it...

To those who are more versed in hardware then myself, any idea what could cause constant BSoD's? The error varies when it crashes, but the most common one I see if Memory Management. I also see Kernel errors, Corrupted Page errors, IQL (dont know if thats right, its some 3 letter acronym) and...

I wasn't able to figure out how to do it via a query and gave up. I managed to solve my problem however by doing it via code and DAO. In all my testing, it provided the results I expected. ID = [Forms]![frmWireRoom]![WireColorsSubCntrl].[Form]![WireColorLengthSubFrm]![ColorWireID] Set rs =...

The many-to-many table is what is causing the problem? On the form, they are selecting a reel that they are going to cut wire from. So they select X reel with Y footage and when they print the label, it needs to deduct the length from that reel. The overall process is: - The user select the...