Recent content by pharcyder

Jason, many thanks for your elaborate answern, this helped me a lot! :)

Hello! I am trying to "convert" a bigger MS Access application which currently uses MS SQL Server 2000 as the database. The main reasons for the change are so I don't need to distribute the Access frontend to each of the 30 users (whenever I make a small change in a report or added a new field)...

Okay, just found it. It's .SelectedItem.Text, not just .Text

I'm new to ASP.NET, so please be gentle :) I have a DropDownList with a bound datasource. One field from this source is an ID, the other the name of the item. As DataTextField I use the name, and as DataValueField I use the ID (because it is used to filter a gridview). Then I added a label and...

I found this article about SQL Injection really helpful.

Okay, figured it out, you just don't need the GetObject function, you can just set the object without it! :-) Then your code would be: Sub test() Dim xlc as Excel.Chart Set xlc = Me.Controls(0).Object.Charts(1) 'or whatever controlnr. it is.. With xlc .HasTitle = True .ChartTitle =...

Okay, many thanks SkipVought, got it working in a form now, but in a report the object still makes problems. Is there a way to set this control to a variable, cause I can't seem to get GetObject to work? It would just be nice to have the properties available in Visual Basic. Greeting, Jens

Did this, I can even find the object over the object explorer, but it still won't work. There is just stuff/porperties/names I already knew. I just can't create a connection to this chart (or worksheet). And it seems like it would work in Word or PowerPoint, but I can find nothing to make it...

Thanks for your effort, SkipVought, but there are no Shapes in Access. If I try to "Set" the chart-object I get an error message telling me that there is no OLE-Object. Is OLEFormat the name of your object? Greetings, Jens

Thanks Hap007, but I even have the MS Excel Visual Basic Book from Microsoft and there are no hints how this could possibly work. They just focus on the charts directly in Excel and other stuff, but not how I address an embedded Excel Chart in another application. Greetings, Jens

Well, if there would be some code I would surely post it... but as I said I am stuck at the beginning! I just embedded an Excel.Chart.8 in an Access Report and now I try to automate it via Visual Basic, so that this chart can be filled with data from recordsets or so that I can change the chart...

Tried this, but i still can't access the properties of the embedded Excel chart. If anyone could provide a step by step procedure or some lines of code I would be very happy. Thanks, Jens

Hi! I've embedded an Excel Chart in an Access-Report because the standard MS Graph Chart would not be sufficient. Now I know how to automate the Chart in Excel, but I do not know how I would access the properties of this embedded OLE-Chart via Visual Basic out of my Access-Report! I just can't...

Well, perhaps you should actually read the source, there it mentions you don't have to pay with money but with like 10 seconds of computing time. ;-) Then your mail would get a "virtual stamp" and your mailclient could just ignore mails without a stamp. The spammers would have to buy better...

Hi, if you want to copy the reports, forms and macros then copy the frontend. The *.ADP-file. And in this file the connection to the backend is stored, which I think you've tried to copy. In a network you don't need to copy the database (which is usually stored on one machine/server), just the...