Search results for query: *

I have a simple registration form with a dropdown menu for courses (eg. 101 Javascript, 202 ASP). I want to automatically write the course date and tuition to a textbox. I have a hunch that I wanna use a switch statement and that i have to pass the option value as a parameter but I'm stuck at...

Hi, I want to query 2 collumns and display the result in one text field. Here are my 2 Dlookups that I want to combine into something like "101 Access Forms". Thank you! Me.ClassID = DLookup("[ClassID]", "tblClasses", "[ClassID] = 101") Me.ClassName =...

I am a PB newbie. I want to create a Login window and check for username/pw and display the appropriate error message. If incorrect clear the SingleLineEdit field and set the focus to enter a new username/pw. Here's my code: //Local variables String ls_usnInput, ls_pwInput, crs_name, crs_pw...

I have many rows of text box pairs that need to display the result of a function call. There's more to it but the bottomline is I want to loop thru a collection and concatenate the text box names accordingly and display the result in the text box. I am stuck because sofar...

I have 10+ rows of textboxes that return calculated fields based on different criteria stored in the db. I want to avoid repeating a query 10+ times when the collumn name and the criteria change. So my idea is to create a collection and loop thru the elements to modify the query. Here's what I...

I want to avoid repeating a query 11 times (number of form fields to be populated). My idea is to create a collection and loop thru the elements so the query can be modified on the fly. Here's what I came up with sofar: Sub TestColl() Dim rst As New ADODB.Recordset Dim cnn As New...

Hi, How do I loop through a recordset and store each field in a variable. I need these variables to perform some calculations and I don't want to hardcode them because they are part of the business rules (like commission type stuff) that might change and then should only be changed in the...

Hi, I'm a newbie in Access. I have 3 bound comboboxes and other bound textboxes and radio buttons on my form. When I select an item in a combobox and close the form it overwrites the previous record in the database. This is NOT a desired behaviour. Here's an example when I select Region 2 and...

Hi Experts, I have a combo box based on a table/query row source. Me.cboInstallation.RowSource = "SELECT installation FROM MyTable WHERE region = '" & Me.cboRegion & "';" Me.cboInstallation = Me.cboInstallation.ItemData(0) The Control Source for cboInstallation is a field...

Hi, How do I update a group of radio buttons based on a selection in a combo box. My code doesn't work. Please give advice. Me.option_group.ControlSource = "SELECT OGValue FROM MyTable" & _ " WHERE MyTable.ComboBoxValue = '" & Me.ComboBoxValue & "';" Your...