Search results for query: *

I have an access database that is used to assign cases based on certain attributes and workload capacity of individuals. As a case is assigned to a worker, their capacity is reduced by one. (I have figured out how to do this). However, there are some variables that I can't figure out and...

Thank you so much. I cannot even tell you how frustrated I have been for HOURS and HOURS. I swear I tried this exact idea and it did not work. However, I started from scratch and it works like a champ! Sometimes you just need to slow down, ask for help and take a deep breath. Bless You!

Sorry - I thought when I said "it is still not working" that was enough. Please excuse me for not knowing the proper way to write it. I do appreciate the help, but I am really struggling... The form is bound to a table - so I assume that would be considered the record source. I am using the...

Yes - I tried it. It does not work. Nothing populates txt2.

Thanks for the answer, but it is still not working. I hate being "that person", but I forgot to explain how I got the DLookup to work in the textbox. I created a command button and added me.refresh which is how txt1 is populated. Could this be part of the problem?

Thank you for your help. The end goal of this database is to create a table of "work assignments" so yes, I do need to store this value in the table. txt2 does have a control source back to the table. txt1 does contain the DLookup expression and works well. You say I need to have another...

I have found many answers to this problem, but cannot get any to work. I hope someone can offer some help. I have a form with a text field that performs a DLookup from a query(txt1). That part works great. However, I need to have the data bound back to the table that the form is bound to...

Thanks to everyone for your help. Between the new code and the index (reminder), things seem to be working. It is still not as quick as other queries, but I am assuming that is the nature of using a module? If anyone has any other tips about query speed while using a module I would really...

All are populated with real dates

So sorry - I have been banging my head against my monitor all morning - below is the correct SQL: SELECT DISTINCT Fax1.CareAdvocate, Fax1.EndDate, Fax1.StartDate, Fax1.ApptDate, Fax1.DischargeLOC, Fax1.Count, ([ApptDate]-[StartDate]) AS [Appointment Date Difference]...

Yes - and thank you so much for your help! SELECT DISTINCT Fax1.CareAdvocate, Fax1.EndDate, Fax1.StartDate, Fax1.ApptDate, Fax1.FinalDisposition AS Expr1, Fax1.[Last Certed Date] AS Expr2, Fax1.DischargeLOC, Fax1.Boards AS Expr3, Fax1.Count, ([ApptDate]-[StartDate]) AS [Appointment Date...

I removed the table 'Holidays', but it still locked up. Any other ideas?

I added the following module which seemed to work correctly for a few days, but is now causing the query to "lock up" my PC (the query runs forever). Can anyone help me understand why this might be happening? The module is: Public Function NetWorkdays(dteStart As Date, dteEnd As Date) As...

On one worksheet I have a list of names in column A and various values in column b. On my other worksheet I have a list of the "top 5" (numbers from column b)by using the LARGE function. This works very well, but I would like to bring the "Names" that correspond with the values as well. I...