Search results

Nevermind. The DBGuy gave the solution on this link: https://www.access-programmers.co.uk/forums/threads/subreport-missing-column-heading.307180/

I have a report called r_Trackingreport. There is a subreport in it called r_Tracking_Sum. If you do a Print Preview on r_Tracking_Sum you can see the field names in the Header section. However, if you do a Print Preview on r_TrackingReport all of the data appears as expected – but the field...

MajP - I think Access is excellent at supporting unbound forms. Also, its GUI is superb. I agree that VS is excellent as well, and I have used it many times, but I don't care much for the .NET framework. PH - Why do you think I think Access is inferior? I've been using it for over 25 years. It's...

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