Search results

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!

This was a real big help with several forms! However, I have a busier form which this method is inadequate for :( I have to display 25 figures on one screen. All of these figures are count totals of applications again. So no text values, just numeric 25 count values mean 25 text boxes to...

I have a further issue on the same subject, I can't update the new password! Using a change password form, I can check the current password, I can check that the two new passwords match but I can't add the new password to the table! So a pretty big omission in functionality! This stuff below...

Searched the internet, searched the forum. One thing I just don't understand is how you actually use these. I must be insanely stupid. I've made all the needed queries, I've made a combo box which uses a query to display all courses (2 columns, course_code and Course_Name) and all the queries...

Cheers, I could use that too, I'll have a go

I may be adding fuel to the fire here but...how you add code to a switchboard? As the form it displays seems to be a template from which all other switchboards are based, which surely doesn't support individual button configuration, or does it? I feel more inclined to go with a previous post...