Recent content by marblegiant

Hi, I'm developing a database and, following helpful comments in reply to my previous posts, have realised that I really need to have a working knowledge of VBA if I am to have the control that I want. I've now read Beginning Access VBA (Wrox) which I found helpful (ok I skimmed lots of it!)...

Hi, thanks for that. But I'm clearly still doing something wrong. When I shift focus from the sub to the main form I then want to hide (set value visible no) the sub. But even though I'm now using SelectObject to shift focus to the main I get a macro error saying that I can't 'hide a control...

Worked out how to move focus from a mainform to a subform, using a macro, by using Gotocontrol and selecting the subform as the control. But can't work out how, again using a macro, it's possible to shift focus back to the mainform from the subform. All ideas appreciated! Many thanks. W

Hi, Many thanks again for all of your help. I didn't mean to bother you again, but just wanted to confirm that, if I don't ever want to update the data in the linked table, do I need to worry about the pseudo key that you mentioned? I'd rather not give any access to Sage, or alter any data in...

Wow! Many thanks for your two very speedy and VERY helpful responses. Very much appreciated. I'm completely new to the world of Access and SQL and not finding it that easy... ByteMyzer's method worked perfectly first time (having tried everything I could think of before, and failed, this was SO...

Hi, I'm building a database of people, linked to a list of organisations taken from Sage as an ODBC linked table. To avoid radically slowing either Sage or Access, I don't keep the Sage/Access link open, but just when required - using a query to maintain a copy of the relevant fields from Sage...