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!

Register Log in
  • Congratulations Chriss Miller 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. UKRacer

    How to Delete Specific Relationship

    Good point Don! Anyway - I would certainly try a compact/repair of the database (after taking the mandatory backup, or course!!) If this doesn't work - try this: Make a new database file, and import all your objects into it (queries, forms, etc etc). Then import the tables, but before you...
  2. UKRacer

    Rounding

    It looks like you always round down to the nearest 1/4. If this is so, you can use the following expression to return the result (let's say you have already calculated the hours worked, and called it "hours"): RoundedHours...
  3. UKRacer

    Hows do you do a ranking in a Query?

    This is probably a long way round, and others may have a better solution, but it will work for you... I can't think pf any way round the need for a second table (called, let's say "tblRanked") with fields matching those you want to display, and in addition an autonumber field. Let's...
  4. UKRacer

    Calculating age from Date of birth in a Access Query Field

    You can use the following formula in the query - assuming the field containing the date of birth in your table is called "dateofbirth" (!) Current Age: Int((Now()-[dateofbirth])/365.25) There may be other ways using DatePart, but this works, so hey! Pete
  5. UKRacer

    How to Delete Specific Relationship

    You may have tried this - To make sure there are REALLY no relationships, click on "relationships" and "show all" from the menu bar in the relationships window. It is possible that you deleted a table from the relationships view without actually deleting the relationship...
  6. UKRacer

    Permissions for FP2002 File Upload Component

    Hi all - Does anyone know how to set permissions for allowing the use of the new file upload form component included in FP2002? As far as I can see the only way it will work is to create a new user with full "author" permissions - anything else and permission to upload is denied. Now...
  7. UKRacer

    Website feeding database

    Ah! Well, you can find cgi scripts to POST your form results to, which will both email you the results and add them to a txt file on your server. Your ISP should have this script available. If not, look on scriptsearch.com Easier still, though, is if your ISP has FrontPage estensions...
  8. UKRacer

    Converting Word Docs to HTML

    Yeah - I HATE Word's formatting! I often get updates from clients in a Word doc, and I always get the copy into FrontPage by: 1) copy/paste to notepad first (which strips out the formatting), then 2) copy/paste to FrontPage (where I have already made an empty template matching the layout of...
  9. UKRacer

    cell width

    The only way I've found to make rounded corners is to do it by creating eight tiny graphics, and putting them round the edges of a 3x3 table. topleft, topcentre, topright, middleleft, middleright, bottomleft, bottomcentre, bottomright. * Make sure that the height and width of each corner...
  10. UKRacer

    Website feeding database

    Hi Kieran Two suggestions - neither really easy I'm afraid - others may have further suggestions - but here you go: 1) Set up a MySQL database and write some script (php?) to write your form results to the new database. Then you would have to take the informatino from the new database to your...
  11. UKRacer

    Alternating sort order in a form

    Dunno if this would be easy or not, but how about DoCmd.ApplyFilter ?? Just a suggestion, may be wide of the mark! Pete
  12. UKRacer

    query theory

    Try this - If I have understood you correctly, you may be asking the query to display matching results from 5 tables (1 main table linked to 4 others through the id you have set up), when there may not be a single record in the main table which has a match in EACH OF THE OTHER 4. The solution...
  13. UKRacer

    access and asp

    Hi sweetleaf - Firstly, I think that if you use the nz function in a query, you MUST provide an "if null" argument; hence if you want your values to be zero, your expression should read: a: nz([field1],0) + nz([field2],0) BUT I have a feeling that the nz function would not be...
  14. UKRacer

    Pass variables on Web

    I posted the above at the same time as Dave - I didn't think of Request.Querystring - that's neater than using session vars! Cheers Dave! Pete
  15. UKRacer

    Pass variables on Web

    Hi Rob Is the variable from a form? If it is not, you can simply set a session variable to carry values from one page to another (although I believe cookies must be enabled at the client side). Use <% Session (&quot;session_variable_name&quot;) = 20 %> which will assign a value of 20 to the...
  16. UKRacer

    Search page not working!

    Hi tazzer I'm new to asp but I managed to accomplish this using FP2000 - I'll try to explain what I did - but you'll have to write your own code! Top of my page I have a database results region which is based on a WHERE statement looking for a variable name that matches the name of a drop-down...

Part and Inventory Search

Back
Top