Recent content by Islwyn

Sorry for the delay in responding, for the fact that the code is not working, and for using "+" instead of "&". Peculiarly the original code (with "+" not "&") works great in the database for which it was written but neither the corrected or original code works in the new database I created...

Sorry that it's not working marschall. I've attached a small database I've made from scratch using the same code, but for some weird reason the code now only half works: It does update the yes/no values in the source table, as intended, but the Requery part of the module doesn't seem to work...

I have recently removed a table which was much larger than necessary and replaced it with a smaller table linked to others (which effectively does the same job as the original table). I have also added a handful of new forms and queries to accommodate this change. As a consequence, the mdb file...

It's definitely a problem with the select query I was basing the code on so you may be right. I've got the general approach to work now by creating a temporary table then using the query to insert its values into the table and referring to the table in the above code, rather than basing the...

Thanks, I'll give it a try. I have tried dbOpenDynaset but get the same problem. I see that others have had the same problem when there is a mistake in the SQL - for example when it referrs to a record which does not exists - but when I view the data in Query view it is fine and I cannot see a...

I have a form which is used as the basis of a query to choose which people a user wants to e-mail. Once a user has selected various options on the form (used as the basis of the query) I want them to click a button which makes the first form invisible and opens a new form containing a text box...

Not sure if this is appropriate for the code repository but anyway… here is one solution to a problem I couldn’t find a post relating to, and I thought it might be useful to others, especially novices like me. *Note -it will modify all the relevant data in the RecordSource of the relevant form...

Can you tell me how to find the Multiselect property for a tick boxes in continuous forms? I can't seem to find one so can't say what it is set to. Then I can start a new thread. Thanks

Thanks. I'm getting a "Method or data member not found" error message in the VBA debugger window when I place this code in Form_Load(). Here is the code: Private Sub Form_Load() Me.Height = 19 * 567 End Sub What am I doing wrong? Thanks

This looks really useful, but I can't seem to get it to work (due to my inexperience). I'd be grateful for some basic advice as to how to use it to select/deselect all tickboxes in a continuous form. Here is what DOESN'T work (how do I correct it?) Private Sub SelectDeselectAll_Click()...

Thanks GalaxiomAtHome. This may sound a stupid question to experienced users, but where do I place the code?

Probably a very simple solution, but I've search the forms threads and nothing seems to be coming up: How do I change the default height of a form using code? Eg - to set the width and height of a form showing continuous records to 17cm. Thanks Is

Thanks Bob, Thanks for the advice regarding the Warnings, I will amend my code appropriately. The first Query, "BackupDate1", uses a delete query to delete a record in a Table containing the last backup date. This date is shown in a text box on the Main Menu form, and also on a form as you...

I thought this might be the case but it was worth a try! Thanks for your help

I have an autonumber field in a table which is linked to fields in multiple other tables. These existing numbers cannot be changed without having to change all the corresponding data in the other tables. I have been testing the database by adding test records to check queries, new pieces of...