When you look back at this, in the three seconds it'll take you to turn to dust, I think you'll find the mistake was touching my stuff.

Buffy ,'Lessons'


Buffistechnology 2: You Made Her So She Growls?  

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!


Sophia Brooks - Sep 26, 2005 7:38:10 am PDT #4676 of 10003
Cats to become a rabbit should gather immediately now here

Hi.

I have really, really fucked up a database that someone else built.

It is an order database, made from the templete.

I was trying to make a query so that I could find all the money deposited on one day.

It told me some of the tables I used weren't related, so I created some relationships and then I got nervous, so i deleted what I thought were the relationships I made.

Anyone, I think I deleted something important, because now the order form won't add up the total of the items ordered.

I went back and create the file from a template again, and I checked all the relationships and they seem to be the in my database as in the template, but still no adding!

I have a suspicion that somehow an order ID number is not being created (because there is a relationship between orders and order details and I am sometimes now getting the error message that there is no order to match my order detail number.

Help!


Sophia Brooks - Sep 26, 2005 7:48:24 am PDT #4677 of 10003
Cats to become a rabbit should gather immediately now here

Actually, I fixed the order number issue, but the not adding up thing is still happening.

The tables involved are:

Customers Orders Order Details and the field that is not adding is:

=[Order Details Subform].Form![Order Subtotal]


Sophia Brooks - Sep 26, 2005 9:33:24 am PDT #4678 of 10003
Cats to become a rabbit should gather immediately now here

Nevermind.

I just asked IT to restore the backup copy from yesterday.


vw bug - Sep 26, 2005 11:51:45 am PDT #4679 of 10003
Mostly lurking...

If one was to, say, take an .mpg file and burn it to a cd, would it automatically play on a DVD player? I'm new to all this stuff.


Sophia Brooks - Sep 26, 2005 12:08:57 pm PDT #4680 of 10003
Cats to become a rabbit should gather immediately now here

vw-

I could on my old DVD player, but not on my new one. I think you can search your player here:

[link]


vw bug - Sep 26, 2005 12:11:55 pm PDT #4681 of 10003
Mostly lurking...

Oooooo...that's not good, as I won't know what kind of DVD player I'll be playing it on, since I'll be using one from school. Hmmmm...


Dana - Sep 26, 2005 12:11:57 pm PDT #4682 of 10003
I'm terrifically busy with my ennui.

It depends on the DVD player. I think you'd have a much better chance if you could make either a VCD or a DVD.


vw bug - Sep 26, 2005 12:12:38 pm PDT #4683 of 10003
Mostly lurking...

I can't make a DVD. How do I make it a VCD?


Dana - Sep 26, 2005 12:15:27 pm PDT #4684 of 10003
I'm terrifically busy with my ennui.

If you don't have a burning program on your machine, I've heard people say good things about VCD Easy. Possibly even here. It's got a free trial.

What's the main issue? The size of the file? Or the fact that the room has a DVD player but not a computer?


vw bug - Sep 26, 2005 12:16:36 pm PDT #4685 of 10003
Mostly lurking...

Or the fact that the room has a DVD player but not a computer?

This. There's no projector in the room, so I need to be able to play it from a DVD player.