Search results

I'm very new to VBA and don't want to look an idiot in the open forum but I'm studying alone from books and for "fun" and it sometimes gets very frustrating when I can't find it on the web. I'm covering "debugging" at the moment and looking at how to use the "immediate" window. I understand...

Bob - Thanks very much....sorry I posted the question in the wrong place...I'm still getting used to the site....Regards....Bill

How do I split "Hello World" into two distinct objects: String 1 = "Hello World" (I then want) String 2 = "Hello" String 3 = "World" Do I use the Split function? Regards

Adam...That works thanks very much...Regards Bill

Adam Thanks. I have 8 forms derived from one table. Each Form is based on a query from the main table, selected by "Region_Number". From the Switchboard I can select "View Clients From Region 1". If I'm in (say) Region 1 and I update any field I can click a button on that form which places...

Each record in my form(s) has a "Last Updated" button which updates a text box with today's date. The DB opens with a "Switchboard" with links to each form. I would like to place a button on the Switchboard that says something like "Update All Records".....any advice? Thanks in advance

The link above should obviuosly be http://office.microsoft.com/en-us/access/HA012327311033.aspx Thanks

Thanks guys..but I got this bit of code off Microsoft ...see http://office.microsoft.com/en-us/access/HA012327311033.aspx...I'm still not sure what (Me!) means as opposed to (Me.)...any advice would be appreciated.

I'm new (very new) why does this not work? I've attached it to the After_Update event of a Text Box to Enable/disable a Command Button Sub UndoEdits() If Me.Dirty Then Me!btnUndo.Enabled = True ' Enable button. Else Me!btnUndo.Enabled = False ' Disable button...