Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. blondie41

    A Secondary 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...
  2. blondie41

    Moving DLookup results on form to a text box bound to a table

    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!
  3. blondie41

    Moving DLookup results on form to a text box bound to a table

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

    Moving DLookup results on form to a text box bound to a table

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

    Moving DLookup results on form to a text box bound to a table

    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?
  6. blondie41

    Moving DLookup results on form to a text box bound to a table

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

    Moving DLookup results on form to a text box bound to a table

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

    Module Question

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

    Module Question

    All are populated with real dates
  10. blondie41

    Module Question

    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]...
  11. blondie41

    Module Question

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

    Module Question

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

    Module Question

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

    Excel - How to move text with calculated field

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

Part and Inventory Search

Back
Top