Recent content by Toga

What I ended up doing is utilizing the secondary X-axes for the fields I needed to add. It also allowed me to use Chr$(10) so I could put rows in between the text fields as well. I can now copy the chart and paste into excel with everything I need still on the chart. This makes it nice...

Thanks Bob....that's certainly what I am finding. And yes, I can print the charts to a printer or to a pdf and the text fields show up fine. If you happen to think of any possible workaround, I'd appreciate hearing about it. Nothing I have tried seems to work. One thing I can do though is...

I have added Text Fields onto a chart (in a form) and everything populates as intended. When I copy and subsequently paste a copy of the chart into an excel spreadsheet or email, the text fields do not paste. Is there a trick I am missing to make this happen? I have tried grouping the text...

Using Access 2003, I already have a line chart set up that's linked to a data table. I'm trying to add upper / lower control limits to a chart. Is there a way I can add a straight line to the chart after it's already created, similar to what you can do with the Add Trendline function. The...

Hi Jarico75, No I never did figure it out. To get around it I had to include a me.refresh each time a check box was clicked. Very hoakie but it worked for what I needed. Let me know if you have any better luck.

We created a simple intranet web site using Publisher 2003. It's nothing extravagent but has served it's purpose wrt making available an array of links & read-only documents to the users. One user just downloaded Internet explorer 8.0 and now they can no longer view Navigation bar. Text with...

Here's the code I'm using to bind the form to the ADO recordset. Set rs = New ADODB.Recordset rs.Open xsql, ISODBC, adOpenDynamic, adLockOptimistic Set Me.Recordset = rs

Sorry, I wasn't clear. I have a form bound to an ADO recordset with six checkboxes on it. I can check them all with no problem but let's say I screwed up and needed to uncheck 3 of them. I can uncheck the first one but I cannot uncheck the other 2. I either have to do a me.refresh or leave...

I have a form bound to an ADO recordset with several checkboxes on it. I can check them all with no problem, but I can only uncheck one of them. In order to uncheck another checkbox, I either have to do a me.refresh or leave the record and come back to it. All the text fields and dropdowns...

I guess I'll never know what the issue was. I deleted the db in SQL Server and then recreated it using the Access Upsizing Wizard and now it works fine. Thanks for everyone's help just the same.

It's definitely something with my database setup on SQL Server. If I connect to a table on Northwind DB, it works fine. Perhaps I'll try recreating the database....I just have no idea at all!

Thanks ByteMyzer Unfortunately, that doesn't do it either. At this point, I think your right wrt something having to be different with the set up at work, although I have no idea what it could be. If I link the table in via an ODBC connection and use that as the record source, everything...

Thanks ByteMyzer. I tried your suggestion but it still doesn't work. I also created a seperate log in so I wasn't using windows authentication and it still doesn't allow me to edit the record set, or add new records. My connection string is as follows.... With ISODBC .Provider...

One other question....again comparing a bound form to a specific table / record in SQL server using an ADO recordset / OLEDB vs a Pass Through query vs a BE Access table. If I have the form bound to only one record in SQL Server when I open it, is that going to be more similar to using a Pass...

We have an older Access app with the FE off at a remote site accessing the BE tables at our location. These are bound forms to linked in access tables so as you can imagine, dreadfully slow. We're going to migrate the tables to the express edition of 2005 SQL Server. Here's the mindset I'm...