I walk. I talk. I shop, I sneeze. I'm gonna be a fireman when the floods roll back. There's trees in the desert since you moved out. And I don't sleep on a bed of bones.

Buffy ,'Chosen'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


meara - Oct 25, 2017 8:10:32 am PDT #25107 of 25496

My issue is mostly that I'd still be paying the cable company for internet...but I'm also waiting to see what my next bill is, since I dropped all the fancy cable last month and just kept local channels (...but mysteriously am still getting cable like HGTV and USA, just not in HD??). Also then I'd have to give up my TiVo, which would also save money but I've had one since 2002!


-t - Oct 25, 2017 8:19:41 am PDT #25108 of 25496
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration

That would be a big adjustment! I get my internet from Comcast and my TV from DirecTV right now, and that should probably change regardless. I do already have my Hulu subscription which I am pretty happy with, but the live TV and recording aspects of YouTube are enticing.


Tom Scola - Oct 25, 2017 1:26:52 pm PDT #25109 of 25496
Mr. Scola’s wardrobe by Botany 500

I did a trial of Sling TV, but it was when it first came out, and it wasn't very good.


Liese S. - Oct 27, 2017 5:24:36 pm PDT #25110 of 25496
"Faded like the lilac, he thought."

There is a standalone TiVo now that you can use for streaming, I think, but it's expensive.

So, what database platforms are all the cool kids using these days? I just need to build something relational, do a little sql reporting. It's what I would have built in Access last time I was industry adjacent. Would it still be Access? Is there an Open Office thing? Should I just build it on some cloud thing to begin with, since it may later morph into the basis for app development?


DXMachina - Oct 28, 2017 2:30:09 am PDT #25111 of 25496
You always do this. We get tipsy, and you take advantage of my love of the scientific method.

I'm still an Access fan, although it's been five years (yikes) since I've done anything in it professionally. I think the cool kids would use sql calls from web pages because, you know, the cloud. Access is still probably the best bet if you want to avoid that. LibreOffice does have a db application as part of its suite, but I haven't used it, so I can't opine.


Liese S. - Oct 28, 2017 1:07:11 pm PDT #25112 of 25496
"Faded like the lilac, he thought."

Ok, cool thanks, DX.


dcp - Oct 29, 2017 4:12:35 pm PDT #25113 of 25496
The more I learn, the more I realize how little I know.

Hah! I just now noticed that in Gmail, when I go to my "Sent" folder, the search field displays "in:sent".


DCJensen - Nov 06, 2017 8:11:51 pm PST #25114 of 25496
All is well that ends in pizza.

Speaking of Access...

Can any of my database-savvy friends assist with some hints as to how I should proceed with an access database I'm making? At work, they keep giving me excel spreadsheets for different tasks, and none of them are relational. THere's even one (Below Top) that I'm supposed to copy and paste into a sheet for each team member. They are not linked, so to see a team member, I have to find the right sheet. Really. Since I have access to Access, I decided to re-create the Spreadsheet as an actual core database, and hope to pull all the various spreadsheet data into one DB as I work. I've gotten this far (Below Bottom) but can't figure out how to reproduce the month/day fields so they can just be clicked upon to select the proper one. I'm temporarily using a rough "scheduled days" and "Hours" in the attempt, but it's not as useful.

Any suggestions?

[link]

[link]


DXMachina - Nov 07, 2017 2:59:30 pm PST #25115 of 25496
You always do this. We get tipsy, and you take advantage of my love of the scientific method.

Daniel, a question. I'm assuming that the grid shown in link 1 specific to one team member, with each team member having their own version of the grid.

In a database, you wouldn't duplicate the grid in a table. You set up a table with entries for each team member for each day, then reconstuct the grid using a query (and/or a report).

It seems to me that you could get by with two tables. The first would have a record for each team member with all the information you show in your form in link 2. In that table you also need to give each team member a unique ID. Then the second table would consist of three fields per record - [Team Member ID],[Date],[Attendance Code]. The table won't be visually useful the way your spreadsheet is, but you can use a query to build the grid for a given team member that draws only the records with the correct team member ID.

You could fancy it up with a third table that contains the symbols and explanations for the attendance codes.

Does any of that make sense?


DCJensen - Nov 07, 2017 8:08:14 pm PST #25116 of 25496
All is well that ends in pizza.

I do like the idea of adding a table with the [Team Member ID],[Date],[Attendance Code]. Even if I can't make it look the same, at least I can pull up the information to show my own manager

I'm probably not explaining this very well.

I am trying to make it so I can type in a team member, number, or another field for a team member, and have their page come up. I have made the back end with the fields you see in the photo.

The "spreadsheet" they have me using right now indicated in the first picture might as well be a series of images for all the interaction one has. Each square has to be filled by hand with a letter or number and then colored by hand. I'd like to be able to click on a and select one of the choices for the status for that person.

I created a database with all (soon to be more) of the fields you see there (except the date grid), and I then used that DB to design an approximation of what work uses.

In the end, hat I am hoping to do is to be able to keep adding to the main DB, and be able to pull off different outputs specific to the needed forms. This is just the most complicated one they use and I thought I would start with the hard one, and go from there. Oops.

For instance, I have another spreadsheet with each person's coaching plan, each person's upcoming training, and other key data. I have several spreadsheets at work that could be pulled from this one main DB, if I had a coherent table in my access DB.

I hope this makes sense.