Search results

MajP - Reread my prior posts. moke123 - I've attached a sample. Please follow these instructions to observe the issue: Open frm_NewNote Choose a location Choose a client Save Enter "Task 1" in the Task box Click Add Task Try to add another task - you should get a prompt stating that you must...

I'm using Table/Query. I'll try to post an example as soon as I can get to it.

moke123 - Your demo works just as you described. Unfortunately, when I set the rowsource to an empty table in my app the listcount is still 1. To answer your question: I have two listboxes (lst_Tasks, lst_Goals). lst_Goals is not yet visible. The user enters a task into a text box and then...

It's value is null since nothing has been selected. I tried using: For i = 0 To Me.List1.ListCount - 1 Me.lst_Goals.RemoveItem (i) Next but I got a "can only use this method with a Value List Rowsource Type" error. I don't believe I've ever run across this problem before. I'd be pulling my...

moke123 - I didn't know a listbox with a zls would return 1 for a listcount. Interesting. What would I need to do to have it return 0? This is an issue because sometimes the listbox does have 1 legitimate record in it. I need my code to let me know when it is truly empty.

--Column Heads property set to "No". lst_Goals.Rowsource = "" lst_Goals.Requery msgbox lst_Goals.listcount - This returns 1 Any ideas?

Thank you everyone. Issue is resolved!

I copied a database and renamed it from DN_Development to DN_Development_NewForm. Why does the old name still appear in my project box and how can I get the new name to appear instead? - Thanks! TS

I agree with all of you. I inherited this monstrosity. I'm going to rewrite it from scratch. Thanks!

Why is this minus sign showing in a table in query design?

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