Recent content by johnbrugman

I see it like that, yes! But I think this is how it should work.

Dear SamDemon, In Access you have a function to mailmerge to Word. You can - to see how this works - see it in a macro Action TransferText (I think, I translated it from Dutch). A parameter of this function is a Tablename; you can use a query instead. Is this what you mean? Regards, John

Dear Flavio^5, What do you mean bij changes? If you want to add, delete or change data in your database this mustn't be a problem. If you make changes to the designs of a table, query, form ect. (maybe unintentionally), then this is correct: you are not able to! Therefore everyone should leave...

Lance, Are you aware that you have no control on a autonumber field? I understand you want to use it for invoice number purpuses. You'd better use a normal Numeric field instead! Otherwise you can lose invoice number, i.e. when you accidentally add an invoice you want to delete. You then lose...

Coopdog, I had the same 'problem'. I solved it in the Extra|Start up options of the db: 1. Allow full menu and 2. Allow default menu's should be on. I hope the translation is right because I'm using a dutch version. Hope it will work for you! John.

Try Compact and Repair?

I think I want to combine 2 things. I implemented your code but instead of printing the filtered records in frmMelding all records of the Recordset are printed. So the basic question is how to assigne a filtered recordset to rst. In the help I search for this and it says that on a recordset...

Thank you, this is very helpful. The only thing left is that I want to filter my recordset to the current filter. In the Help I read that exactly that property is ignored. So the construction with the recordset works, only I get all records in the recordsource and I want the filtered records...

Another way I want to explore: can I use the For Each Next construction to print the report for each Main-Id in the current filter. This must result in something like: Dim Records As ? Dim FilteredRecords As ? (Recordset?) For Each Record In FilteredRecords DoCmd.OpenReport "rpt", ...

Rick, I think your suggestion is very helpful. However the record source of the report is different from the main form. Main form frmMain is based on qryMain and the report rptReport is based on qryReport. qryReport on his case is also based on qryMain (and some others). Any further...

I want help about the following: I have a db with a main form to which I can set filters by the normal access way. When I push the print button I get a print of the form of all selected records. Is there a way to apply this form-filter to a report which I want to open/print from the mainform...

I have a db with a table with an OLE filed. When an OLE object is added (in both WinNT and W2K OS) I can see the 'value' on the WinNT client but NOT on the W2K client. It doesn;t mather which Office version you are running (Office 2K or Office XP) Does anyone have a clue?

Robert, I read your reply with much intrest. The explanation of the advantages and working of a FE-BE application is exactly in accordance with my thinking and wher e therefor the reason to choose for splitting up the single mdb file. However I encounter indeed a breakdown when opening the FE...

Does anyone know if there is a outlook bar control in ms access?

Current situation: Since i have changed the mrs.mdb with 25 users to aan front-end/back-end application (_be) I have problems with adjusting the client. I made a client for each user. I thought that I could alter a sample front-end easily but my client wil hang after I for example change some...