Search results for query: *

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...

Hi, use the OnKeyDownEvent of the TextBox. There use the following code: If KeyCode = vbKeyReturn Then 'your code End If This should do. Greeting, Jens

simply - you can't. It's a stored procedure and thus executed as a whole. Perhaps you should try to change the sp to give back the values it's using and processing so you can see if they're ok. Use the Query Analyzer for executing and give the params to the sp by hand, the messages from QA are...

Hi, I am using this code on a button for refreshing a subform: Me.NameofSubform.SetFocus DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Greetings, Jens

Hello, I think the easiest way to do this would be by using a DTS-Package: In SQL-Server Enterprise Manager this is done by selecting "Data Transformation Services" then create a new local package. In the new window select your sources (connections), in your case the "OLE DB...

We did upgrade to Office XP because users wanted to create own views directly in Access, which sometimes caused problems in Office 2000. The problem was that Access 2000 was released earlier than SQL Server 2000 and the "compatibility patch" was not working correctly (views got...