Recent content by BradWare

I played around with your data and this worked for me: Surname: Right([strFullName],Len([strFullName])-InStrRev([strFullName]," ",-1)) I did make the assumption that there are no spaces AFTER the surname in your raw data.

I played around with Custom UI Editor and I think the problem is that if I just paste xml to it without opening an application (Excel or Word), I get an error. But as Custom UI won't open an Access document AND won't allow me to just paste/type the xml and validate it...I'm pretty much s.o.l...

I've been working through the RibbonX book by Wiley. I have no problems validating XML when I go through Excel or Word. But when I follow the book's directions and paste or type XML for an Access application I always get an error: Unhandled Exception has occurred in your application. So...

Thanks for the tips.

I'm curious to know if there is a way a report can be given a tag. What I'd like to do is isolate a group of report names and put them in a combo box...but I'd rather not individually type each name. If there is a way to give the reports I want a common tag then I could scoop them up more...

I have a very simple report that is set to print one standard portrait 8/5 X 11. In print preview it shows only 1 page, but when it prints a 2nd blank page always follows. Users that have different computers/printers have run into this, too, but only with this particular report. I know I'm...

I have a database that uses several Union queries. I transformed it into a Design Master and now I'm getting errors when I try to open. The error states I'm using invalid field types in the SELECT statement. I assume the Replication fields are causing the trouble. Is there a way around this?

Peter, thanks for such an easy solution!

I am very new to replication and I want to know if there is a way to tell (via VBA) that the active database is the Design Master or a Replica. I want to disable certain features in Replicas.