Search results

Sure. Please find attached my query results. From this query I would would like on a form, to list all of the module names and then list the amount of times they have been chosen. I've managed so far to use: LBLPopularModule.Caption = DLookup("ModuleName", "QRYModuleChoices", (DMax("Total"...

Thanks, i've managed to sort out the querey now. Using the CountChoice1: Count(IIF([Choice1] = [Field], 1, Null)) given above. As a complete beginner I was just being very slow! Now I have by query working (see attached), I was wondering how to then use this in say a form to show all the...

Hi, I've attempted number 3 from your suggestions. However I don't seem to be lucky. I'm quite a novice so the likelihood is i've missed a key step along the way! The main objective is to somehow have a look at all six choices add together the unique choices and the ammount of times they...

Many thanks for the informative post! I will have a try with your helpful solution and i'll post my progress! Thanks again T

Hello, I have a table with 6 fields I would like to count. Choice1, Choice2, Choice3, Choice4, Choice5 and Choice6 The table stores choices that a user may wish to enter. The choices are selected from another table called 'choices'. The user enters in a choice using 6 combo boxes in a form...

This as not working so I decided to look at where in the index of the combo the ">Create New" was and did the if statement based on that. If ComboPreReq.ListIndex = 0 Then DoCmd.OpenForm "NewCourseInput" MsgBox "OK" Else MsgBox "Error in test" End If

Thanks for your reply. I've attempted to trigger the code on the ComboBox itself on an AfterUpdate and a OnClick with no success as yet. Many thanks

Hi I'm currently creating a form that will allow a user to enter a college course onto the database. However some courses cannot be selected with certain courses. Currently i'm using a combo box that will allow the user to select a prerequisite from a dropdown. However if the course is not...

Thanks. I was going down the route of putting the data in the table. That worked a treat using: Me.[Discount] = Discount Many thanks you really helped!

Hi, thanks for the very fast reply and information. Just to clear things up, I should of given this info before hand. I have 3 option groups. Salary, EmploymentType and PurchaseValue. Each one delivers a value 1 or 2 depending on which of the two options is selected. My code looks like...

Hi, I'm a real beginner with VBA so please accept my apologies. I'm having trouble with my code In a form. I've used VBA to calculate a number stored in the variable "Discount". I would like if possible, when the Discount is calculated to save the number in a table called "Customers" under...

Hi everyone. I'm new. Just thought i'd introduce myself. thanks