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 strongm 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. postmanphat

    Copying/multiple instances of sessions/bookings on a course

    Sorry I meant to say UserID not membershipID.
  2. postmanphat

    Copying/multiple instances of sessions/bookings on a course

    H iAgain, I've got it to pick up the membershipID and the courseID automatically now, but now it is just putting those attendees on the same, first session... not 'session 2'? Thanks again for your help! Dave
  3. postmanphat

    Copying/multiple instances of sessions/bookings on a course

    Hi dhookom, That very nearly works - it's not picking up the courseID or the membershipID from the subform (subSessionUsers) on the frmSession form automatically. Also, I populate the initial course session with my 10 attendees, when I run the query as well as doing what it's supposed to do...
  4. postmanphat

    Copying/multiple instances of sessions/bookings on a course

    ...I'm looking for. I want to create a simple course booking system. I've got the following tables (simplified): tblUsers - table of users UserID* Name etc tblSession - table of all sessions SessionID* Date Title etc tblSessionUser - link table between users and sessions to record who is...
  5. postmanphat

    Countdown timer to specific date/time (dd:hh:mm:ss)

    Hi. OP here... I've discovered a few minor problems in the code above - if the 'target' date is less than 24 hours away it will still say "1 day 23 hours xx minutes...." instead of "0 days 23 hours....". And on some times it doesn't calculate the hours properly in that it seems that the hours...
  6. postmanphat

    Countdown timer to specific date/time (dd:hh:mm:ss)

    Hi PWise, That will just give me however many millions of seconds there are until I guess 1 second past midnight on the 31st May. I need it to tell me there are 24 days, 1 hour, 12 minutes, 14 seconds or whatever to go....
  7. postmanphat

    Countdown timer to specific date/time (dd:hh:mm:ss)

    Afternoon all.... I've had a poke around on here but can't quite find the answer I'm looking for. I'd like to be able to show on a form how many days, hours, minutes and seconds there are until 5pm on May 30th? I'd like this to countdown 'live' while the form is open too. Actually the...
  8. postmanphat

    Excel - Calculations dependant on the value of another cell

    Hi, I've got the following table of pay grades and what the hourly rate is for that pay grade: Grade HourlyRate 3 7.674636175 4 7.971413721 5 8.268711019 6 8.564449064 7 8.863305613 8 9.160602911 9 9.538981289 10 9.834719335 11 10.31237006 12 10.78066528 13 11.26299376 14 11.76195426...
  9. postmanphat

    Manually increment ID in a table

    I've just found this http://www.tek-tips.com/viewthread.cfm?qid=1494834&page=7 and its helped greatly. Thanks
  10. postmanphat

    Manually increment ID in a table

    Thanks Remou, I've had a look on google and found websites such as this http://www.599cd.com/tips/access/incrementing-your-own-counter/ that explain how to set it up. I've followed these steps and similar things from 4 or 5 other websites but can't seem to get it to work at all. Every single...
  11. postmanphat

    Manually increment ID in a table

    Nope, its just a single user system.
  12. postmanphat

    Manually increment ID in a table

    Hi, I've had a quick look on here and online but without a great deal of luck. I have a table that has 2 fields AutoID (autonumber) and AppID (number). I want the AppID field in a new record to increment by 1 from the previous AppID when a new record is added. On the form, I already have a...
  13. postmanphat

    Calculating % in a query

    Typical! 2 minutes after I post this I stumble upon the answer!!! Thanks anyway - I hope nobody has wasted their time! Dave
  14. postmanphat

    Calculating % in a query

    Hi, I have a very basic table/form that collects evaluations - I want to be able to analyse some basic data I have a lookup field that lists 5 values: Excellent; Good; Ok; Poor; Very Poor. So lets say my table (tblQ) looks like this: AutoID Response ------------------------------- 1...
  15. postmanphat

    Outputting query results into a single cell/text file

    dhookom - thats brilliant!!! If I could give you a thousand stars I would!!!
  16. postmanphat

    Outputting query results into a single cell/text file

    Hi, I still get the message "Undefined function 'concatenate' in expression". I don't quite understand why you guys are all picking up on grouping it by surname. My database is just a simple repository of client details. What I am trying to do is to create a string of all the email...
  17. postmanphat

    Outputting query results into a single cell/text file

    Also, Access doesn't seem to recognise the concatenate function using the above example, although I imagine this is more to do with my syntax!
  18. postmanphat

    Outputting query results into a single cell/text file

    Hi Thanks for that, but I'm struggling to make it work. The article above describes how to do it if your data is spread over 2 tables which mine isn't. I simply have a column called 'email' in my tblClients table. I just want to output all of the entries in this column into a single cell...

Part and Inventory Search

Back
Top