TVCH FORUMS HOME . JOIN . FAN CLUBS . ABOUT US . CONTACT . CHAT  
Bomis   Quick Links   TOPICS . TREE-VIEW . SEARCH . HELP! . NEWS . PROFILE
Archive through November 20, 2003

The TVClubHouse: Archives: 2004 January - Arpil: Computer Problems? Ask here... (ARCHIVES): Archive through November 20, 2003 users admin

Author Message
Zachsmom

Friday, November 14, 2003 - 9:57 pm   Edit Post Move Post Delete Post View Post    
I am an Access programmer! Is it 2000?

Zachsmom

Friday, November 14, 2003 - 10:13 pm   Edit Post Move Post Delete Post View Post    
Okay, I am going to give you a couple of tips..(I don't know if this is what you are trying to do but perhaps this will help)

put a textbox where ever you want the formula to be. It should say "unbound" after you place it on there. Right click on the textbox, select properties,go to data, in the control souce type in =sum( [field1] + [field2] )

where field1 is the name of the first field and field2 is the second field. I hope this helps!

If you have any other problems, let me know. I progam in Access almost daily.

Cathie

Friday, November 14, 2003 - 10:34 pm   Edit Post Move Post Delete Post View Post    
It is Access 2002. I probably didn't make it very clear, but I want two sums at the bottom, one of everyone's #1 value and the other of their #2 value.

It is a database of people we are inviting to my daughter's wedding. We are entering all the family info, including a field for "# invited" and another for "# attending" after they RSVP with how many are coming. The report is to keep a running total of how many are invited and how many are coming. Does that make sense?

I have tried creating a text box and putting SUM #Attending in Control Source and it just carried the number of the last person on the report, not the sum of all the people who are listed.

Bobbie_552001

Friday, November 14, 2003 - 10:39 pm   Edit Post Move Post Delete Post View Post    
Hi Draheid...I haven't been around all evening and am just now seeing your post back to me. I'm here now for a little while...are you??

Draheid

Friday, November 14, 2003 - 10:46 pm   Edit Post Move Post Delete Post View Post    
Hi Bobbie, I'm in chat now - if you would, try clearing your temporary internet files and see if you can get into chat again. I'll be there and keep an eye here as well.

Cathie

Friday, November 14, 2003 - 10:49 pm   Edit Post Move Post Delete Post View Post    
Zachsmom, I guess it is Access 2000. When I looked at "About Access" in the Help area it says Access 2002, but at the top of the database itself it says "Access 2000 file format".

Zachsmom

Friday, November 14, 2003 - 10:54 pm   Edit Post Move Post Delete Post View Post    
have you tried putting it into the page footer?

you would put =sum([NumberAttending])

I am going to recreate a table and see if that works.

How is your report created? is it by query or table?

Cathie

Friday, November 14, 2003 - 11:00 pm   Edit Post Move Post Delete Post View Post    
It is by query, and the page footer is where I put it. In my actual field I used # instead of spelling out number. Would that make a difference?

Zachsmom

Friday, November 14, 2003 - 11:29 pm   Edit Post Move Post Delete Post View Post    
you have to make sure the field name is spelled exactly.

Cathie

Friday, November 14, 2003 - 11:34 pm   Edit Post Move Post Delete Post View Post    
I have changed the field name to all text, and am spelling it exactly. If I put the sum box in the footer it prints out "#Error" in that space. I moved it up to the body of the report and it gave me the correct sum, but shows it at the end of every line of the report.

Zachsmom

Friday, November 14, 2003 - 11:41 pm   Edit Post Move Post Delete Post View Post    
hmmmm...let me do some investigating!

Cathie

Friday, November 14, 2003 - 11:54 pm   Edit Post Move Post Delete Post View Post    
Okay--I think I have it. It doesn't work in the Page Footer, but underneath that I dragged down the report footer and placed it there. It seems kind of backward to me, but this shows it in the report between the "Detail" and the "Page Footer", yet the Report Footer is at the bottom of my design page.

You were a great help with the sum text--thanks!!!

Zachsmom

Saturday, November 15, 2003 - 12:09 am   Edit Post Move Post Delete Post View Post    
I am so sorry! My fault- I called it page footer instead of report footer I was wondering why mine was working and yours wasn't, I had my calculation in Report footer.

Just think of it as a running total, you don't do one at the end of a page, you do it at the end of a report!

Again, I am sorry!

Cathie

Saturday, November 15, 2003 - 12:11 am   Edit Post Move Post Delete Post View Post    
Ahhh, that makes a lot of sense!! You were a great help--thank you, thank you, thank you!

Zachsmom

Saturday, November 15, 2003 - 12:13 am   Edit Post Move Post Delete Post View Post    


you had me stumped! lol

glad to be of help, let me know if I can ever be of assistance again!

Sasman

Saturday, November 15, 2003 - 10:57 am   Edit Post Move Post Delete Post View Post    
hey draheid, sometimes i get into chat via mirc and sometimes using java. you said that there are pro & cons for both methods. Could you elaborate?

Sometimes one works and the other doesn't and visa vera. I have no idea why.


Sasman

Saturday, November 15, 2003 - 11:09 am   Edit Post Move Post Delete Post View Post    
I am getting this error message 'this operation has been cancelled due to restrictions in affect on this computer. Please contact your system administrator.' when in IE using Tools/Internet options....

Darn it if I am not the system admin. I must have skunked up something but I don't know what.

Can anyone help? I am running Windoze XP pro.


Draheid

Saturday, November 15, 2003 - 1:29 pm   Edit Post Move Post Delete Post View Post    
Sasman: The advantage to the java client is that you don't need to install or configure anything as you do in mIRC. Nothing to buy, nothing to hassle with installing, etc. The java client also provides for avatar use, simple 'scripted' commands, easy access to links posted in the chatroom, etc. Also, with the network we use for TVCH chat, using the java client is the only way one can access the chatroom without registering their nickname in chat. One frequent disadvantage for some is that the java client doesn't always load fully or correctly causing some problems getting into chat. The simplicity of this is also quite often the more difficult to diagnose problems with.

The configurability of mIRC gives a lot more 'power' to control your chat experience however, with power comes difficulty of use since you have to go through the configuration process in order to set it up and make it useable. Once it is setup, the available features and options of mIRC are extensive, though, and I highly recommend it to anyone willing to take the time to set it up. Also, mIRC is a shareware program meaning that anyone who continues to use it is supposed to pay for the license to do so.

As to your 'this operation...' error message, it sounds as though you have activated some system policy which requires administrative access. The only area that comes to mind is the content controls section where you can restrict what sites can be accessed and block those with inappropriate content. However, the message when that is active is not the same as you stated. You may simply need to log out and back in to make sure you are logged in as administrator and try the procedure again. If that doesn't help, check your user settings and possibly your security policy for that computer.

Check this article from Microsoft: HOW TO: Use the Group Policy Editor to Manage Local computer Policy in Windows XP

Hope this helps.

Babyruth

Sunday, November 16, 2003 - 1:19 pm   Edit Post Move Post Delete Post View Post    
Virus alert:

Virus disguised as Paypal email:

Zdnet.com

Kstme

Sunday, November 16, 2003 - 2:40 pm   Edit Post Move Post Delete Post View Post    
Question for anyone on AOL. I am running 5.0 on Windows 98. Yes, the puter is old, but VERY happy! I talked with the techs at AOL this morning regarding upgrading to 8.0 or 9.0. The guy assured me there would be no problems because we have MEGA RAM in this puter.

Has anyone upgraded with a system similar to this one? Did you have problems? We once upgraded from 4.0 to 6.5 and crashed our old puter so dead we bought this one. I am VERY hesitant, but I am missing so much 'stuff' with emails, I'm beginning to feel like I'm living in the caveman age.

Thanks for any feedback!

Cathie

Sunday, November 16, 2003 - 2:56 pm   Edit Post Move Post Delete Post View Post    
We upgraded my daughter's old PC to 9.0 without any problems. Hers is about 6 years old, Pentium I, 166 Mhz, using Windows 98. If yours is that or newer, better, it should work okay.

Kstme

Sunday, November 16, 2003 - 3:54 pm   Edit Post Move Post Delete Post View Post    
Cathie, THANKS so much! I'm going to try it this evening.

Squaredsc

Thursday, November 20, 2003 - 9:20 am   Edit Post Move Post Delete Post View Post    
dra, or anyone else, for some reason i can't access anything java related on my home puter. i just get a blank screen. i don't believe i changed any of the settings. nor do i know what setting should be set. last night i tried to pull up some paint samples on decoratetoday.com and i just got a blank screen. but at work it comes up fine.

also i think whatever i did happened withing the past few months. i also can't access chat from java either and as you know ive waited and waited and nothing comes up. thx in advance.


Ladytex

Thursday, November 20, 2003 - 10:07 am   Edit Post Move Post Delete Post View Post    
Squared, have you or someone in your house done windows updates at the microsoft site? One of the new updates removes the sun java component from internet explorer. What I did was go to Java.com and I downloaded the free java software there. That solved my java problems.

Squaredsc

Thursday, November 20, 2003 - 10:34 am   Edit Post Move Post Delete Post View Post    
oh thanks ladyt!! yeah i did an update months ago so that was probably it. wonder if i can sneak out to fix this, lol. besos.