Recent content by jimrawr

Im trying to either shade the area between to lines on a graph, how can this be done?? thanks

A collegue of mine has somehow managed to hide the worksheets in a spreadsheet... we dont know how it was done, but I think probably a key combination. Anyone know how to bring them back??? Thanks for the help

For some reason, this code works when I create a brand new workbook(for testing)... when I use it in the actual one it needs to be implemented into, it doesnt work at all Sub dupl_cols() q = "=if(Sheet1!RC<>"""",Sheet1!RC,"""")" Sheet2.[a:b] = q 'etc End Sub When I run this in the...

If I just copy/paste the Table and Forms into a new database, will that work ok or will I lose anything?

is there anyway to simply remove the workgroup?

Hey everyone... I have a database, and i need certain people to be able to view only, and other to be able to change things. I was playing around a little bit and I somehow set it so only I can view the database from my computer... how can I turn this off? And then, whats the best way to add...

for some reason its still not adding them up... It makes the new field when I view the query, but its empty. Any idea why?

When I enter in [misc fees]+[discounting fees] and then try to run the query it asks me for parameter value, whats that?

Thanks for the reply... where do I add in the code if I am using a query? In design view, then ?? Thanks, I am really nice to access as you can tell and I really appreciate the help

anyone? I need to be able to input data into a form, and some of the entries to be automatic calculations.. and I need those calculations to go into the table so I have some way of viewing all the entries and not having to look at them one by one on the form..

I have some calculations in my form and I need those calculations to go into the table.. how can I do this? Thanks for all the help

yup, it did thanks!!

Thanks for the help guys... I havent had a chance yet to check the code, but does that code jrbarnett gave calculate using the system date? Thats what I need... Expiration date - system date = days left

I am trying to do this in a form. I have an Epiration date, and I need to calculate remaining days... I.E Epiration date = 12/25/05 Todays Date = 10/10/05 Remaining = 12/25/05 - 10/10/05 Can someone tell me the code that needs to go into the control source? Thanks!!

Another thing... is it possible to do it just in the table? where would I put in the code for the field?