Recent content by Beaurou

Found my solution =IIf([text17]=1,DCount("[Para2]","OTR Para2","[para1]=1")+1,IIf([text17]=2,DCount("[Para2]","OTR Para2","[para1]=2")+1,IIf([text17]=3,DCount("[Para2]","OTR Para2","[para1]=3")+1,"12")))

Hi, This line work perfectly when I copy into the default value of [para2] it will increment the value by one =DCount("[Para2]","OTR Para2","[Para1]=1")+1 Now I want to combine the 3 following one into one. =DCount("[Para2]","OTR Para2","[Para1]=1")+1 =DCount("[Para2]","OTR...

Problem solve Thank to you final sript Private Sub Command5_Click() Dim strSql As String Dim db As DAO.Database Set db = CurrentDb CurrentDb.Execute "ALTER TABLE TCodes ADD [" & [Forms]![add atc]![Report_ID] & "] text 255", dbFailOnError Set db = Nothing End Sub

Hi, I have a from [ATC] with a textbox [project_id] where the user will input a field name. On the form I have a button to launch an event procedure to add (alter table )a new field to a specific tsable [TCodes]. so far I try almost everything my last script look like this: Private Sub...

It's a single form with the record selected on the bottom left.

It's a form. Your script work good for my 8 checkboxes. But when I moved from one record to another I need the focus to be on the selected checkbox.

Thank CJ_London It work good, the only problem it's when I move from one record the another the focus stay on the previous selected checkbox. I need the focus to be on the selected checkbox whenever I moved from record to record.

I have a form with 8 checkbox on it. What I want to achieve is whenever a checkbox is selected all the other one become unable (only one selection allowed). I try this code but it doesn't work. Did I use the good event procedure or should I use a different one? For the purpose of this Post I...