Search:

OMG... I feel like a moron now. LOL. Guess I'd just been staring at the code for so long I completely glazed over those single quotes. That fixed the problem. Thank you!! :D:D:D

Here's the string as it comes out in text visualizer:


SELECT TBLadminEMPLIST.[Last Name] + ', ' + TBLadminEMPLIST.[First Name] AS Name,
COUNT(tblTB_ErrorTracking.UserID) AS ErrorCount
FROM...

I've already tried those options. I put a break point after the string, and both hovered over the variables and extracted the string to paste into query builder. Both tests delivered exactly the...

Hi there :wave:

First, a little background: this is a desktop application with a form where users with appropriate access can generate reports from a SQL Server 2005 database. All of the reports...

Hey Shaggy!

Ok, I got the reports exporting right and formatting the data page so it's readable. I've modified the pivot function to add the column, row and data fields, but it's hanging up on a...

Hey Shaggy,

Turns out all I needed to do was add the 2010 runtime version to the case logic and it generates the pivot just fine. What I'd like to do now is add the fields to the table via code...

Hey Shaggy,

Thank you so much for sharing those Excel classes! They're a life saver on my project. Do I need to make any adjustments to work with Excel 2010? And could you give me some guidance...

:wave: Hey RobDogg,

Trying to do an export from SQL to Excel in VB.Net, VS 2010. I notice the only code you have in that FAQ is for VB6 using ADO. Got an updated version? Translation attempts...

Hey Kevin,

Thanks! I ended up switching to static databinding instead of the dynamic code I was using and all the combo boxes are working now. But I'd still like to go back to dynamic binding...

Ok, this is officially making me insane. The datatable loads fine, the dataset loads fine, but for some screwed up reason the bindingsource refuses to acknowledge that the child table rows are...

Ok, fine. Split hairs why don'tcha? ;-) j/k

But anyway... If I could figure out how to switch my form to a datagridview and make it look right I would, but I'm thinking that would be really...

Well, Kevin, looks like you shouldn't have taken that bet. The master/detail datagridview did show the detail...all 52 records entact. Literally copied and pasted the code from one form to the...

I've verified the query in the Query Editor multiple times, it's fine. Will try the master/detail data grid and see what happens.

stanav,

You were right. The count of the binding source is 0. So... the question becomes, how do I troubleshoot that? I'm guessing it's something in the parent/child relationship, but it...

Kevin,

Thanks for the input! I'll tinker with it some more tomorrow and see where I end up.

Stanav,

As in the rowcount pulled by each query?

Zoe

I've snipped out the code from the initial post for you. Hacking through it in notepad is messy to say the least.

Here's the data set function:


And here's the function for...

Hi all :wave:

Ok, I've been working on this code for several days now, and it's making me nuts. In this windows forms app, I have a form with six comboboxes. Two are parents, one with a single...

@jmcilhinney,

I've modified the relationships to use the keys in the database (sorry, that was a total dumbass moment, should've set it up that way to begin with). I've verified all the data...

Ok, I've set all that up and I'm getting an error "Parent columns and Child columns don't have type-matching columns." I'm pulling these from a SQL database, so all the parent tables have integer or...

:wave: Hi there!

Question for you... I'm trying to expand the concept of this code to multiple parent/child comboboxes. In a nutshell, I have one parent combobox that has one child, and a second...

Thanks! Turns out what I really needed was a fresh pair of eyes on the code. I got it fixed this morning. Needed to adjust the syntax on the databindings. :)

jmcilhinney,

Hi! I'm trying to databind a pair of textboxes to a dataset based on a stored procedure and for some reason it's failing. Where am I going wrong?

Edit: Form1.adid is a variable...

I got it resolved... as it turned out, there were issues with the migration from the old SQL server. Got those resolved, and the errors along with it! :)

:wave: Hey guys,

It's been quite awhile since I posted here, but I've got a sticky one this time. I'm transitioning an existing application to connect to a new SQL server. All relevant tables,...

I got it figured out. Turns out I had some data segments where the field values actually were zero, and I could easily modify my select statements to weed those out. All good now!

Hey guys,

I'm working on a report in Crystal 10. I'm trying to calculate a percent based on two fields that are sums of other fields. Here's the basic gist of it:

Code for formula field...

Ok, new problem. I updated the SQL statement to cast the sums as bigint, and it hasn't thrown anymore errors yet. However, when I try to update the SQL command in Crystal, it hangs up and stops...

hmmm. You may be onto something. it doesn't seem to like the data type of int. I'll try bigint and see if it likes that.

Hack,

I see your point. :) Thanks. I wasn't sure if it would end up being a Crystal problem or a straight SQL problem, or some combination of both.

Hopefully somebody will find a solution...

Hey Guys,

I'm in a pickle here. The bosses have asked me to develop a series of reports in Crystal to pull from a SQL Server 2K database, and I only have Crystal Reports 10 Developer Edition to...

That's actually part of the problem... for this particular function, I need all the fields from all the tables, because they're all related to each other. The main table stores all the FK's from the...

It WORKS!!!! :D

I changed the SELECT statement to SELECT * from each of the tables, and now it works perfectly!!!

Thanks guys! :wave:

Yup. When I replace intMyID with the ID of a valid record in my tables, it pulls up every conceivable field related to that record, just like it's supposed to. The query builder threw one parameter...

Ok, I must be going totally blind. I've gone over this SQL string with a fine-tooth comb so many times the lines are blurring together, and I've worked out as many of the errors as I can find. Yet...

Hey guys :wave:

I'm having the same problem in my Access 2003 project, and the problem I'm having with the Me.List0.Columm(Index, row) is how to get said index and row such that it delivers the...

FINALLY Got this one fixed!!!

Turns out, SQL in Access (2003) will join multiple tables, but it's ridiculously picky about the syntax to get the job done. Here's the SQL string I finally got to...

This thing is turning out to be a royal pain. I've set up the SQL statement so it pulls all the data from all the tables, but thanks to Access being a *&^$:eek2: I had to use stored queries for all...

Hey RobDog,

Let me see if we're on the same page. Are you suggesting I bind the subform to the recordset and have it populate the fields from there?

The only problem I can think of with that...

Ok guys, here's the challenge:

I've converted this entire database over to ADO from DAO and bound forms (yuck!). Now, I have a main search form with a variety of fields to search by, and this...

Got this one fixed!

All you have to do is upgrade your own browser to IE 7, and it will update your ActiveX controls in Access accordingly. Then you delete and re-insert the webbrowser control...