Search results

Thanks Bob. You got me back on track. Much appreciated!

This seems like such a novice problem, but for the life of me I can't figure it out. I've created a switchboard with the switchboard manager and made the form a pop up. I'd like to reduce the form height but only see a width property for the form. How can I reduce the height of the switchboard?

Yes it zonked. Ok, I don't get this. So I made a copy of the form and ran the copy....works fine. Then ran the original form....it worked fine. So then I deleted the copy, closed the database, ran the original again.....works fine. It appears I have a solution, but I don't have any idea...

I guess I should have mentioned....logical first step complete. :)

I have a form with 2 buttons. One button is an "exit" button with no customization. The other button is a "search" button that runs a bit of code. Until recently, everything worked fine. I think they only thing I've changed in my db is that I selected "compact on close." Now every time I...

I think that's initially what Freshman had suggested (not allow duplicates at table level). I agree, it's a good suggestion to prevent the problem (which I will be passing along to the "powers that be").

Well, it wasn't as bad as I thought it was going to be. Essentially, these queries are pulling data from SQL Server and DB2 databases mashing it all together and plopping it on a report. I have a calendar control where the user picks a date, the queries run, it's all spit out blah, blah...

Well the good news is that with a little tweak it works great. DCount("Citation", "MainTable", "[Citation] = '" & Me.Citation & "'") The bad news (for me) is that when I apply it to my query I once again get "Run-time error '3360'" "Query is too complex." I may just resort to trying a...

Never mind. I didn't realize I had saved the db as v2007. I don't want to get on too much of a tangent, but any idea why Me.Citation would throw a "Method or data member not found" in 2007?

For the life of me, I can't get that to run. Any chance you could attach the db your poking around with?

I've tried to clear up the "Query is too complex" issue with no success. I was thinking I could just make a table from the query and do my count on the citation field in this new table. I think this might work but it seems like a hokey way of doing it and then I'm left with handling this table...

I tried doing the find duplicates query and it tells me "Query is too complex." Prior to that I had tried doing a count of the citation numbers thinking I would change the font size/color to any record where count > 1 but I get "Query is too complex" when I try to run the count. Stepping...

I like the idea from a QC perspective and it addresses the root of the problem. Trouble is, 1) this is happening across multiple databases that I'm running a query across 2) the db's are not mine 3) the db's already have dups (bad data) in them. Could I do some sort of count or dcount on the...

I have a report that includes last name and citation number in the detail section and sorts by last name. My problem is that there are occasionally duplicate citation numbers (data entry issue). I would like to flag the records on the report that have duplicate values (so if citation number...

Thank you for the advice. I tried it out as you suggested and it works fine.

I've written several successful queries but this one continues to trouble me. SELECT [CMSJUVQ].[JVKEY] AS INCIDENT, [CMSCHRG].[CRCIT#] AS CITATION, [CMSCOURT].[CCTIME] AS TIME FROM ((([CMSJUVQ] left join [CMSCHRG] on (([CMSJUVQ].[JVKEY] = [CMSCHRG].[CARRKY]) and ([CMSJUVQ].[JVSEQ#] =...

Well, I've tried a CVar(FieldName) in my select query and it retrieves the first couple of lines of text for me. Trouble is, it's not retrieving all of it. Any thoughts?

I'm trying to write an access report using data in a SQL table. One of the fields in the SQL table is a blob field that contains text. I'm wondering if anyone has any suggestions on where to start to get this information to display on my report?

If I'm passing my xml text (xmlDoc.Text or xmlDoc.xml) to DCrake's function and replacing a few characters, how do I save the replaced text back to the xml file (or a new xml file)?

I think it's illegal for a few reasons. 1) I was having issues processing the xml file, though I wouldn't say my vba skills are polished so this was merely a hunch. 2) I opened the file in IE and get an error on the page. The error states "An invalid character was found in text content."...