Search results for query: *

Hi Gerry, You are absolutly spot on!! I installed MS Works any the table works fine on all PCs. I am not sure how a Works object is embedded into Word but at least I have full access again. Very many thanks for your kind assistance. Chris

Hi Gerry, If I open the Word document on the PC where it was originally created, and left click the table, the table area is made the current object (black dots at corners and meridians). Now when I right click on the table there is a drop down menu as follows Cut Copy Paste Works Table Object...

Using Win XP Professional and Word 2002, I have documents which include a table in each. The documents are shared on a peer to peer office network. On the originating PC the table can be opened and edited but on any other PC, the table cannot be edited but issues a message "The server...

Hi All, I have a query which produces data for creating graphs:- TRANSFORM Avg(GraphSelect1.AScore) AS AvgOfAScore SELECT GraphSelect1.SubjectGroupText, GraphSelect1.AMonth FROM GraphSelect1 GROUP BY GraphSelect1.SubjectGroupText, GraphSelect1.AMonth PIVOT GraphSelect1.AYear; The graph works...

Hello Duane, The system in use is a MS 2000 Prof within a network with Access 2000 (9.0.2720) installed on the PC only running as a single user facility. There is one database in which a report has been created. The report is called by a form to produce a single page on which is a single graph...

Hi Duane, I have a single report which is called from a form. The form allows the user to select the parameters and options to provide graph headings and filter (where statements) parameters for inclusion in the graph query. I have used the 'syscdm' function to check when a query or table is...

Thank you dhookkrom. I have inserted code to update a query used as the basis for the graph data. The query is a pivot query which takes about 20 seconds to execute. One small problem is that the code used to modify the query is part of a for....next loop as I have about 50 graphs to create...

Using Access 2000 I have a report containing a graph. This object has a pivot transform query to provide up to 10 series (lines) on the graph. A form is used to select values to be used in the graph. I need to be able to change the rowsource contents of the graph depending upon the values...

Using Access2000 and Windows 2000 Professional, I have created and developed my database on network drive H. The database is now located on network drive Y and I have changed the 'default database folder' under menu TOOLS/OPTIONS/GENERAL TAB to value Y:\etc. All runs well until next day when...

I have a protected word form which has a series of topics each of which comprise a checkbox, date field, and fixed text. Users can set a check any checkbox and enter a date against any of the topics. I would like to be able to set all check boxes and date fields which have been selected to a...

Thanks Janec, this solves the problem I had.

I also had a problem of conflict between using form and code for accessing the database using ado. The only solution I came up with is to open the database using code in the formload event of the first form of the project. The connection object is set as public and is used for each subsequent...

I have a form which allows text, combo, and check box values and settings to be amended by a user. The form's values are bound to a table. On the form is a button to facilitate further processing on the data just entered. This second form queries the data from the table. My problem is that in...

Now I have the population of the second combo working OK. Just one small problem I have with this second combo box is that if I select any entry in the list by clicking with mouse, only the first irem in the list is displayed! On checking the value of the listindex on the change event it is...

Many thanks for this site which gives clear instructions on how to make it work.

Using access 2000, I have a form with 2 combo boxes. Combo1 contains group information which when selected I wish to use in a query which populates detailed data in combo2. Combo1 is populated by a query which works ok. I have tried to use the index value from combo1 as a filter for combo2 but...

Thanks Ann, this works just fine. Chris

Hi, Have you considered designing the form as an access form? In this case the problem that you have could be resolved by using a sub form (detailing the items) on a main form (detailing the complaint). This would need 2 tables to store the information (one for the complaint and the other for...

Yes, the size of the form increases and following fields are displaced. It seems a pity that there does not appear to be any way to limit the text field actual size on the form; just to limit the number of characters the field may receive.

I have inadvertently removed the development menus from a database and can no longer 'see' the tables, forms, and report to carry out maintenance. Can this situation be reversed? Thanks