Recent content by cully651

Thanks guys, The problem isn't Novell related or a mapped drive issue. It's that on BOE3 the OLE (ADO) provider requires authentication regardless of whether or not the data source is MS Access. It works fine in the CR Designer.

Hi everyone, We have numerous CR reports that mingle a combination of Access and Oracle data (sometimes just Access data) that have worked fine with the Access MDB format for years. Now we're moving to the ACCDB format and the reports work fine in the Crystal Reports developer tool using OLE...

Hi Guys, Sorry if this is old news, but I'm stuck! I've been given this Word document in DOCM format (XML with macros enabled). They have numerous Combo Box content controls inserted all over in tables. What they want is that if someone picks "Yes" or "No" from the list, that it automatically...

Personally, I like the idea of using the ribbon but the users hate it. Not sure yet if it's just a "getting used to it" thing or if it's really a giant UI mistake. I heard custom ribbons will be better in Office 2010 (which we will be using) so I'm going to stay tuned for that info. The QAT is...

They do the search in order to update current records. Only after they have concluded that the record does not exist do they add a new one. The built in search only finds the first occurrence of anything and is therefore useless (aka dangerous). The Access 2007 search box cannot be disabled...

I'm talking about forms and Access controls. They right click on a field to filter it. This actually adds another "And" to the previous filter. The code workaround I've come up with makes the filtering OK... not great. Similar to older version of access. The searching is the real puzzler for...

Hi Guys, As most of you have seen, Access 2007 is quite different in regards to the searching and filtering capabilities. Searching is very fast now, but it only finds the fist instance of a string within the master records, starting at the beginning of the recordset. There is no "find next"...

Both the AutoExec macro and the Startup Form work, thanks. Both the macro and the form need to be handled the same way, by opening the forms in order (left to right) and then opening the first form again like DoCmd.OpenForm "form1" DoCmd.OpenForm "form2" DoCmd.OpenForm "form3"...

Thanks, but that does't work. Here's why. Let's say I have 4 forms, named frm1 frm2 etc. In order to get them so that the tabs are in order, I have to specify frm4 as the startup form, and have the following in frm4's load or open event DoCmd.OpenForm "frm1" DoCmd.OpenForm "frm2"...

In Access 2007, I can't find a way to open several forms at startup (creating tabs for each for in a certain order) then passing the focus to the first form (the tab furthest to the left). I can open all the forms and get them in the order I need, but changing focus to the 1st form seems impossible.

Hi Guys! The issue is simple... on a form, the user right clicks and chooses Text Filters, then Equals, then types in a value. If no data comes back, the form blanks completely (all fields and lables are gone) and it locks up. Even the Filter toggle button at the bottom of the form is locked...

No matter what I try, I get Error 3305: Invalid connection string in pass through query

Hi Guys, I'm a n00b to VBA and Tek-Tips. Gotta say up front, this place is great. I find all sorts of useful info here, so thanks. Also, I apologize up front because I'm sure this topic has been covered but I can't find it. I'm probably not searching for the right words. What I really need to...

Hi! I've been doing Crystal for quite some time, and I'm currently using CR XI R2 Sp2 with the Business Object Enterprise. The problem I'm having is that if I export my report in RTF, everything looks perfect with the correct page breaks and formatting. However, if I export to a "editable...

Never mind, it's a flaw in the table design. I knew there was something missing :)