Search results for query: *

Sorry I meant to say UserID not membershipID.

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

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

Hi, I've had a look about on here and generally online and can't find what 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...

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

PHV - Absolutely perfect!

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

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

D'Oh Cheers Blue

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

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

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

Nope, its just a single user system.

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

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

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

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

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

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!

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