Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by train2

  1. train2

    link to word document -protection issues

    thanks - I'll try it out when i get back to work on monday. JR
  2. train2

    link to word document -protection issues

    I've linked to a word document from a webpage - looks great and work fine. But anyone can then change the word document within their browser - obviously it won't save the changes on the server, but still i don't want anyone to be able to make these changes - i want it only to be viewable. is...
  3. train2

    Poss to hide filename of loading graphic?

    Is there any way of hiding the file name of a loading graphic in the browser status bar? I guess the filename is in the HTML and therefore will be viewable anyway, but just as a first step, any chance in hiding it? Thanks, JR
  4. train2

    Hoverbutton applet to go back

    Thanks for response. From what I've been reading, hover buttons need to be avoided too. Thanks, J
  5. train2

    Hoverbutton applet to go back

    Hi, I'm a novice user of frontpage, rapidly losing patience. And judging from number of posts about problems with hover buttons in frontpage maybe i should try to find an alternative. but anyway, maybe ther is a quick solution to this. Code is below. the hover button should go back to previous...
  6. train2

    dynamic crosstab query - possible to use variables?

    I can't search at the moment, so apologies if I'm asking a question that's been answered in the past. I would like to be able to prompt the user (or else use a form for entry) for a crosstab query. If i use the usual method in the query design for criteria eg.[Enter variable1], it doesn't...
  7. train2

    Mailmerge (excel-word)- cutting off after 256 chars

    Thanks for prompt reply. I'm using Word 2002 and Excel 2002. I'm just testing and I think it's more to do with Excel than word. With same word document, I've copied and pasted the cell values from spreadsheet to a blank one and relinked that spreadsheet. (just column headings and first record)...
  8. train2

    Mailmerge (excel-word)- cutting off after 256 chars

    A silly problem, but a very annoying one. It's working in some sheets/docs but not in others. I'm mailmerging school reports, and have a spreadsheet with long desciptions. (upto about 500 characters) They look fine in the spreadsheet. When I merge to Word, I see only the first approx: 256...
  9. train2

    can't print to network printer from access

    The problem is you can't actually open the reports in design view if it can't find the printer. Luckily, my problem went away (because the wind was blowing in an easterly direction on a thursday!) and I was able to get into the design again. But if you can't open the report in any type of...
  10. train2

    Importing from csv and adding field to existing records

    Thanks Larry, that all makes sense! JR
  11. train2

    Importing from csv and adding field to existing records

    Morning, I initially imported a load of pupil records from a csv file into a database table. Now i've been told to include another field for each pupil. I can get this data into csv format, with primary key and the new field data, but how do I "append" this fielddata to the existing...
  12. train2

    can't print to network printer from access

    Hello, We used to send our printjobs to a local printer but have recently renamed the printers to print via a spooler so that a quote manager could monitor print use. Now suddenly I can't print from Access. I can click on file - print - and see the printer defaulted which is correct, but I...
  13. train2

    report based on query run dynamically from form

    I'm back at work on this question. I had 2 strange results: 1. every time I entered details on the form, it prompted me after I'd clicked OK for the same data I'd entered. it only prompted me for the fields that I'd already filled in. presumably it's something to do with the datatype. the...
  14. train2

    report based on query run dynamically from form

    OK I'm getting there slowly. I've changed the SELECT on the report for correct INNER JOIN T_Progress_1 AS T_Progress ... i think that's necessary for the repeated table. Now as I'm using the same table 3 times, when I tried to run it, it worked, but of course, the data I was looking at was for...
  15. train2

    report based on query run dynamically from form

    Thanks for quick response. I'd also thought about that, but it's slightly more complicated - basically I add more tables to the query if the fields are selected on the form. I don't see how I could escape from generating SQL for the SELECT and FROM parts of the query. If I put them in the...

Part and Inventory Search

Back
Top