Recent content by Ollie_3670

Right, the control source is currently set at usergroupname with the row source being TblSecurity and the bound column being 1 I changed it to the primary key, the UserGroupID, and the bound column 0 but then I couldn't change the values in my combo box :/ Any ideas?

Cheers, I'll have a look at it tonight! Haven't been able to get on here much recently..the forum always seems to be updating!

I have a combo box with multiple columns which are: (UsergroupID;UserGroupName;Password) Currently only two usergroups are used, "administrator" and "admissions tutor". These reside in TblSecurity Columns 0 and 2 are hidden, and column 1 is used to select a user name. This works fine for the...

YES! Amazing, now to expand it all myself! :) On the bright side the queries only get as difficult as one more "where clause" field: =DCount("*","QryUberTest","[Course_Code] = '" & [courseSearch] & "' AND [EU_Status] = 'EU National' AND [Offer_Type] = 'UF'") Which works as well! :D

YES! Amazing, now to expand it all myself! :) On the bright side the queries only get as difficult as one more "where clause" field: =DCount("*","QryUF_NonEU","[Course_Code] = '" & [courseSearch] & "' AND [EU_Status] = 'EU National' AND [Offer_Type] = 'UF'") Which works as well! :D

I'll try all this in the morning! ..Is it sad that this excites me? ha! and yes I wish the form was that simple! but I'll have maybe 20 or so textboxes instead of 2. Thanks again! Edit: Right It bugged me too much, so I gave it a go! I plugged it in and there were no error messages! (yey)...

Here's the PrntScreen!

Hi Stuart, Welcome to the forums! Seems like me and you are in pretty much the same boat with this problem: This is my last major hurdle and I hope for both our sakes we can find the simple answer soon! :) Check out my Thread "Using Dlookup and Dcount Templates" in the "query" section of the...

Alrighty, I got a little confused initially! So, in layman's terms what you suggest is: Make a Combo box instead of a textbox Tell it to get it's information from one of the queries. Then use that "Listcount" function to count how many records the combo box holds? Ill get that screen shot...

If I can get the "Count(fieldname)" field's value from a query to appear in a textbox, I'm a happy chappy! Whatever way you find easiest explaining!

From what I have read, it seemed that using DCount or Dlookup was the way to make a textbox display the numbers from a query.

looks top dollar! Cheers! Really appreciate the help! However I have a little niggle: If passwordverified = True Then CurrentDb.Execute "UPDATE tblsecurity set password = TxtNewPassword where me.cbousernamebox.column(1) = usergroupname" MsgBox ("Congratulations, your password has now been...

OK, fair one, let me try again, but this time with a scaled down scenario you can relate to more! Let's say I work in a small European sales department for Microsoft. My boss would like to be able to see, the number of EU-nationals, and Non-EU customers who buy each product (ie, MSAccess...

I was originally planning to do the count at the query level and use Dlookup, rather than use Dcount to count all of the records a query outputs However, I suppose I could do it either way! If telling a textbox to count the amount of records a query outputs is easier, or you know how to do it...

Not sure how to do an update query! Sorry, forgot to mention that little important note!