Search results

No, he wants to know when any cell in the sheet has been changed/updated. I can't pinpoint a particular cell that will always change, it can be anything. Charmed

I'm using 2003 ed. and I get a #VALUE! error in the calculation field. :( All I'm writing in the other field is N/A, Any other thoughts? Charmed

I'm sure this is a stupid question but any help would be appreciated. Generally I need to add two cells with sum in third cell. Easy enough. But everyonce in awhile I have to put "N/A" in one of the cells. Which then gives me a error in my third cell. Is there a way to tell it If="N/A" then...

Can you tell I moved on to other projects? They are keeping me busy. Which is good I guess. Sorry I didn't get back to you. What I want to do is put a date stamp in a cell. (Not as a comment) so when any part of the spread sheet is changed, the date will update to Now(). That way if he opens...

I checked that out. I need it to show in a cell vs a comment. I have to print the spreadsheet for my boss and would like him to know when the last it was updated. He hasn't quite grasped the concept of opening a spreadsheet yet. :( Thanks for the idea. I tried to play around with it so it...

Can someone help with a Date Stamp in excel. I just need something to show "Updated Last" time for any time a cell is updated. I have to print this for my boss every once in awhile and would like that date to show. So if I did an update yesterday, but I printed it today, I need yesterday's date...

I get the big friggin' junction table thingy - sort of. I just want to put this one last thought out there to make sure I'm still going in the right direction. Here's my scenario with the same tables mentioned above. Let's say my client has 10 Buildings (tblBuilding) Policy # 1234 (tblPolicy)...

I can't quite get my head wrapped around this, so any help will be appreciated. Here's my set up. Every table has an AutoNumber Unique ID to make things simple. This is about insurance information for a company that owns a lot of property. There are other tables in my database that I am not...

I didn't ask for, I just did a search and found the post, but that link was awesome. Thanks for the info. It worked great. -Charmed

Ok, I'm getting closer. It did give me a new record on the 2nd subform, but it also gave me a new record on the 1st subform. Any suggestions from there? Here's the code I put in. subfrmPolicyInformation.SetFocus subfrmPolicyInformation.Form!PolicyNumber.SetFocus...

Ok, one more question. Main form...with subform...with subform. I need a button on the main form that will create a new record on the sub-sub-form. Any suggestions? I've tried a many different combinations of set focus and it's just not working. If you need any more details let me know.

I have a form that has a main form on page 1, then a subform with another subform on page 2. On the last field of each form -> subform -> subform, I have a macro that says "GoToControl" and put the control. I don't know if that's helpful or not. Good Luck

Ok, Rich helped me with a post from 2002 :) Thank you for baring with me through my solution process. Here's the answer that worked for me. subfrmPolicyInformation.SetFocus subfrmPolicyInformation!PolicyKey.SetFocus DoCmd.GoToRecord , , acNewRec

Ok, I'm getting closer. I'm getting error now that states "An Expression you entered is the wrong data type for one of the arguments" This is what I put so far. Policy key is just the AutoID. I tried changing the Control to PolicyNumber which is a text box, but I got the same error...

Thank you for the link. It doesn't mean much to me at this point. I will save it so when I do understand, it will become very useful. Could I be so bold to ask if you could spell it out for me? Thank you again.

I have a main form with a few command buttons which include add a new record to main form which works great. Now I want to add a new Record to the subform. I tried using a macro GoToRecord and named the subform. But it states the subform is not open. Any help with either Macro or VB statement...

Thanks PB for your response. The only problem with that is some one a long time ago made the request to have our company split into two so literally downstairs is on one database and the upstairs is on an entirely different one. (Ridiculous) Anyway, I have the make table for upstairs, and the...

Hello all, I have a odd request for help. I work for a small company and just happen to know a little about Access. So when they need something I have to stop what I'm doing (you know my job) and try and figure it out. Then I have to give it to the "web designer", who I feel is worse off than...

How about Mousewheel? Could you post the code to put on mousewheel? It's always been a nuisance, thanks for the info.

I'm hoping not to make this vague, but I don't know where to start. -I got some programing from a db that someone posted, a looooonnnngggg time ago. It is a search box, I type all or part of the file number and a list of matching files show in a list box. When I double click the item in the...