Found my own answer finally

SQL Command: http://user.services.openoffice.org/en/ ... ile#p54964

I've been working on this database over the past couple of days, and today I noticed that things were taking a bit longer to save. So I looked at the file size and it was 269 MB!!, it was around 7 MB before because I have pictures saved in the table. Why all of a sudden is my database so gigantic? I...

I have a report made using Sun Report Builder, with a bar chart in the header.The chart is essentially a bar graph showing the progress of all the projects in the database. Is there anyway that I can use this chart in a form as an image, which will update dynamically?

Perfect! I had some touble moving it to my cells AL7:AL31, but that was some weird copy paste glitch. If you cut and paste once it works but if you cut paste undo paste again it references the cut cells, weird.

Thank you!

I have a text string, they all start with the same value (part descriptions). The reason I want to sort them is there are large gaps between the text values in the column, see screen shot. They don't need to be sorted in any way but they need to be next to each other so I can put them in a order for...

Oh wow thats perfect, thanks. There are some bugs I need to work out now, but this is a great start.

[Update] I just added the table control to my customers form, works perfect thank you very much for all your help. No macro = yay!

I guess my problem is this "Mainform" and "Mainform2" business. I'm not sure what you guys mean by subform and mainform. I'm going to attach my database file, but I don't know how to attach my macros to the database just the "My Macros". So this is the macro I am using,...

Wow thanks for all the info. It's gonna take me awhile to figure out those steps, but it makes sense.

I tried your file, but changing the combobox didn't do anything. I'm using OOo3.1

Hi Everyone, At work we are trying to create a database that will keep track of customer info and projects. I have a separate form for entering project and customer info. They all work just as I want them to, but I want to be able view the record indicated by a combobox value. I've searched around a...