Recent content by andyski101

OK, well, after a month I have done it. Using alot of VBA code and creating objects in a new form I found a way to create my own graphs. No, it isn't as pretty as what I have links to, but its all that they needed here. If anyone is ever interested I am very willing to share the code.

Then you might want to copy to excel, make your changes there with a marco or something like that, and then paste into the new database. If your going to have to do this import often, you might want to consider creating a form to automate the import.

OK, well, you might want to try using VBA This is off the top of my head so there might be some error, I'll test it when I can, but I think its right. y=len(strSSN) for x=9-y strSSN="0" & strSSN next x

You could custom type the mask such as 9990\.99 or set it as text first, use the wizard and then change it back to a number. You could also try setting the format and required decimal places. These options depend on how much your numbers vary in terms of length and number of decimal places.

If your coding this in a module and not on a specific form then the DoCmd.Close ac Form, Me.Form will close the form on top, and I think that's what your saying your problem is right? If this is the case, you could have Form Load store the name of the form in a public variable and call that...

You got me thinking about finding a cleaner way to do this, and I think I found one. Give the On Change event a try.

Care to share how you did it?

I hadn't heard of a system variables table before, but it definetly makes sense. Thanks Ken.

I don't know if this is really what your looking for, but what I usally do is lock Combo Box A after a selection has been made and create a command button that has to be clicked if the user wants to change the selection. Its a bit ugly but it gets the job done.

Our school writes its semesters as F05, W06, S06, J06. The letter stands for the season (fall, winter, spring, summer) and the two numbers are for the year. I have two fields on different tables. The first one uses the semester (F05) to tell us when they joined the club. The second uses only the...

Dim Z As Long

Thanks for the tip.

If your only using integer values then you can use LONG instead. DOUBLE is as big as you can get but since it also hold the decimal places it uses extra memory.

I have learned my lesson and repair and compact daily now. I have tried used the Jet Utility to no avail. I'll just have to work hard this weekend to get back as much as I can. Its not like I have anything better to do since I broke my bike again. Thanks for trying to help me; sometimes you just...

How did you DIM Z? or did you maybe DIM Z as public or global elsewhere?