Hello Perry, > I did place my question on many OpenOffice boards but still did not get > an answer.
Since I did not see your question in [email protected] (the list I previously pointed you to), you might have missed an important one :) I'll answer your mail in [EMAIL PROTECTED], for reasons of scaling (I'm pretty sure more people than me could have answered this). Please also reply to this list when answering - thanks. Full quoting for the new readers. > I also need to know if it's even possible > in OpenOffice: > My problem is as follow, I need on a Dialog (form) to retrieve some > user-rights from a MS-Access database to fill things > like: > - limited choices in storage paths (this goes to combobox); > - default storage path of one of previous point (this just is a field in > current user's record); > - file counter=file counter +1 and store the new value in the table in > the right field of the record of current user; > - jobs rights (1 or more with names of the job owner in case somebody > writes a letter for a higher colleague or so. this goes > to combobox); > - opening greetings to fill in a combobox like dear sir, dear madam etc etc; > - closing greeting like sincerely yours, best regards, see you tomorrow, > etc etc; > > Next to that i have some extra variables who are stored in the database > in 3 different languages and all this stuff is filled > central through our helpdesk also things like therms of conditions, > template rights (if user is permitted to lauch current > template) and so on and so on. This database already is developed as > both frontend and backend icw MySQL (BE), Msaccess (FE). > So I just need to know, as for the last inch of the finish of this > project, how to open in OpenOffice's Writer a table in > MS-Access with a query such as: > > "SELECT tblUsers.ID, tblUsers.User, tblstorloc.StorageLocation FROM > tblstorloc RIGHT JOIN tblusrstrgl LEFT JOIN tblUsers ON > tblusrstrgl.User_ID = tblUsers.ID ON tblstorloc.ID = > tblusrstrgl.StorageLoc_ID WHERE tblUsers.User="perry";" > > This query, as mentioned above, consists 2 records and each value I have > to put into a combobox with Writer's Basic language. > *Hopeful you know how to deal with opening records by a query in > openoffice's writer with basic language. > * I don't know your background with Base/Basic as a whole, so I don't know where to start. I'll give a short sketch below, if you miss something or don't understand it, please ask back. dataSource = createUnoService( "com.sun.star.sdb.DatabaseContext" ). _ getByName( <file_url_to_dot_odb> ) connection = dataSource.getConnection( "", "" ) statement = connection.prepareStatement( "SELECT ..." ) result = statement.executeQuery() While ( result.next() ) value = result.getString( 1 ) ' value of the first column, use other numbers for other columns, ' and other getXXX (e.g. getDate, getBoolean, etc.) for other ' data types Wend This is one possibility to retrieve such data, there are more, but as far as I understood you, this should match best. > When you wanna have full-copy of my project made me know. All therms, > variables are almost in English except the Access Form > is in Dutch since our colleagues on the helpdesk prefere Dutch :-) but > i'll translate it for u when u want me to. > > Thanks a lot in advance. > > Best regards, > Perry > > Thanks a lot in advance. > > Best regards, > > Perry Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
