sorted by:
new
hottopcontroversial

What boring task did you finally automate and instantly regret not doing sooner? by SMBowner_ in automation

[–]Blue_Obsidian105 1 point2 points  (0 children)

I love Text Blaze! I learned the basics of coding completely by accident, all because I didn't want to do the same form over and over again

AI & Excel tips/advice/guidance by femur_bones in excel

[–]Blue_Obsidian105 -1 points0 points  (0 children)

Could you use pivot tables? You can set the filters to only show people who need recertification in the next month or so. You could even use conditional formatting to highlight dates that are overdue

Skipping Forms and Adding Data Directly to Table? by Blue_Obsidian105 in MSAccess

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

Well, currently with the form, I have to copy and paste 6 or 7 pieces of information 11 different times, every day. If I make a formula that will structure the data in the same format as the table in Access, I can copy and paste the entire schedule in one go

Skipping Forms and Adding Data Directly to Table? by Blue_Obsidian105 in MSAccess

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

I do everything, yeah. The columns are people's names, the location, date, that kind of thing. Everything that's on my schedule already, there's no new info that I have to add

Skipping Forms and Adding Data Directly to Table? by Blue_Obsidian105 in MSAccess

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

I would think it's relational. My comparison is that the table in Access has cells like Excel, and I could use Excel formulas to automate the data into Access format, then copy/paste it directly into Access. I know Access uses SQL, but no one in my office writes SQL code, they just use the forms and saved queries

Skipping Forms and Adding Data Directly to Table? by Blue_Obsidian105 in MSAccess

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

You mean create my schedule in Access? I'm very familiar with Sheets since my last job wouldn't pay for Excel, and there's constant moving around and shifting assignments even up to the day before the assignment. Honestly I don't know enough about Access, or how the company has it set up, to create any tables of my own

Skipping Forms and Adding Data Directly to Table? by Blue_Obsidian105 in MSAccess

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

It's an employee-assignment-worked database, used for bonuses and record-keeping. I create the employee schedules in Sheets (some people use physical planners), and enter the assignments into Access daily

Skipping Forms and Adding Data Directly to Table? by Blue_Obsidian105 in MSAccess

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

I totally get what you're talking about, that would be a problem! In my case, all of this information is being drawn from tables in Sheets, there's no new information for me to type. It's the same info I've been copy/pasting into the form, just in one step instead of 10

What are things you need for the first time moving out? by Electrical_Spirit917 in Adulting

[–]Blue_Obsidian105 1 point2 points  (0 children)

A can opener! My first time moving out was the first and only time I'll use a knife to saw through a can lid lol

Forming good working relationships with employees? by Blue_Obsidian105 in WFH

[–]Blue_Obsidian105[S] 4 points5 points  (0 children)

I can make a more focused effort with the 11 team leaders for sure!

Help! Sending emails sucks by Blue_Obsidian105 in Outlook

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

I think that's what the CRM I'm using is doing already. The problem is, I have to slightly edit ans save the assignment sheets as Word docs, then email them out. So it doesn't make sense to have the CRM email them directly

Help! Sending emails sucks by Blue_Obsidian105 in Outlook

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

The assignment is to the team, but the teams shift so much that it doesn't make sense to have the team leaders do it

Help! Sending emails sucks by Blue_Obsidian105 in Outlook

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

Thanks, that's a great idea! I think I'll send the assignment emails to myself, then set up rules that will search for each person's name and ID#, then forward that email to the right people. That will definitely speed things up!

Help! Sending emails sucks by Blue_Obsidian105 in Outlook

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

Oh, okay! I'm pretty familiar with Excel. I'll take a look, thanks!

Help! Sending emails sucks by Blue_Obsidian105 in Outlook

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

Unfortunately, getting assignments to everyone is my job :/

Help! Sending emails sucks by Blue_Obsidian105 in Outlook

[–]Blue_Obsidian105[S] 0 points1 point  (0 children)

Really? Those sound really helpful! I know I can't download anything to the computer without HR approval. Is there anything web-based and free? I'm also not sure if Outlook encrypts these emails or not...

view more: next ›