Recent content by wakiwi

I hope someone can help with this... I have a form that allows users to select dates and categories for a report that is then opened once the selections are made. The report data is based on the selections made on the form. Allmy calculations etc work fine in the report and use the appropriate...

Thanks to all for helping. It must have been some quirk with the program or something else I can't explain. When I deleted the variable from the table, closed the table, then reopened it rentered the same info, with the same field name even, the query worked just fine! csdays...

I know it should have worked but it did not. I finally got it to work using the following =(Date()-[fieldname])/365*12*30.

I am trying to calculate the total number of days between a date (i.e, csdate) and todays date in a Query for a Report. I have tried the DateDiff command in the query line and in an unbound box on the report but it is not returning the right values. Can Someone tell me what I have done wrong. I...

I have a problem a bit like pinkpepink. I need a new variable that is yes or no based on whether the date field is blank or not. How would I change the code below to code "yes" if the field were blank and "no" if it is not null? I have tried "Not IsNUll" several ways but it isn't working...

I have developed a form [sanreq] that allows a user to select a type of youth for report data [ytype] which works fine. My problem is that they now want to be able to chose youth that are active (disdate would be null) or inactive (disdate would not be null) and I can't figure the best way to do...

I have a form with a bound combo box listing names, [myname] and a multiselect list box that lists all available forms in a database [myselections]. I am really struggling with code that will enable the user to hit a command button that will then open the selected forms to show the data for the...

I have a database that has a master table with names etc and then many other one to many tables where information on these people is stored (e.g., drug screens, court attendance, restitution payments). I need to develop a form where a user selects the name of a person from a list box...

This site is SO helpful, I'd be lost without you all answering questions! Here is my latest problem. I have a field on a report that reflects dates that a client entered in a search box[txtstartdate]. When no dates are entered by the client the report is based on all records. In this case I'd...

parameter Query Thank-you Jon! I was trying to avoid using a form, but I see that it will make it a lot easier to get what I need.

parameter query-between Thank you so much! I was able to modify that to work on my Query! I have another question that you may be able to answer-Is there a way to have the Start and End dates that a person enters in the Query boxes to print on the report? Then the client could see the time...

I am trying to run a between start and end date parameter query that will also allow all records to be pulled up. I can't get the wildcard"*" to work. If I use it all records come up no matter what dates are entered in the " Start" and "End" date boxes. The query works fine without the * , but I...

updating Yes I am saving the form, that is why I don't understand this. Saving doesn't seem to make a difference, unless you close the first form or go to another record. If I close the first form when you reopen the first form you don't always return to the record that you were just entering...

I have two forms linked by a field "JUVIS". My problem is that I can't get the second form to show data newly entered on the first form without moving to another record on the first form. I have a command button on the first form that opens the second form. All works well, meaning the forms are...