Search results

I don't know how to relate all three tables otherwise and the Date was a form and had a subform. This way I could see 1 date, and enter many expenses, metrics, etc and see it all on one form/subform. Otherwise I would have to create a new expense every time one occurred even if it was on the...

I am not sure how closely this relates, that is why I am posting here, I have a form based on many tables. I am trying to get listboxes (from different tables) to subsequently appear (using show) and be filled in with the corresponding information. Like: Company>Position>Payplan>Name>Wage. All...

Doc, I was just wondering how you would get the last auto update in days value to show. I think that your way is probably the best but I am not grasping the complete idea. I hae used DatePart and can manipulate that to show next month etc. but I don't think that this is the best way to go...

I c. I did not know that. Also, I had asked the same question on another forum and here is what was replied, I would love to know what you think, you seem to be very knowledgable. I am not sure, the following sounds like an easy way to do it but I am not sure if it is what Iwant to do. "I'm...

Thanks for your, once again, quick reply! Well I have a field that has only 4 options (Obviously by now) monthly, quarterly, semiannually, annually. Can't I just create 4 different queries, run them every day and if they are empty, then they are empty, if there is a record, it will update (add...

Alright, I have started to figure it out but I think I need some help. I want an if statement but I am not familiar with date functions. In an append query I want to look at my original table and add records if it is past a certain date. For a monthly expense (entry date is 01/01/2006) If...

I have a make table/query, but your right I am having trouble... any ideas on how to, after I have created the expense, show up in the new table...I am not sure how to recognize the record as a new record. Right now I would add records, but also re-add all the old records already in the database

Hahahaha! nothin like a good quote to lift everybodies spirits. Thanks for ya'lls help I really appreciate it. Next comes the queries!!!! Also, Doc Man, what did u mean 1. Figure out the most frequent schedule you want to support. 2. Assume that you will be able to run things on that...

I really appreicate your help and it has gotten me thinking. Thanks! What about this (this is borrowed from an earlier answer to another post of mine last week). Have 2 tables...One that the original data is selected on. Then another one that all subsequent expenses are written on. (otherwise...

Well, I just want to add the record to the table, not another table. I guess the thing to do would be to have 2 tables. Anyways, I need the records to reoccurr. I have the form and can create the expenses, but next month, they will not automatically show up as an expense of next month. That is...

Well, I have a form that the user enters the name of the expense, amount etc. and then the date it occurs. Say I have a an expense (a duplicate) on the 15th, I want a record to automatically be written next month on that day. (I would also have to write something that says: If date entered is 31...

Ok, I am still confused. I have an expense table. The expense can be either Monthly, quarterly, semiannually, or annually. If the user creates an expense that is monthly, I want it to write a record automatically next month. How does this work? I am not familiar with this process at all.

I am not familiar with windows Server schedule task? Please tell me more...(I know im ignorant) and I am not sure about the access interface... Sweet symbol by the way!

Does anybody know how to schedule in access like sql. Like a "job" in sql server?

This I think is going to be difficult. I have a tutorial that I am trying to figure out on how to do this but it is basic. It can be seen here http://www.fontstuff.com/access/acctut08.htm Anyways, I have a form that I want to use for employee pay. 1. I want to select (from dropdown) the...

Thanks for the Reply Doc, I am thouroughly confused now. I am not sure why, I sorta understand what you are saying but definately not all of it. I will keep working on it and meditate on what you have said while Ihope to somehow gain the knowledge you have that I obviuosly don't.

I have an expense say "window cleaning for $1200" that happense quarterly. (Every 3 months) I know what it is every 3 months but I want to see what it is worth every month. Therefore I divide by 3. 1200/3 = 400 a month. This is a monthly report so if a new expense say "pens for 10 monthly". I...

I have an expense report I am trying to create. Expenses are 1 of 4 things (monthly, quarterly, semiannually, or annually occuring). If I enter a record say today: 8-04-2006--Window cleaning--$400.00--yearly Is there a way to get it to automatically re-occur on the same day next year. (I want...

I really appreciate your time and help.the /0 thing...I have a query that looks at all 4 (monthly yearly semi...etc) and figures it out so there will never be any zerost. I figured it out, it was the dang spelling. This is what I have now (for those interested) and it works. This is to show...

OMG I went back and checked the spelling, I had it wrong after all, I was looking at the wrong stuff...I'm an idiot!!! thanks for your help. FixedExpneseOccurrance was spelled wrong...geez