Recent content by powellm1976

I need help filtering a table so I can use the .Filter. I need to filter for Fundsnum = 99 and can't figure out how to do it. I'm enclosing the code I'm working with and any comments / suggestions would be great The long Criteria is what I was initially using till I figure out I had to use...

I think looking at your code will help a ton. The info would all be the same ex. if year 2000 started at $500 then all the other years would also start there. Thanks

What I'm looking for is to be able to display multiple lines on a graph. I want to be able to display five separate lines for five years of sales. I have one year working great but I have no idea how to get the other to work. If someone could help me I would be forever in debt. Mark

We can't just use casenumber because one client can have multiple cases pending and we want his unique identifier to be the same regardless.

The problem with this is that Last Name can change and it has to be unique to the client over the history of their involvement. To me there are a few things that won't change (they could but unlikely) Gender, ssn, and birth date. We have over 50,000 records in some cases so a standard...

I need unique identifier, not autonumber The problem is that we have a casenumber already which is already in a sence an auto number but I need a unique number that is derived from a combination of particulars about a client. This will allow for added security. Thanks Mark

I'm having trouble deciding on what to do for a unique number for my program. I've tried different combinations with no set one being definitely unique. I have client info (ex: SSN, birth date, gender, etc) Does anyone out there have a formula for generating the number. the number can be any...

I'm having a problem with pulling the month out of this format mm/dd/yyyy. I want to be able to pull the month out and it display it as January or Fedruary, etc. Please help I also would like a parameter that would ask what month and year I wanted to look for or give me the option to just put...

I guess the problem is that I know that it strips them and I know I need to create them somehow but I'm not sure on how to deal with that, can you help. example if possible Mark

I need a line graph in access that will display the results of three different years together. I've already developed one that will take one year and display but I want three lines on the same graph. What is the best way to do this and how do you call it and what would I need to add to the...

When I make my program and executible it is stripping all my menu items off. How do I get a menu bar in the read only format so I can distribute it to my clients? Thanks mark

I was wandering if anyone out there could help me with a label problem. I need to know where I tell the report what kind of avery label I want to print it to and I also need to know if there is a way to make whatever text is in the box automatically adjust itself to fit in the box. Thank you...

I know how to do the alternation grey reports but I want to view my forms in this manner also. Does anyone know how I can make every other record grey and then the other white. Remember this is in a form. thank you