![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
My foreseeable schedule
Mar. 3rd, 2020 07:27 amWednesday 3/4 = Shadowplay @ Haltom Theater
Friday 3/6 = Panoptikon
Saturday 3/7 = cleaning up files at old job / evening Six Flags job
Sunday 3/8 = self-training on SAP utilizing Robert Half's SkillPort access and possibly SAP's own free online training / evening Six Flags job
Mon-Fri next week 3/9-3/13 = RH job - 6F job - maybe some sleep, maybe
Sat-Fri 3/14-3/20 = rinse and repeat through Six Flags' 2nd spring break week - maybe get caught up on sleep Sat/Sun mornings
Then back to RH job M-F and 6F job on weekends until summer hits.
Friday 3/6 = Panoptikon
Saturday 3/7 = cleaning up files at old job / evening Six Flags job
Sunday 3/8 = self-training on SAP utilizing Robert Half's SkillPort access and possibly SAP's own free online training / evening Six Flags job
Mon-Fri next week 3/9-3/13 = RH job - 6F job - maybe some sleep, maybe
Sat-Fri 3/14-3/20 = rinse and repeat through Six Flags' 2nd spring break week - maybe get caught up on sleep Sat/Sun mornings
Then back to RH job M-F and 6F job on weekends until summer hits.
Work, Bitches!
Feb. 29th, 2020 10:40 amI got my new job!
I start on Monday!
I'll be an accounting consultant with the SPS (Salaried Professional Services) wing of Accountemps, which is a Robert Half company, so that's who I'm technically working for. It means being able to go around to different companies learning new accounting systems, and I'm excited about their learning and tuition reimbursement program. I just might go for my CPA license after all.
My first contract is with an oil and gas company in downtown Fort Worth that could be anywhere from 2 -12 months long. The position I will be filling is Staff Accountant, and a 2nd consultant will join me in 2 weeks after her current contract finishes up. I'll be on the 21st floor of one of the high rises! This fact alone makes me squee.
It required 5 interviews with a total of 7 people, and there's still others for me to meet with eventually, but it only took a couple weeks in total. There was only one other job I interviewed for, but it's in an office with only 4 (soon to be 3) other people, and I'm a bit tired of small offices at the moment. I want to get out and be a bit more social.
Also, I'm picking up weekend and evening shifts working at Six Flags in their cash control office. I have to build back up my savings due to surgery, pinched nerve issues, car getting scraped, and other misc emergencies that the roommates have run into that I've been covering for them. I also have to spend a little extra on a few more professional outfits, since the last time I had to wear any sort of penguin suit to work was back when I was 18-19 and working in the administrative offices of the YMCA. I enjoy Six Flags, and this side job is fun (to me), inside for 95%-100% of the work shift, we HAVE to wear plain clothes so as not to be identified as employees since we're vault staff, and we even have our own restrooms and break room to discourage leaving our building too often. It's a tight knit little group of co-workers, most of whom are like me - older than your typical Six Flags employee and using this as a second job. So we tend to talk about our day jobs and families a lot.
I'm excited and actually looking forward to working this year at both places.
I start on Monday!
I'll be an accounting consultant with the SPS (Salaried Professional Services) wing of Accountemps, which is a Robert Half company, so that's who I'm technically working for. It means being able to go around to different companies learning new accounting systems, and I'm excited about their learning and tuition reimbursement program. I just might go for my CPA license after all.
My first contract is with an oil and gas company in downtown Fort Worth that could be anywhere from 2 -12 months long. The position I will be filling is Staff Accountant, and a 2nd consultant will join me in 2 weeks after her current contract finishes up. I'll be on the 21st floor of one of the high rises! This fact alone makes me squee.
It required 5 interviews with a total of 7 people, and there's still others for me to meet with eventually, but it only took a couple weeks in total. There was only one other job I interviewed for, but it's in an office with only 4 (soon to be 3) other people, and I'm a bit tired of small offices at the moment. I want to get out and be a bit more social.
Also, I'm picking up weekend and evening shifts working at Six Flags in their cash control office. I have to build back up my savings due to surgery, pinched nerve issues, car getting scraped, and other misc emergencies that the roommates have run into that I've been covering for them. I also have to spend a little extra on a few more professional outfits, since the last time I had to wear any sort of penguin suit to work was back when I was 18-19 and working in the administrative offices of the YMCA. I enjoy Six Flags, and this side job is fun (to me), inside for 95%-100% of the work shift, we HAVE to wear plain clothes so as not to be identified as employees since we're vault staff, and we even have our own restrooms and break room to discourage leaving our building too often. It's a tight knit little group of co-workers, most of whom are like me - older than your typical Six Flags employee and using this as a second job. So we tend to talk about our day jobs and families a lot.
I'm excited and actually looking forward to working this year at both places.
More asses
Feb. 27th, 2020 07:21 amYesterday I was given another assessment to take. QuickBooks 2010. It has some multiple choice, a couple drag-n-drop matches, and some QB-simulators. The simulator only allows for possible clicks that lead toward a correct answer, and if you click in the wrong direction the first time, it will give you the option of Retry, which indicates immediately that you were heading in the wrong direction with that last click. If you don't get it the second time (or do get it, but you'll never know for sure until you get your test results), you just have to click the Answer Complete and move on to the next question.
Note that I said QB 2010. A system that is now 10 years out of date and doesn't have the same menu structure nor helpful user-friendly interface as what's currently available.
I wanted to pull my hair out, I felt so much like an idiot suddenly incapable of tying her own shoes. I still haven't seen the test results, but I did contact the person asking me to take it and let him know how much that test hurt my sensibilities, and was there any chance he could send me a more current QB test version, even if the client is using 2010? I'd like to be able to show that I'm not a complete moron when it comes to this program.
He sent me QB 2019. Oh thank the blessed gods. As far as I could tell, only one simulator question gave me a problem, but everything else was fine. I should be getting my results today.
Note that I said QB 2010. A system that is now 10 years out of date and doesn't have the same menu structure nor helpful user-friendly interface as what's currently available.
I wanted to pull my hair out, I felt so much like an idiot suddenly incapable of tying her own shoes. I still haven't seen the test results, but I did contact the person asking me to take it and let him know how much that test hurt my sensibilities, and was there any chance he could send me a more current QB test version, even if the client is using 2010? I'd like to be able to show that I'm not a complete moron when it comes to this program.
He sent me QB 2019. Oh thank the blessed gods. As far as I could tell, only one simulator question gave me a problem, but everything else was fine. I should be getting my results today.
I have asses.
Feb. 6th, 2020 02:00 pmI have taken 4 assessments for a recruiter in order to show proficiency in the areas of 1) Bookkeeper Knowledge, 2) Credits and Debits, 3) Payroll, and 4) Excel 2016 - Intermediate.
Is it wrong of me to point out a transposition error that I found in one of the payroll charts on the Payroll assessment?
Well, I hope they appreciate it, since they are, after all, assessing me for a higher-pay-than-typical accounting consultant gig, and she specifically said they hope to hire candidates that can do more than just drudgery data entering for their clients.
Now, I need to find a firing range to brush up on my non-existent shooting skills (ref: The Accountant).
Is it wrong of me to point out a transposition error that I found in one of the payroll charts on the Payroll assessment?
Well, I hope they appreciate it, since they are, after all, assessing me for a higher-pay-than-typical accounting consultant gig, and she specifically said they hope to hire candidates that can do more than just drudgery data entering for their clients.
Now, I need to find a firing range to brush up on my non-existent shooting skills (ref: The Accountant).
3am, and still wide awake when I'm supposed to be getting my beauty sleep for tomorrow's, er....today's job fair. It doesn't help that my nose has decided now would be the perfect time to develop a sinus infection. What's worse is that it's either viral or a super-resistant bacterial, considering I've had 4 rounds of antibiotics since September, and am still finishing off this last round, due to my underarm issue. I better not start running a fever between now and 2pm, at least not until after I've hit the job fair. My blessed honey bourbon is helping my throat, but not really helping me to get back to sleep. Arg.
State of Me
Mar. 8th, 2018 06:35 amStill holding on precariously to sanity with 2nd job not quite done with layering on the madness. I figure about two more weeks and then I'll start to see the semblance of a regular weekly workload. Maybe. Hopefully.
I'm exhausted. I'm snapping at people and have lost all patience for anything. It's not just the two job thing, although that obviously is an added pressure. It's me thinking about future things. The uncle still in the hospital. The other uncle and aunt that I finally saw for the first time in a few years at the hospital. Dad announcing he'll finally try to retire before the end of this year. Mom always having back pain. I worry about them dying now, and what kind of pressure that will create for me regarding the boys and my sister. The idea of going back to grad school always hangs over my head.
Speaking of the uncle, he's now officially on hospice, although who the hell knows for how long.
( Details )
I'm chalking a good portion of my mental state up to the family side of things. Work stuff is busy, and drama-filled, but otherwise actually helping with my mental state as I knock tasks off of the to-do list. Waiting for someone to die and thinking about others around me dying, on the other hand, is no proper mental state for anyone. It's causing me to become a grumpy bitch, and I'm really not fit for social interactions right now, even though I know good social interactions are typically the cure. I'm just too worried I'll piss people off being bitchy instead of being comforted by their presence. Like I said, I've lost all patience - I'm too tired for that.
The end result is me having a hard time opening my eyes every morning and wandering the world with constant, massive jaw and neck tension. I think I've had some form of a permanent crick in my neck for the past two weeks now. I don't have enough Valium in the cabinet.
I'm exhausted. I'm snapping at people and have lost all patience for anything. It's not just the two job thing, although that obviously is an added pressure. It's me thinking about future things. The uncle still in the hospital. The other uncle and aunt that I finally saw for the first time in a few years at the hospital. Dad announcing he'll finally try to retire before the end of this year. Mom always having back pain. I worry about them dying now, and what kind of pressure that will create for me regarding the boys and my sister. The idea of going back to grad school always hangs over my head.
Speaking of the uncle, he's now officially on hospice, although who the hell knows for how long.
( Details )
I'm chalking a good portion of my mental state up to the family side of things. Work stuff is busy, and drama-filled, but otherwise actually helping with my mental state as I knock tasks off of the to-do list. Waiting for someone to die and thinking about others around me dying, on the other hand, is no proper mental state for anyone. It's causing me to become a grumpy bitch, and I'm really not fit for social interactions right now, even though I know good social interactions are typically the cure. I'm just too worried I'll piss people off being bitchy instead of being comforted by their presence. Like I said, I've lost all patience - I'm too tired for that.
The end result is me having a hard time opening my eyes every morning and wandering the world with constant, massive jaw and neck tension. I think I've had some form of a permanent crick in my neck for the past two weeks now. I don't have enough Valium in the cabinet.
Storm Front
Feb. 2nd, 2018 06:56 am2nd job is still hectic, but we now have phones, internet, computers, desks, and coffee (the essential ingredient).
I have decided that I HATE Frontier Communications, and I've only been dealing with them for the past two weeks. The problem is that I have been dealing with them nonstop for the past two weeks regarding stuff that we thought should have been done a month ago. I called National Telesystems and they came to the rescue. They got our phone lines fixed (couldn't dial out), redesigned the electrical board for all the boxes (Frontier managed to mount the modem so you can't slide it out of its mount to get the internet info off the bottom of it and didn't bother mounting the surge protector and internet switch but just left them precariously perched on top of other equipment) and set up our phones, voice mail, and music on hold all within a day, and I had only called them two days prior.
Geek Squad also came out to set up all our computers, because I didn't have the time to do so, and really it's one of those things that I hate having to do, remove unwanted junk, install wanted programs, set up printers. Ugh. It's just ugh work that I don't like doing. Luckily National Telesystems and Geek Squad were there at the same time and worked with each other to fix the lack of outbound calling fuck up created by Frontier. I was grateful. The Geek Squad guy was pretty cute, too. So yeah, I was probably being a little flirty.
We're slowly but surely getting log in info for all our vendors and accounts and bears, oh my. I finally got in touch with the (official) accountant to finalize our Chart of Accounts so I can get it entered into Quickbooks and then match that up with the Price Guide and get that all entered into Excel so that I can import it into our dispatching system. The order that things must flow in order to function is sometimes maddening. Bosslady is bringing me signature cards for our bank accounts so I can finally log in to those and start comparing them with Quickbooks, and I at least now have a contact person for our payroll, but that person still hasn't called me back, so twiddling my thumbs on that front.
Anyway, lots of stuff happening to keep me busy.
And then I have a huge stack of invoices to get entered and year-end tax stuff to process at my other regular full time job. So that's staying busy as well.
And then there's this sleep schedule that I'm not fond of and that is doing its best to doom me to eternal sluggishness.
Weeeeeeeeeeeeeeeeeeeeeee.
I have decided that I HATE Frontier Communications, and I've only been dealing with them for the past two weeks. The problem is that I have been dealing with them nonstop for the past two weeks regarding stuff that we thought should have been done a month ago. I called National Telesystems and they came to the rescue. They got our phone lines fixed (couldn't dial out), redesigned the electrical board for all the boxes (Frontier managed to mount the modem so you can't slide it out of its mount to get the internet info off the bottom of it and didn't bother mounting the surge protector and internet switch but just left them precariously perched on top of other equipment) and set up our phones, voice mail, and music on hold all within a day, and I had only called them two days prior.
Geek Squad also came out to set up all our computers, because I didn't have the time to do so, and really it's one of those things that I hate having to do, remove unwanted junk, install wanted programs, set up printers. Ugh. It's just ugh work that I don't like doing. Luckily National Telesystems and Geek Squad were there at the same time and worked with each other to fix the lack of outbound calling fuck up created by Frontier. I was grateful. The Geek Squad guy was pretty cute, too. So yeah, I was probably being a little flirty.
We're slowly but surely getting log in info for all our vendors and accounts and bears, oh my. I finally got in touch with the (official) accountant to finalize our Chart of Accounts so I can get it entered into Quickbooks and then match that up with the Price Guide and get that all entered into Excel so that I can import it into our dispatching system. The order that things must flow in order to function is sometimes maddening. Bosslady is bringing me signature cards for our bank accounts so I can finally log in to those and start comparing them with Quickbooks, and I at least now have a contact person for our payroll, but that person still hasn't called me back, so twiddling my thumbs on that front.
Anyway, lots of stuff happening to keep me busy.
And then I have a huge stack of invoices to get entered and year-end tax stuff to process at my other regular full time job. So that's staying busy as well.
And then there's this sleep schedule that I'm not fond of and that is doing its best to doom me to eternal sluggishness.
Weeeeeeeeeeeeeeeeeeeeeee.
Error, 'ill Ribonson
Feb. 17th, 2017 03:31 pmI'm working with the guy that's the design/implementation manager (or some such title) for the new roll out of the dispatching program we use at work.
I started as a beta tester for this new system, and he's been working with me over the past two weeks on getting reporting and downloads from his system into my own database to work with each other. It works well, because I get my data and he gets reports from me about issues I run into, which being OCD and trying to make two sets of data match perfectly means I seem to inadvertently run into ALL the issues.
This one in particular was quite fun:
ERROR: operator does not exist: character varying + unknown
I copy/pasted it into an email to him with the comment:
"I know MY character can be varying and unknown, but sheesh, does the report have to point that out to me? lol"
I really hope I'm more of source of amusement for him and his co-workers than a poking thorn in the side, seeing as I'm reporting something almost daily.
Incidentally, his last name is Robinson, so it's constantly taking everything in my power not to say, "Danger, Will Robinson! Danger!" at any point during our emails. I feel certain that any person with last name Robinson no longer thinks of that as a funny joke.
I started as a beta tester for this new system, and he's been working with me over the past two weeks on getting reporting and downloads from his system into my own database to work with each other. It works well, because I get my data and he gets reports from me about issues I run into, which being OCD and trying to make two sets of data match perfectly means I seem to inadvertently run into ALL the issues.
This one in particular was quite fun:
ERROR: operator does not exist: character varying + unknown
I copy/pasted it into an email to him with the comment:
"I know MY character can be varying and unknown, but sheesh, does the report have to point that out to me? lol"
I really hope I'm more of source of amusement for him and his co-workers than a poking thorn in the side, seeing as I'm reporting something almost daily.
Incidentally, his last name is Robinson, so it's constantly taking everything in my power not to say, "Danger, Will Robinson! Danger!" at any point during our emails. I feel certain that any person with last name Robinson no longer thinks of that as a funny joke.
Many Hours Later
May. 20th, 2016 07:58 amThe explorer.exe was continuously crashing, and after searching online, this seems to be a common malady of the upgrade to Windows 10.
( The Dirty Little Details )
So far, it's working. It only took me 9 hours (less the time I stopped to work on the permits), all to rename a single file.
Fucking Windows 10 upgrade. Grrr.
( The Dirty Little Details )
So far, it's working. It only took me 9 hours (less the time I stopped to work on the permits), all to rename a single file.
Fucking Windows 10 upgrade. Grrr.
The all-in-one workstation
Coincidentally, I started having torso pains again yesterday afternoon which continued into my evening dinner plans and are still going pretty strong this morning. I could do with a laying-down-ish option right now, because mentally I want to be working on my database (I'm giving up one huge level of subforms given how much headache it's causing me and reworking it into a more manageable solution), but sitting here at the desk isn't exactly pain-free, and that laid back desk option looks like it would be a prefect solution for me right this moment.
Coincidentally, I started having torso pains again yesterday afternoon which continued into my evening dinner plans and are still going pretty strong this morning. I could do with a laying-down-ish option right now, because mentally I want to be working on my database (I'm giving up one huge level of subforms given how much headache it's causing me and reworking it into a more manageable solution), but sitting here at the desk isn't exactly pain-free, and that laid back desk option looks like it would be a prefect solution for me right this moment.
Database Fizzled
Apr. 20th, 2016 11:31 pmAccess kept shutting down unexpectedly (after I was having issues with a single macro running), which prompts it to make a backup file automatically, and Google Drive is where everything is housed, but that keeps randomly giving "Cannot Connect" messages and going offline, even though the rest of my internet is pounding away just fine.
Between Google trying to keep up with the multiple copies uploading and Access continuously, unexpectedly closing, followed by Google giving up completely and deleting ALL the files, I've only managed to snag about 90% of the database I've been working on at work. That 90% is currently split into two different database files, one with corrupted VBA, but from what I can tell almost all the forms, tables, queries, etc. that I had as of the last save, and one with good VBA, but missing the forms and associated programming from the previous two days worth of work. At one point Google/Access gave me a file labelled "Backup of Backup of Backup of Backup of Invoices DB Backup Copy" I was on the verge of tears thinking the database would be completely gone at that point.
I blame the tug of war between the two giants while little ol' me sits in the middle of the carnage.
What I'm most angry about is that I had one of those random sparks of combined insight and energy and was able to accomplish in the past two days about as much as I'd gotten done the whole previous two weeks. So, the loss of a huge chunk of VBA programming, along with knowing I'll be spending the better part of tomorrow sewing these two files back together, has me irked to no end. Yes, there was a backup file already, but Google does Versions of files in spurts, which was why the previous versions I could find are missing the last couple days' worth of work. If only the VBA wasn't giving errors in the more complete file...
I think I'm going to start manually backing up this sucker to my hard drive as well, especially after making large amounts of changes.
Between Google trying to keep up with the multiple copies uploading and Access continuously, unexpectedly closing, followed by Google giving up completely and deleting ALL the files, I've only managed to snag about 90% of the database I've been working on at work. That 90% is currently split into two different database files, one with corrupted VBA, but from what I can tell almost all the forms, tables, queries, etc. that I had as of the last save, and one with good VBA, but missing the forms and associated programming from the previous two days worth of work. At one point Google/Access gave me a file labelled "Backup of Backup of Backup of Backup of Invoices DB Backup Copy" I was on the verge of tears thinking the database would be completely gone at that point.
I blame the tug of war between the two giants while little ol' me sits in the middle of the carnage.
What I'm most angry about is that I had one of those random sparks of combined insight and energy and was able to accomplish in the past two days about as much as I'd gotten done the whole previous two weeks. So, the loss of a huge chunk of VBA programming, along with knowing I'll be spending the better part of tomorrow sewing these two files back together, has me irked to no end. Yes, there was a backup file already, but Google does Versions of files in spurts, which was why the previous versions I could find are missing the last couple days' worth of work. If only the VBA wasn't giving errors in the more complete file...
I think I'm going to start manually backing up this sucker to my hard drive as well, especially after making large amounts of changes.
Counting Sheep
Apr. 18th, 2016 03:24 amNothing like waking up at 2:30am thinking about a programming issue that HASN'T EVEN COME UP YET (it's an issue with overwriting a lookup/calculated field in a data entry form that I haven't started creating yet), only to find the answer to the issue and hopefully be ready to fall back asleep by 3:30-ish (give or take some blog entry writing time).
On one hand, I hate waking up in the middle of the night thinking about things like this, but on the other hand, finding a solution quickly does help ease the mind a bit.
Triple bonus sheep points for figuring out a solution to a problem of which I only subconsciously was aware.
Negative 5 sheep for my nose deciding this hour of time awake is the perfect time to have an allergy attack.
Plus 2 sheep for getting to listen to the thunderstorm outside.
I think I'm slightly ahead, but my nose will be the deciding factor once I lay my head back down on the pillow.
On one hand, I hate waking up in the middle of the night thinking about things like this, but on the other hand, finding a solution quickly does help ease the mind a bit.
Triple bonus sheep points for figuring out a solution to a problem of which I only subconsciously was aware.
Negative 5 sheep for my nose deciding this hour of time awake is the perfect time to have an allergy attack.
Plus 2 sheep for getting to listen to the thunderstorm outside.
I think I'm slightly ahead, but my nose will be the deciding factor once I lay my head back down on the pillow.
When You Really Need It
Apr. 16th, 2016 09:15 amIf you ever really need help with MS Access and would like to have a nice giggle in the process, check out the Access All In One YouTube channel.
James Conway runs these videos. What's great about his tutorials is that not only is he pretty quick and detailed, he's also very human. He has the occasional brain fart. He plays with showing what you can do with colors on a datasheet to the point that even he declares the color scheme he has selected to be "foul, truly foul." And he's constantly throwing in impromptu one-liners, like in this snippet, when he notices that his Access window isn't well-centered.
I find great, simplistic joy in watching his videos.
From his channel, on the right, you will see related channels, and I highly recommend PC Learning Zone with Richard Roth, as well as austin72406 (I think he says his name is Te Wan, but I don't see it in print anywhere, so not sure if it's spelled correctly) who gives some quite excellent videos on various form search options. I tried out Simon Sez It but found most answers were better met via the other three channels or specific Goggle searches for each particular problem I run into (which I seem to be running into them all in alphabetical and numerical, in the case of runtime errors, order).
Most of my errors have something to do with the fact that I'm utilizing all of my wide-screen monitor space and have 4 levels of embedded subforms on my main customer history and invoice processing screen (because I'm actually able to combine them into one screen instead of two), which isn't unheard of, but a little over the top. I'm attempting to resist pop-up entering forms as much as possible, which leads me to such madness (as my blog title declares). Trying to reference a control or field in one subform from a different subform when both are at the bottom 4th level in the hierarchy can be quite interesting. I'm starting to be a little less confused on the references between a form in datasheet mode and a form in continuous form mode (which gave me fits for about a day while I was treating a continuous form made to look like a datasheet AS a datasheet while trying to get Access to select a particular record within the data set), as well as the difference between where the cursor is on a form versus where Access has it's focus, which also affects things like being able to access a control's .Text or .Value properties.
I'm having way too much fun with this.
James Conway runs these videos. What's great about his tutorials is that not only is he pretty quick and detailed, he's also very human. He has the occasional brain fart. He plays with showing what you can do with colors on a datasheet to the point that even he declares the color scheme he has selected to be "foul, truly foul." And he's constantly throwing in impromptu one-liners, like in this snippet, when he notices that his Access window isn't well-centered.
I find great, simplistic joy in watching his videos.
From his channel, on the right, you will see related channels, and I highly recommend PC Learning Zone with Richard Roth, as well as austin72406 (I think he says his name is Te Wan, but I don't see it in print anywhere, so not sure if it's spelled correctly) who gives some quite excellent videos on various form search options. I tried out Simon Sez It but found most answers were better met via the other three channels or specific Goggle searches for each particular problem I run into (which I seem to be running into them all in alphabetical and numerical, in the case of runtime errors, order).
Most of my errors have something to do with the fact that I'm utilizing all of my wide-screen monitor space and have 4 levels of embedded subforms on my main customer history and invoice processing screen (because I'm actually able to combine them into one screen instead of two), which isn't unheard of, but a little over the top. I'm attempting to resist pop-up entering forms as much as possible, which leads me to such madness (as my blog title declares). Trying to reference a control or field in one subform from a different subform when both are at the bottom 4th level in the hierarchy can be quite interesting. I'm starting to be a little less confused on the references between a form in datasheet mode and a form in continuous form mode (which gave me fits for about a day while I was treating a continuous form made to look like a datasheet AS a datasheet while trying to get Access to select a particular record within the data set), as well as the difference between where the cursor is on a form versus where Access has it's focus, which also affects things like being able to access a control's .Text or .Value properties.
I'm having way too much fun with this.
Tangled Webs
Feb. 22nd, 2016 08:32 pmLolotehe recently took care of the issue of cat pee on a couple bags worth of yarn for me. She washed the bags and skeins of yarn and then spent the next week or so unraveling the tangle that was created as a result of the washing. I helped for an hour or two one evening while we were hanging out. It was a project and a half.
That's about how I feel at work right now. There's been zero tracking systems to coordinate incoming email service requests, match invoice numbers to work order numbers, match payroll lines to invoices actually paid and make sure things haven't been paid out twice or have at least been paid in the first place, or even tracking of incoming payments from customers. Right now I'm trying to gather all the tangled threads into a couple of simple cross-referenced spreadsheets, but it's so damned time consuming it feels like I'm moving at a snail's pace. And the repetitiveness of posting all the invoices from a few months worth of notepad sheets into this spreadsheet and then cross referencing them over to this second spreadsheet is mind-numbing even for a person like me.
Right now, all I see are branches of numbers and spreadsheets entangling me to the point that I almost feel like I made a mistake changing jobs. I know it's just the discomfort of not being on top of, well, anything bookkeeping related at work right now. I know soon all this sorting of 10,000 decks of cards will start forming some semblance of organized chaos instead of just multiple stacks of chaos. I just wish it would hurry up and get there already.
That's about how I feel at work right now. There's been zero tracking systems to coordinate incoming email service requests, match invoice numbers to work order numbers, match payroll lines to invoices actually paid and make sure things haven't been paid out twice or have at least been paid in the first place, or even tracking of incoming payments from customers. Right now I'm trying to gather all the tangled threads into a couple of simple cross-referenced spreadsheets, but it's so damned time consuming it feels like I'm moving at a snail's pace. And the repetitiveness of posting all the invoices from a few months worth of notepad sheets into this spreadsheet and then cross referencing them over to this second spreadsheet is mind-numbing even for a person like me.
Right now, all I see are branches of numbers and spreadsheets entangling me to the point that I almost feel like I made a mistake changing jobs. I know it's just the discomfort of not being on top of, well, anything bookkeeping related at work right now. I know soon all this sorting of 10,000 decks of cards will start forming some semblance of organized chaos instead of just multiple stacks of chaos. I just wish it would hurry up and get there already.
Come, Mr Tally Man
Dec. 31st, 2015 08:01 amTally me banana.
"It's your last day at work. What are you going to do next?"
"I'm going to Six Flags!"
No, really. The boys are out of school and wanting to go to Six Flags, so I'll be heading straight there after wishing my desk good luck with its next occupant.
They could have picked a chillier day to go, but not by much.
"It's your last day at work. What are you going to do next?"
"I'm going to Six Flags!"
No, really. The boys are out of school and wanting to go to Six Flags, so I'll be heading straight there after wishing my desk good luck with its next occupant.
They could have picked a chillier day to go, but not by much.
3 More Days!
Dec. 29th, 2015 06:54 amYesterday was my last day in the Fort Worth shop of my current company. Thursday is my last day in the Dallas shop and for good.
I've been working an hour a day, three days a weeks, for the past couple weeks at the new location. I'm having to start from scratch teaching my new boss accounting 101, what a chart of accounts is, how JEs are different than checkbook register entries, etc., but I love it. I love being able to go back to my accounting roots and set up an entire company from scratch and explain to someone how all this works.
I've also been putting in time on my own researching and playing with the trial Quickbooks online. There's still some kinks to be worked out regarding how we will be processing invoices at the new job. I know how they need to be processed, and I can always create an Excel or even Access database (or go all MySQL fancy, or some such), but it would be nice to find a ready-made, cheap solution already out there. Combing through available softwares is a bit of a nightmare.
I'm really excited about changing jobs now, compared with the utter dread I was feeling when faced with the prospect of needing to get away from my present employer. Now I am just grinning at work through gritted teeth reminding myself that all this stuff will no longer be a worry of mine come the new year. I can't wait.
I've been working an hour a day, three days a weeks, for the past couple weeks at the new location. I'm having to start from scratch teaching my new boss accounting 101, what a chart of accounts is, how JEs are different than checkbook register entries, etc., but I love it. I love being able to go back to my accounting roots and set up an entire company from scratch and explain to someone how all this works.
I've also been putting in time on my own researching and playing with the trial Quickbooks online. There's still some kinks to be worked out regarding how we will be processing invoices at the new job. I know how they need to be processed, and I can always create an Excel or even Access database (or go all MySQL fancy, or some such), but it would be nice to find a ready-made, cheap solution already out there. Combing through available softwares is a bit of a nightmare.
I'm really excited about changing jobs now, compared with the utter dread I was feeling when faced with the prospect of needing to get away from my present employer. Now I am just grinning at work through gritted teeth reminding myself that all this stuff will no longer be a worry of mine come the new year. I can't wait.
I Need a Doctor
Jan. 10th, 2015 06:59 amI spent most of yesterday packing up most of my work office, and that includes other offices as well, since we'll be moving over 3 office sets instead of just one.
I'm already sore and tired. I have two guys doing the moving with me today. I'm hoping when we get over there everything will be done and we'll be able to move the pieces straight into the office and set them into place based on the floor plan I came up with.
I was hoping today would be Torchwood; Children of Earth watching with the nephews, but I don't know if I'll be able to stay awake for 5 hours straight. Then again, by the end of the move today, I won't be able to stand for long, so sitting for 5 hours straight might be a blessing.
I'm already sore and tired. I have two guys doing the moving with me today. I'm hoping when we get over there everything will be done and we'll be able to move the pieces straight into the office and set them into place based on the floor plan I came up with.
I was hoping today would be Torchwood; Children of Earth watching with the nephews, but I don't know if I'll be able to stay awake for 5 hours straight. Then again, by the end of the move today, I won't be able to stand for long, so sitting for 5 hours straight might be a blessing.
More Changes
Jun. 12th, 2014 09:06 amWe've officially rolled our CSR and Dispatch lines to our Dallas office, so I've been in the office by myself starting this week.
On one hand, it's keeping me away from being CSR and dispatch back up (or primary, as has been the case half of my work week for the past couple months). That's freeing up a little bit of my time in general. Funny thing, though, in the past three days I've been more bombarded with emails than I typically ever am, and I've stayed pretty much just as busy if not more so with new random fires that have popped up this week. I hit 50 hours last week and I'm probably going to be pretty close to that again this week.
Today and tomorrow I'm being shadowed by another staff person who's still more or less in training for learning the business systems. She's the owner's sister, and I admit, I'm not completely sure I understand what her exact role is, but anyone that ever sees me do my work after a few days refuses to take my place when I offer them my job, and I don't think she'll be any different. I *think* she'll be taking over the accountant liaison's role when our current A/P person retires here shortly. My shadow called yesterday asking about why I send her a slew of emails with vendor receipts and POs in them, which I've been doing since she took over paying the vendor bills a month (or was it two?) ago, so I thought it was odd that she was asking me that question after so long a period of time. Once I explained it to her, I think things started clicking really well in her mind, and she suddenly realized that my emails will save her quite a lot of time when she's processing the bills. Regardless, I think she could very much stand to have the extra training with me, but most importantly, she definitely needs to see what I do in my office all day. Bossman doesn't actually know what I do with my time all day, and telling him "my job" doesn't amount to anything, so having her see and be a liaison for me to him will kind of benefit me and my job security in the long run.
On one hand, it's keeping me away from being CSR and dispatch back up (or primary, as has been the case half of my work week for the past couple months). That's freeing up a little bit of my time in general. Funny thing, though, in the past three days I've been more bombarded with emails than I typically ever am, and I've stayed pretty much just as busy if not more so with new random fires that have popped up this week. I hit 50 hours last week and I'm probably going to be pretty close to that again this week.
Today and tomorrow I'm being shadowed by another staff person who's still more or less in training for learning the business systems. She's the owner's sister, and I admit, I'm not completely sure I understand what her exact role is, but anyone that ever sees me do my work after a few days refuses to take my place when I offer them my job, and I don't think she'll be any different. I *think* she'll be taking over the accountant liaison's role when our current A/P person retires here shortly. My shadow called yesterday asking about why I send her a slew of emails with vendor receipts and POs in them, which I've been doing since she took over paying the vendor bills a month (or was it two?) ago, so I thought it was odd that she was asking me that question after so long a period of time. Once I explained it to her, I think things started clicking really well in her mind, and she suddenly realized that my emails will save her quite a lot of time when she's processing the bills. Regardless, I think she could very much stand to have the extra training with me, but most importantly, she definitely needs to see what I do in my office all day. Bossman doesn't actually know what I do with my time all day, and telling him "my job" doesn't amount to anything, so having her see and be a liaison for me to him will kind of benefit me and my job security in the long run.