Search results

Fascinating discussion. It seems that the people who design their applications using bound forms believe that using them is best while the people who design using unbound forms think the opposite. I suppose we will choose whatever works best for us. That’s perfectly okay. For me this is a no...

I need a vacation. Thank you.

see attached. Thanks for your help.

Auth_EndDate is a date field. It is stored as Short Date but I also tried General Date. I also tried <= #1/31/2022#. Still returns nothing.

When I run this query the proper results are returned: SELECT tbl_Authorizations.Client_LName, tbl_Authorizations.Client_Id, tbl_Authorizations.Auth_No, tbl_Authorizations.Auth_EndDate FROM tbl_Authorizations ORDER BY tbl_Authorizations.Client_LName; Results: Client_LName Client_Id...

Forget about this. I didn't have the rowsource type set. That was the problem.

See attached db. Open frm_Authorizations. Choose Mel Gibson as the client in the first combo box. The AfterUpdate event contains code that should populate cmb_Payers. Can anyone see why cmb_Payers is not populating? I've done this a thousand times with list boxes but I can't figure out why this...

Pat: That is correct. MajP: I am a stupid man. I am an idiot. What didn't you think I understood?

MajP - The funny thing is that as soon as I get the error the option group is cleared - so it would work just fine if it didn't produce an error. I can work around this by setting all the options to 0 individually but I was hoping I could do this in a more efficient manner. Pat - Thanks for...

MajP - Your code works great and is very elegant. However, I added one line to it to deselect toggle buttons within an option group and now I'm getting the "2448 You can't assign a value to this object. In Clear Controls" error. Public Sub ClearControls(Frm As Access.Form) On Error GoTo errlbl...

MajP - I get the "You can't assign a value to this object" error.

I found a way with text boxes and frames but the combo box won't clear: For Each cControl In Me.Controls If TypeName(cControl) = "TextBox" Then cControl.Value = "" If TypeName(cControl) = "Frame" Then cControl.Value = "" If TypeName(cControl) = "Combo Box" Then...

Hi All, I use the following code all the time to render my text boxes invisible: Dim cControl As Control For Each cControl In Me.Controls If cControl.Name Like "text*" Then cControl.Visible = False Next However, now I want to clear all text boxes on my form. If I use cControl.value =...

Thank you Bastanu.

Yes. I see that. Thank you very much.

See attached. Steps to replicate recordset issue: DoubleClick on frm_Login: User ID: tuser Password: testing Click on Directors/CCO button Doubleclick on Test_Client - EOF message box appears. This is correct since the record was not locked. Open tbl_Lock - You can see that the record appears in...

Gasman - Yes it is a pic of the table Moke123 - I just copied and pasted the SQL that the Access query designer generated. I also tried it without the parens. Still did not work. Isaac - I'll work on posting the actual database. I know that debug.print posts to the immediate window but since my...

CheckLock 241 SELECT tbl_Lock.UID, tbl_Lock.Full_Name From tbl_Lock WHERE (((tbl_Lock.UID)= 241)); UID Full_Name 241 John Smith

I changed it to: debug.print and then to: debug.print sql1 and there is no output. What should I expect to see?

I have a function that queries a table. The table has a record in it. But the recordset returns EOF. The first msgbox tells me that the query reads correctly. The second msgbox tells me that there are no records matching the criteria of the query. But there definitely is. If I copy and paste the...