Posts by Daniel Thompson9

Quick question about PowerPoint 2007.

So, here's the weird thing: when I'm working on slide 4 and decide to toss in a transition—let's say the "Grid" one—and then I trigger the slideshow starting right from that specific slide, the transition hits the whole screen. Like, the entire slide area, even all that empty white space, gets hit by the effect.
But get this—if I start the whole presentation from the very beginning at slide 1 and just click through until I hit slide 4, the transition behaves totally differently. Instead of covering the whole slide, it only applies itself to the actual elements sitting on the slide, leaving the background alone.

Can anyone make sense of why it’s acting so glitchy like this?

Thanks for the help!

Benjamin King2 said:Access doesn't actually support that kind of syntax for building tables: http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

I mean, what's even the point of what you just typed? You’ve already got a table full of all that data, so why on earth would you want to recreate the exact same table with the exact same info? 😕

Look, I get that the syntax isn't a perfect match—I was just throwing that out there as an example so you guys could see the end goal I'm aiming for. 🙂

So here's the deal: some students sent me this database they built, right? It's got maybe 30 different tables, all tangled up in these complex relationships, and there's tons of data in there—some tables have over 300 rows. Basically, they built the whole thing using the GUI, thinking they could just hand over the .accdb file, let the professor open it up, look around, and call it a day. But no! The professor wants to see the actual code—all those commands used to build the tables, set up the relations, and dump the data. Naturally, these kids aren't about to sit there and manually type out every single command to rebuild it from scratch. They just need a way to export everything into a .txt file or some kind of .sql script where all those commands are visible.

EDIT: Okay, just found out Access doesn't actually have a feature for that, so thanks to you and -Y- for looking into it.

Benjamin King2 said:Wait, what do you mean by "SQL code" for a table? A table is just a standard object—it doesn't have its own "code." You just jump into Design View and set up the structure there.

Look, imagine you've already got this table for Authors built out with columns for First Name and Last Name, all filled with actual data.

For instance...
First Name | Last Name
Pero Perić
Đuro Đurić

But here's the thing—what I actually need is this:

CREATE TABLE Author(
FirstName TEXT,
LastName text
)

INSERT INTO Author (FirstName, LastName) VALUES ('Pero', 'Perić')
INSERT INTO Author (FirstName, LastName) VALUES ('Đuro','Đurić')

Hey, does anyone know how I can actually dig up the SQL code for a table that's already been built in Access?
The whole thing was put together using the standard GUI.

I'm working with Access 2010 and an accdb file format.

rustysurfer79 said:$167 + sales tax for the absolute best combo of a laser printer and color inkjet. We're talking 3000+ prints plus another 200.

Man, I'm stuck because I really need a scanner. It's a huge deal for me. I don't buy books, I just borrow them from the library and scan everything myself.

rustysurfer79 said:The Epson Stylus and the Epson Stylus Express are basically two different beasts, even if they look similar.

If you're a college kid on a budget, honestly, the smartest move is just grabbing an Ink & Toner Bundle for that kind of cash. .

So, what's the damage? I don't really know what laser printers go for these days—I only saw one basic black-and-white unit sitting around for $233 which felt like way too much money for what you actually get.

As for the scanner on the Epson Stylus, it worked totally fine for me; everything I needed to see came through crystal clear. Maybe people just don't bump up the resolution settings enough—you know, making it take a little longer to scan—if they’re trying to catch those tiny, super fine details.

So, I used to run an Epson Expression Home—you know, the whole three-in-one deal with the printer, scanner, and copier. I picked it up about three years ago for roughly $167, and at first, I stuck strictly to the original ink. Eventually, I switched over to those third-party replacements, like the T110 black ones I think, which only ran me about 20-$10. Honestly, for just grinding through student papers, it was totally fine. Most of my stuff was just black and white, maybe some color here and there. The only real headache? If even a single color runs out, the thing just refuses to print anything at all, even though the scanner still works perfectly fine. I went through a ton of pages, but after two years, I found myself having to run the head cleaning cycle way more often—probably because I was using it so much more—and occasionally it would smudge a few lines of text.

Now, I’m looking to grab another Epson that lets me use those same cheap replacement inks; I spotted an Epson Stylus for around $167. Once I get that, I'll probably pass this old workhorse down to my sister.

Anyway, yeah, that’s just my experience with Epson.

Hey everyone!

Does anyone recognize what kind of chart this is in Excel? Like, how do I actually build something that looks like this? My data is just 5 columns by 19 rows.

Here’s a shot of my table:
View on imgur

And here’s the image of the mystery graph I'm trying to replicate:
View on imgur

If you guys don't know how to pull this off in Excel, can you suggest some other software where I might be able to make it happen?

Kyle Johnson2 said:Just pop -5 or -6 into cell C1.
code : Private Sub Worksheet_Activate

Wait, hold up—are we really trying to run an equation like `=1,55*10^-$C1`?

Look, I’ve been staring at spreadsheets since I was a kid, and seeing a formula written out like that just feels... off. It’s like trying to drive a muscle car using a lawnmower engine. If you're sitting there in Excel trying to pull off some scientific notation magic, you've gotta make sure the syntax isn't tripping over itself.

In the US, we usually stick to the standard way of doing things in Excel to keep everything running smooth. If you're trying to multiply 1.55 by ten raised to the power of whatever is sitting in cell C1, you should probably format it like this: `=1.55*10^-$C1`.

See that little difference? Using a decimal point instead of a comma. It sounds like a tiny thing, but it’s the difference between a calculation that actually works and a total meltdown where Excel just stares back at you like you're speaking gibberish. Don't let a single misplaced character turn your whole workbook into a disaster zone!

Look, it’s totally up to you—if you need to divide by 100 or whatever number gets you to that specific result you're looking for, just go for it!
code : Private Sub Worksheet_Activate

Look, I was playing around with some formulas earlier and stumbled onto this little beast: `=1.55*10^-C1/100`.

It looks like one of those super specific math strings you'd see in a high-level finance model or maybe some heavy-duty engineering spreadsheet. You’ve got that scientific notation thing going on with the `10^-C1` part—which basically means you're taking 1.55 and scaling it down based on whatever value is sitting in cell C1. Then, to top it all off, you're dividing the whole mess by 100.

It’s like trying to calculate a tiny fraction of a percentage after applying an exponential decay. If that C1 value starts climbing, that number is going to vanish into thin air faster than my paycheck on a Friday night! Just a heads-up if you're building something complex in Excel with this—make sure your cell references are exactly where you think they are, or the whole calculation is going to go sideways.

Thanks a bunch!

Hey everyone!
Got a bit of a newbie question here regarding Excel.
How do I take a number like 1.55*10^-5 and flip it over to 15.5*10^-6?
I'm running Office 2010.

Thanks a million!

Hey everyone!

So, I wanted to pick your brains about how you guys are handling MS Word 2013 and MS Excel 2013 lately.
I’ve been running into some seriously annoying glitches, and I'm trying to figure out if it's just my machine acting up or if this is a widespread headache.

In Word, it's driving me nuts—whenever I finish typing something and try to switch the font, say from Calibri over to Times New Roman, I'll highlight the text, click the new font, and then... nothing. The whole program just freezes up for a few seconds before finally updating the font. It’s like the software is taking a nap right when I need it to work! Same thing happens when I try to tweak the text size, like bumping it from 11 to 12, though the freeze isn't quite as long there.

Then there's Excel. It's just as bad. If I pop a value into a cell, let's say B3, and then move on to type something in the next one, B4, the whole app just hangs. It sits there frozen, and then suddenly—poof—the value I typed finally shows up. It's super clunky.

I'm running Office on Windows 7 Professional. Honestly, back when I was using the 2010 or 2007 versions, everything ran smooth as silk without any of these hiccups.

Thanks a ton in advance for sharing what you guys have been dealing with!

wanderingdrifter3 said:Okay, look, I’ve gotta build this database in Access, which—let’s be real—is probably pretty embarrassing since there’s way more stuff you can do in Access anyway. But here we go. 😁
It’s probably a total breeze for anyone who actually knows what they’re doing, but me? I’m just spinning my wheels here, struggling and struggling, and I honestly have no clue where I'm messing up. 🙄 My topic is an American gymnastics competition.
So, I set up my tables and attributes like this:

competition registration (registration_id, contestant_SSN, registration_date, discipline_enrolled);

contestant (SSN, first_name, last_name, state, discipline, rank_achieved)

discipline (discipline_ID, discipline_name, competition_time)

judge (SSN, first_name, last_name, discipline_judged)

medal (ID, rank_achieved, discipline, medal_type, jewelry_store, message)

I’m trying to link all these tables using those shared attributes—you know, like connecting the discipline from the contestant table to the discipline name in the discipline table. But it just won't work! Even after I take a deep breath, try to stay calm, and throw a bunch of primary keys at it to force the connection, still nothing...
At this point, I am totally 🙂 🙂 🙂 🙂 🙂 and I am begging for some help! 😢

I don't really mess with databases in Access, but I'm thinking this might be the fix:
The discipline_ID in the discipline table has to be the exact same data type (personally, I’d go with integer) as the discipline field in the contestant table. On top of that, you have to link the discipline_ID from the discipline table to the discipline field in the contestant table—not the other way around. That's because discipline_ID is the primary key in the discipline table, making the discipline field in the contestant table the foreign key.