Search results

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...

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...

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...

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...