Recent content by zooropa66

I've managed to transfer data in a subform frm_WIP_Subform to C:\MyWIP\WIP.xls using: DoCmd.OutputTo acOutputForm, "frm_WIP_Subform", acFormatXLS, "C:\MyWIP\WIP.xls", True and this works fine. The correct data is transferred and the spreadsheet opens. However, I would like to apply some...

I have the following code snippet that opens up word document T163.doc from C:\MyTCN\ When the file exists it opens up. When it doesn't exist it throws out an error message box with a load of info and a Debug button. However, I'd just like it to pop up a message box saying "File Does Not...

Also, when i say i'm not using Bound Controls what i mean is that i'm not always selecting the RecordSource and RowSource from the dropdown list of Tables, queries and Forms (but sometimes i am). I'm generally setting those via some VBA. Does that still make my controls Bound? So much to learn...

Admittedly I've got a lot to learn though

You're assuming rather a lot about my experience! By Win forms do you mean forms developed in V.B.? My knowledge of Web forms is non existent. With bound controls i never seemed to be able to update values except in really simple cases where a control was just linked to a table. Any complication...

Thanks for your reply Pat. All updates will be via forms. There will be no updating by editing datasheet forms directly. I don't have any bound controls in my application either. Will this prevent any conflicts?

I have a database application that i intend to split with the table part on a server and the forms part on each users desktop. It will be used by approx 10 users. While the probability of different users accessing and updating the same form is small, the possibility exists. Is there a way i can...

Actually, most of the domain knowledge i've used has been gathered over 20 years working for various companies. It's mainly the VBA part i've learned at my current employer. Your point is a good one though.

I've been working on a large project for my employer for a year now (but software development isn't part of my normal day to day duties). Most of the work (around 70%) has been done in my own time at home. The company were going to buy a system that would be customized by developers at a cost...

That works too! Many thanks.

Hi AccessMSSQL, The above code works just fine. The problem was that i was loading up the form containing the graph in design mode so that there was no data (via the graphs rowsource) on the graph. When i load up the form for real (rather than load it up in design mode) so...

So my code so far is Dim ch As Chart Set ch = Me.Graph7.Object.Application.Chart ch.ChartTitle.Text = "AAA" gives Runtime Error 1004 > Unable to set the Text property of the Charttitle class

The Graph has the following class > MSGraph.Chart.8 and I have selected Microsoft Graph 11.0 Object Library in Tools > References I'm using Access 2003 If I try typing out ch = Me.Graph7.Object.Application.Chart as per your suggestion, Intellisense works up to Object but typing the dot after...

Thanks for your reply. That gives Run-time error 13 Type Mismatch

I have a graph called Graph7 on a form with the graph title set to XXX I have the following code in the Forms on Load event Me!Graph7.charttitle.Text = "AAA" but when the Form loads the Title doesn't change to AAA I've hunted numerous forums and tried the suggestions but to no avail When...