I believe the problem is that the object that you output must be a table or a query stored in your mdb file, but your qryHTMLRecords is in fact a recordset object, and you can't do an OutputTo of a recordset.
HTH
Julio
There's another way, but it also needs securing the DB.
Is to create a set of queries with only the fields you want, set them to run "with owner access", and then take give the different users permissions only to the defferent queries and not to the table.
HTH
Try just compacting it to the dest folder:<br><br><br>DBEngine.CompactDatabase "c:\docs\mydb.mdb", "d:\bak\mydbcopy.mdb"<br><br>HTH<br><br>Julio
Jane,<br><br>About the compact_database function, I hope you realize that it will only work in the English version of Access. That code will break in any other language.<br><br>Why not use instead the CompactDatabase method:<br><br>DBEngine.CompactDatabase "OldName.mdb"...
Mike,<br><br>Thanks, I saw that already, but the thing is, my bitmap data is in a byte array (so, in memory) but not in the clipboard. <br><br>But wait, maybe I can put my byte array in the clipboard, and from there in the picture control. I'm gonna try that, I'll keep you posted...
Hi,<br><br>I have a byte array b() which contains a bitmap image. I can save it to disk as a file with a .bmp extension, and paint will open it no problem. I can also put it in a database and retrieve just fine. <br><br>But, what I'd like to do is disply it in a picture or image control...
Iamaar,<br><br>I think what you are doing should work just fine. The only two problems I can think you may be having are the following:<br><br>- You placed the avg control in the Page Footer instead of the Report Footer.<br><br>- The name of the text box control in which you placed your formula...
I think you should use the After_Update Event and write something similar to this:<br><br>If me!TickBoxName.Value = True then<br> me!FieldName.Value = me!FieldName.Value * 1.2<br>else<br> me!FieldName.Value = me!FieldName.Value / 1.2<br>end...
Actually, I made a mistake. Indeed, the last DAO version is 3.6.<br><br>4.0 is the version of the database engine in Access 2000, but now the recommended way to program it is via ADO and not DAO. I haven't used yet Access 2000, so I can't tell you anything about it. <br><br>But I am now working...
Steve,<br><br>I'd suggest you check in the Project/References, to check if you still have the reference to the DAO version 3.x.<br><br>If that's the case, you should clear it and add a reference to Microsoft DAO 4.0. I believe this should clear your error.<br><br>HTH,<br><br>Julio<br>
Shane,<br><br>I propose the following solution:<br><br>In your subform, create an unbound textbox with its rowsource set to: =Count([The_cupboard_id]). Name it TotLines (or whatever).<br><br>Then, in your main form, create another unbound textbox, and set its rowsource to...
Hi Brian,<br><br>You must set the "Response" parameter to acDataErrAdded.<br>Basically, when you decide to run some code in the NotInList event, Access doesn't know what you are doing, so you must tell it. You do that with the "Response" parameter.<br><br>So, just add this to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.