Search results

It's fixed now. The problem was that on the server (mysql) there was a very short timeout setting. I changed it and now MyODBC works just fine. Thank you for the help, m.

Is there any other free driver then MyODBC?

It does have this ability (at least to .txt), but I'm looking for something more "real-time" - like ODBC. The import is to be made too frequent for doing it manually... Can I do it thru MDAC ???

Hi, is there any other way to import data from a MySql database then via MyODBC I'm experiencing quite some problems with it (v3.51.12)? , especially with character coding... thx Miha

you can also try: docmd.openquery "qryQueryName"

Thanks for the help. I created a max query and I retrieve it's last number with "dlookup" on a form and just use " +1" for my field... m.

Hello, I have a field named dblNumber and I want it's default value to be it's value in the previous record + 1. How can I do this ? If it's not possible in a table, can I do it on a form? op.: I don't wan't to use the "autonumber" option... thanks m.

Sven, could you try putting the field you are referencing to the report first! and then reference it as you wish... e.g. 1. put a field [bitrate] on the report (you can set it's visible option to false) 2. and only the put the field: =IIF(bitrate>2,'do this','do that') to the report I think...

I know that you have added the field to your report source, but did you add this field to the report (in design view) ??? p.s. it would help if you could post a picture of your report in design view; or post the database...

you should make sure that you have put just the field [filmlijst.status] somewhere on your report first, only then can you reference it in a formula...

you should create your own form and add it to show at startup (tools/startup) and on this form create a login for employees and admin. If a user logs in as an employee "take" him to his form(s), if one logs in as an admin "take" him to the switchboard... m.

thank you very much! I think this will do just fine... :) Miha

Hi I have a form "frmForm1" and a subform "frmForm2". On the form there is an unbounded textfiled "strText" and a command button "cmdButton". I would like to filter the form "on-the-fly" by clicking the cbutton. my textfiled relates to one field in the subform... is it possible to do this? I...

SOLVED the problem was that I didn't use an empty textbox in the report title... miha

Hi I have a report and a form (with one text field and one combo box) to filter the report "on-the-fly". I want to add a code to the "filter" command button on the form to change the value in my report title according to the selection in the combo box. I added the following code to the com...

thank you! m.

Hi how do I setup a "welcome" form to start on database start? miha

Hi, I'm using Access 2003 on winXP PRO. I want to import data from MySql database (running on linux Debian server) via MySql 3.51 ODBC driver. Everything works fine except that some of the Slovenian specific letters (e.g. Š, Č, Ž) don't show right (I use language SL-ISO-8859-2 both on MySQl...

Sorry I forgot to say that this works!!! Thank you neileg M.

I believe I haven't made myself clear enough: the field "ID" is the primary key, the field "Name" is not indexed and the same value can be entered more than one time - the same goes for the "number" field. I also have about ten other fields in this table, but it wouldn't serve any purpose to...