Recent content by danassef

I'm attempting to use the collect data option within Access 2007. Presently we use paper forms that are then re-enteed into an Access database. Im tryin to automate this by having our employee fill out a form of their activities. I have already set up a query of the information I need on the...

I have placed a command button to find a record on my form using the wizard. When I click on the button the "look in" box on the Find Screen that appears always list the the box that previously had the focus. So if I look for a certain ticket number and change a customers order once I click on...

The 1st of each month I have to do a report that showes the number of cases closed the previous month and I have the following criteria in my query in my date entered field: >=DateSerial(Year(Date()),Month(Date())-1,1) And <DateSerial(Year(Date()),Month(Date()),1). This gives me all cases...

I have a report due the first of each week in which I need the cases open and cases closed for the previous week, the week two weeks prior and the 2007 and 2006 year to date on two different types of cases. I have a case management table with a field for Type of Case, date assigned and date...

How can I set up a table so that as we assign a case it generates a new number with the year in front of it. I would like for the case number to be generated by the program and when someone enter a new case the program generates the next case number and assignes it to that case. The format we...

how can I shorten the name in the legend to a more something more simple. Presently when I do a chart it take the name of the field it is getting the information from. So it may say something like sumofpersonage when I was doing a chart of people age compared to events. I would like for it to...

I'm trying to make a query that takes the DOB from my table and converts it to an age. I have tried to write an expression =datediff ("yyyy", now(), [DOB]) in the criteria section of an expression I called AGE.