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...
...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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.