Search results for query: *

Hello I am required to do this in my report: There is a date that I am supposed to show in the report. In my table, I have two dates - one is end date, and the other is deposit end date. I want my report to show end date if end date is filled in, and if end date is blank or empty, then to whos...

Thanks! And supposing I wanted to see all records only from BEFORE the last week (i.e not include last weeks records in this query)? Thanks again for all your help!

Thanks! That does work. Except now, my users have to manually enter 0 into the price executed field :-( Anyway, I just fooled around, changed the names of the fields and it works now. I wonder if something is wrong with my version of Access for it to behave in this strange way! rgds shazia

Hello I have a calculation that I do using several fields in my form. I would like to save the results from this calculation to a field in my main table. How do I do this? My form is in datasheet view. Thanks

Hello I want a field called Deal Executed to be changed to Yes or No depending on the data in the numerical field Price Executed whenever a user entered a new record. Deal Executed is a combox box in the table itself (Yes/No), and I put an If statment in the AFter insert property that If Price...

I want to make a criteria in my query to show me all records only dated today and in the last seven days. How would I enter my criteria for this? Thanks!! Shazia

I have a subform and a button called add new record. When the main form is also a new record, and someone clicks on the subforms addnew record button, naturally they can see the new record. The subform is a continous form and takes a small space of the main form. So when there are many new...

Hello I have a date field, but since a user will be entering monthwise data only, how can i make him enter a month (they dont wnat to type out a date) and for it to save as the last date of that month? They will be entering data for prev months as well or else I would have had a field withc...

Yes, I would like to know the code for that as that would prevent them entering data for a month in the future, in which case my calaculations (which are based on every month and the calculation for the month prior to it) would be messed up. But I still would like to know that if they enter 01...

Thanks Trudye! As a matter of fact, I did end up using Year() and Month() and it worked great...I have another question...probably sounds stupid...but is there anyway that if a user enters a month in the field it input it in the table as the current date? This is because they will only be...

Hello I am sure there is some easy way to do this...but I have a date field in my table and my users need to search for records with the crietria as year and then month. Is there any way to do this, or must I have two fields? And how do I then allow them to search first by year and then by month...

Hello I need help again (figures!) This is what I did: I kept the after update code as above. Then in the on current property, I put this: Private Sub Form_Current() Dim rs As Object Set rs = Me.Recordset.Clone If rs.EOF Or Not Me.NewRecord Then ' don't do anything if...

Ok, I'm using (rather *copying* :-)) some code off from Microsofts sample, so I think I might have managed to do this...I'll update once I get it going (about moving the cirrent balance data autoamtically into the next record)...I now need to know how to stop the next record from automatically...

Yes, I did already put the code for cmdCalculate into the after update property, and of course that works perfectly, giving me the right new balance everytime. But when I goto a new record, I will still need the cmdupdate button right? To set the current balance value each time to the newbalance...

Well obviously, setting the default value as 100 answers my first question. LOL. Sorry about that one! Still need help on automatating the second process, though! Thanks again!

TerpFan2001, Thanks a lot! Thats doing exactly what I need! Now, how can I automate all this? I do have one funds table, and one returns table. So when someone enters the first return for a particular fund, you are right, its current bal should default as 100. So basically, if a particular fund...

Hello everyone I need to do this on my database...My main table is tblReturns, and I have a form called Returns. Now inside that I have a field called %MTD which is the percentage return a user will enter every month. I have placed a caculated control on the form that is =100*(1+[%MTD]) Now I...