Search results

Thanks DBguy. Can you please elaborate?

See attached db. The Get_WeekNo() sub gives me the results I need - but there must be a more efficient way of accomplishing this that I just can't think of at the moment. I'm trying to update the TheWeekNo field to the proper week number. Each new week begins on a Monday. As I said the procedure...

Thank you so much!!!

Thanks Bob! That worked! It opens on the left of the screen though. Is there any way I can have it be in the center of the screen?

I have a form (Popup = Yes, Modal = No). I have a command button on the form that opens a report. When the report opens - it opens behind the form. I can't close the form before opening the report because the report is dependent on a value of a field in the form (Honestly, I wouldn't want to...

Try: DoCmd.OpenForm "frmQuoteOverview", acNormal, , "

Thanks for the tip! Hadn't thought of that!

Moke123 - I use tags for that purpose all the time. But a control only has only one tag property. What do you mean by: My declarations are correct. You can check the value of the variable by using the vartype function. Thanks for the db.execute tip! Auntijack56 - I'm not sure I understand what...

All of the goals are now linked to the tasks. When a user clicks on a task lst_Goals presents only the goals associated with that task. If they doubleclick on a goal then they will have the option to delete it. If they doubleclick on a task they will have the option to delete it and all of its...

That worked. Thanks MajP! And thank you to all who responded. I really appreciate your help!

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?