Search results for query: *

Once again, PHV to the rescue. Thanks for that quick and efficient fix! Have a star!

Hi all - I have a table that an enduser imports once a month from excel. It has a field that is a date in 01/01/07 format, but when it imports, it sets this as a text field. Each month the user imports the data, overwriting the existing table, and then runs a form, which runs a parameter...

Excellent! Thanks for all the responses here. I really appreciate and value the opinions on this site, and this reinforced what I was already suspecting. Thanks all!

Hi all - I'm looking for some input on updating a database we have. I didn't build it, and the developer used a lot of macros. I use VBA almost exclusively. I seem to remember hearing at one point that access wasn't going to support macros in an upcoming version - that was some time ago - is...

Ah! That will help a lot! Thanks! have another star!

Hi - thanks for all your replies. Hm, it would seem we are missing the key piece of information - how to turn off track changes, in Word 2003, by default. We have the toolbar showing, and have deselected the track changes icon on that toolbar; in the tools --> Options --> Track changes window...

Currently, she has track changes supposedly turned off. However, Word 2003 seems to like to do the thinking for you - and tracks them anyway. That's the problem - it doesn't show onscreen that the changes are being tracked. It only shows when someone else with Word 2003 opens the document...

Hi - I have a user who has upgraded to Word 2003. She creates a ton of documents that she emails out weekly. Previously, she could use the Tools --> Track Changes --> Accept or Reject Changes window, click Accept All, and her document would be ready to mail out. Now, she is finding that...

Hm, well, I'm making progress, but have run into a snag. What I have done is copy all of the queries from the backend into this new frontend for the manager to mess with. I have used your code, using SELECT DISTINCT and IN pointing to the backend, to update these queries so that it looks just...

Very cool! I will give that a shot and let you know. Thanks Remou!! I honestly had no clue I could do queries against another db.

So how could I go about giving him a front end that has only these queries that he can build from, and doesn't have tables that he would edit? We need to provide a solution that doesn't require daily or weekly updating - he needs real time information, and we don't have the staff to constantly...

He wants to build his own queries, and run them. I know...but I can't change that part of the equation - he's upper management.

The tables are updated all day, throughout the day, each time they run this process on the AS400. I can give him a copy of the db, but have to use linked tables in order for him to have up-to-date data. And it seems that he can add and delete data from these tables, which I want to prevent...

Hi all - I have a simple access db on the network, that exists primarily to generate a report for our users, and which gets it's data from our AS400. This db contains maybe 4 tables, which are updated by code run from another program. It dumps the info into a txt file, and there are macros...

Hi SKip - my data labels were coming from an excel spreadsheet, so I couldn't edit them without compromising that spreadsheet, which was part of my publication. What I did discover though, is that changing the size of the chart area would force some of them to wrap if they were close to the...

Anyone know how to get my data labels to word wrap on my chart? The size of the labels doesn't seem to be changeable. What i don't get is that they are word wrapped on some and not on others. I need to get it to wrap more of them so they will fit in my publication. Any ideas? Thanks in advance!

Thank you Gerry!

My boss has a new version of Word. He likes the way the compare documents function worked in 2000. It strikes through the deleted text, puts new text in red, and leaves old text in black. His 2003 marks up the document with bubbles on the right that say "deleted" and show the original, and he...

Just to let you know, I'm still working on this. I went to the user's machine itself, and tried changing it from the formfield to formula field as you suggested, macropod, and still encountered problems. It would add *some* of the items now, but not all. So i need to dig a little further...

Hi, sorry to be away from this thread. I was out of the office for a while. Anyway, in answer to your question macropod, this is a word form that is protected for forms. There is a table, and in one column the user enters monetary amounts. The last cell in that column has the following in...