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!

Search results for query: *

  • Users: train2
  • Content: Threads
  • Order by date
  1. 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...
  2. 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
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. train2

    Workgroup Administrator IN Access - not wrkgadm.exe

    Hello, Everything I've read about security in Access keeps pointing to this exe file that you can run to set up a new workgroup. I don't have this file, and presumed it was something to do with my installation. However, after reinstalling i still didn't see it. Now I've used the Workgroup...
  12. train2

    query doesn't understand the * in combobox

    Hello forms fans, I'm having probs with a combo box on a form. I've added * at the top of a combo box with a Union query, so that users can select all teachers. I have a linked combobox which should return all related classes for that teacher - it works very nicely for every single teacher...
  13. train2

    How to populate fields automatically on update - username and time

    What a wonderful place this forum is. Thanks to this forum I've managed to capture the OS username for use in my database. A big step forward for someone of my abilities! What I'd like to do is now to automatically capture the username and current date, when a record is updated. (the record is...
  14. train2

    is there a limit to number of users opening an Access database?

    Hi everyone, I heard a rumour that there is a limit to how many people can open an Access database at any one time - is there any truth in this? Unfortunately I can't check this out right now, because I'm working from home. My database is very basic - I have no security set up yet, and just let...
  15. train2

    problems with security - no wrkgadm.exe

    I'm working on access 2000 and need to start setting up security and permissions for the database - i can't find the wrkgadm.exe file that is for setting up work groups etc. I thought maybe I'd just not installed the complete MS Access program, but a reinstall hasn't helped. Am i missing...
  16. train2

    check whether record already present before updating/appending?

    I have a situation where in most cases I will want to append a new record. however, it could be that an old inactive record (I have a flag to label it active or inactive), could just be reactivated. how can i check whether a record is already present before attempting to append? I'm new to VB...
  17. train2

    appending record based on combo box choices

    Am I being incredibly thick? I've created a form with various combo boxes- the form is not based on any table or query but "homemade". I would like to append a record to a table and thought that creating a button to run a macro to run the append query would work. But I think my...
  18. train2

    Crosstab confusion - how to choose column titles

    Basic explanation of situation: I have classes with pupils. For each pupil I have 3 fields (current, target, future) that can take values 1-8 (for levels). I would like a report that counts the number of pupils at each level for each of current, target and future for each class. To do a...
  19. train2

    Separate databases for data and logic

    I'm setting up a database in a school and need to keep the data separately for different year groups. However, I'd like to keep the logic identical for all years. Is it possible (without too much programming and difficult stuff) to set up a switchboard-type-screen listing the year groups...

Part and Inventory Search

Back
Top