Recent content by Deverry

Thanks, works perfectly after I redesigned the form to fit on one screenview. I also saw where I went wrong when I originally tried to use the visible control. Database now ready to be handed over thanks to you. Lukim yu somepla tru Dev

Hi Pat, I know that my form is clumsy. The reason is that I do not want three fields to be seen unless/until the checkbox is true in which case data then needs to be entered. My tab order is working fine, the form appears as a full page dialog box and I am keeping the two views clean of each...

I have 3 identical forms except for coding which basically perform the same task. One is for record entry, one for editing and one for finding individual records (ie filtering). These forms all have a check box and depending whether it is true or false specific instructions need to be...

Thanks but that doesn't work either I'm afraid. For now I'm giving up as I've wasted too much time on it and have gone back to using a single form and table. My version of Access is XP (2002 I think). Lukim Dev

Thanks Exodus for your help. I was already working on the separate table theory but had made it a sub-table. I've now removed the relationship and inserted the code you gave me but am still receiving problems *argh* This is what I wrote Private Sub SP_AfterUpdate() If Me.SP = True Then...

I have a form with a checkbox field. When the checkbox = true I want a popup box that asks for additional information (data to go to the same underlying table or as a sub-table). I am able to get the popup box to activate via code in the After Update If Me.SP = True Then DoCmd.OpenForm...

If you delete records/forms etc and don't compact the database and then add new records/forms etc the database will increase in size. It is always a smart move to compact any database after major changes. "If I knew then what I know now - what would I know now?" - Dev

HI, Databases are not the same as other programmes ie Word. Each record has "space" allocated and although you may delete the record (form, report etc) the allocated space remains until you compact your database. To compact the database go to Tools, Database Utilities and click on Compact...

GJT You are a legend :) Thank you. I almost have it working now, just one tiny gremlin which hopefully I'll figure out soon.

Hi, I have created a custom dialog box which is to replace query parameter popups. Query results in 3 pop up boxes and I'd like the CDB to replace same with one pop up box where all criteria may be entered. I believe this would have to be coded but I am way over my head in this area having...