Search results

Thanks Guys, works like a charm!

Hi Chaps, thank you for this as soon as I get back home, I will test

Hi everyone, Is it possible within a function to ignore one field by it's name? i.e not return any value. The code I have already ignores the ID number by use of If, Else, Then With rst For Each f In .Fields If (f.Attributes And dbAutoIncrField) Then ' always skip the...

Thank you Arnelgp - this is perfect and gets around the need to run a query, very much appreciated :)

Hi Gasman, thanks for your response. Perhaps should have mentioned, the system is anonymous, although I could track user names, one of the principles is that it is a blameless system and a condition is that no action will be taken against anyone using it. No personally identifiable information...

Hi All, Thank you for all of the assistance given so far, I wonder if I could trouble you further please? My project involves the user filling in a form, when they are finished, they submit the form, it is saved and off they go; feeling happy that they have submitted a report. Nothing new...

Thanks for you answers guys

Good afternoon all, May I ask if it is possible to open two forms (frm_one & frm_two) at the same time but only have frm_one visible until a command button is pressed on that form. frm_one (which is a pop up) frm_one should then be made invisible and frm_two made visible / editable. Both of...

Something to do with Dragons?? ;-)

Lol! you are not wrong!! Cheers!

Hi Bob, This is exactly what I am looking for, thank you!

Good morning all, I have a test DB where I am trying to replace 3 cascading combo boxes with just one combo and 2 text boxes. The DB has one table: tbl_Part with 2 fields; Part_Number (short txt) and Mod_Number (number). One Form: frm_Mod which has 3 comboxes: cboPart, cboMod and cboID I have...

Hi All, Joining the digital era from the stone age, still very much used to the analog world. I did some coding in Excel many years ago, where you could actually record a macro, find out how it worked and then try to solve more complex issues. Have been very much a database user up until...