Recent content by xuanb

Yuhuuu! Working like a charm...Thanks a lot Adam and have a great holiday! Xuan

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...

Bob, I used your 1. solution with =Sum([field]) but the problem I get is when the query of the subform returns null, i.e. no rows. For example when students have no classes registered and therefore no credits. I've tried If IsNull(Forms!MainForm!SubForm!Credits) Then Me.TotalCredits.Visible =...

Yes! With a little modification... Me.myfield = DLookup("[ClassID]", "tblClasses", "[ClassID] = 101") Me.myfield = Me.myfield & " " & DLookup("[ClassName]", "tblClasses", "[ClassID] = 101") Thank you for your help! Xuan

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 =...

Thanks again Rob! Just what I needed.

I tried your code snippet and modified my sql statement to WHERE username = :ls_usnInput AND password = :ls_pwInput. That part is working swell! To improve user friendliness, how would i check for the pw separately and return focus to the pw field if the uid is correct so the user doesn't have...

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...

Steve, I read this thread 702-548238 and noticed your comment. "If you need the form to be flexible and change its mode between data entry and non data entry mode, then this can be done programmatically." Can you please follow up with this? How do I check if the >* button for adding...

Lightning and thunder!!! :-) :-) :-) Exactly what I needed. And so quick, too. Thank you so much, Jeff!

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...

If I understand you right SQLString and qryQueryname are both the same thing. What you want is SQLString = "SELECT * FROM tblYourTable;" Me.RecordSource = SQLString RecordSource is a Form Property

I got an out of bounds error. I believe you forgot to increment the AbsolutePosition. If Not rst.EOF Then 'Populate recordset so we can use the RecordCount property rst.MoveLast rst.MoveFirst End If ReDim MyVars(rst.RecordCount - 1) 'Dimension the array (zero-based)...