Recent content by ayfour

Thanks - have looked at the replace function, and I understand what it is about. What I do not know is how to reference the database name. Apologies for not being being explicit in my first post - I have a number of tables from different databases, so I will not be substituting the same...

Below is the code I have to remove the DBO. But I do not know how to modify it to pick up the database name. --- Public Sub RemoveDBO() Dim tbl As TableDef For Each tbl In CurrentDb.TableDefs If Len(tbl.Connect) > 0 Then tbl.Name = Replace(tbl.Name, "dbo_", "")...

Hi Am using Access 2007 with linked tables in SQL Server 2008. When I link the SQL Server tables, they automatically appear with the DBO prefix. I have found the VBA code to remove the DBO which is all good. However, what I would really like to do is use the database name as the prefix...

Thanks guys - appreciate the help. Got it working now! cheers K

Thanks for your prompt response lagbolt. I have tried your code, (I am a little new to Access) and although I don't fully understand the Property section, and put it into my form. When I try to run it, the main form loads. When I click on one of the tabs, I get: compile error: syntax error...

Hi All (Am working on Access 2007) I have a subform on each page of a Tab Control on a main form. (There are 6 pages to the Tab Control) One of my pages (called Org_Details) does not render when I open in Form View - all it shows is a large white rectangle where the image ought to be. It...

Thanks guys - your help and advice is most appreciated. cheers K

Hi guys Thanks for your answers. Gemma's answer helps me out a bit, as it will be easier than going into each field to change the name manually. I like Wazz's tip, but I can't quite get my head around it, as it is a little advanced for my skills at this stage. The CreateControl is what I...

Hi All ** How do I replace a label caption with value from a field in my database? ** I am putting together an app using forms, and each form has lots of text boxes with label boxes. In our database, we have a table which gives us a summary list of all field names (as used in the text...