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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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...
  16. train2

    report based on query run dynamically from form

    Hello again, I could do with a little leg up on this one. I've read a couple of threads but none seems to sort out this specific issue. I've got 3 choices on the form (all for same field, but trawling through same table up to 3 times). Based on the 3 options (from 1 to 3 choices allowed), I...
  17. train2

    how to show/hide a whole table in query based on user input

    This is the way I'm just trying.... I'm basically writing in VB to create the SQL syntax based on whether fields are blank / or not. Is this logical?
  18. train2

    how to show/hide a whole table in query based on user input

    I can't find a similar thread to answer this question. I have users selecting on a form, to include fields in a query. The data is from the same table that I've included three times in the query design, and I'd want them to make up to 3 choices. I've got it working fine for when they make 3...
  19. train2

    Logic of database and data model

    I'm embarrassed at my stupidity - i just remembered i can add the same table twice in one query - and if I've got the fields in a query, I can figure out how to allow the user to select from combo boxes on a form. ... i'm still learning!
  20. train2

    Logic of database and data model

    I'm a little lost regarding the data definition of my database. I've started looking into ways of creating dynamic reports, so that they are flexible for users, and find that I can't figure it out. Story so far: I have pupils that belong to classes (so a pupil table, and class table, and a...

Part and Inventory Search

Back
Top