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

    Software Laws??

    Not sure if this is the right forum... A friend of mine owns a business and he purchased a desktop software package with a local DB. Since then, he's paid regular support/upgrade costs. Now, he wants to make a switch to another software but when he called the existing vendor, they said that...
  2. NFLDUser

    DateAdd

    Sorry, yes that was right. My problem was a few lines beyond this. :)
  3. NFLDUser

    DateAdd

    I am using DateAdd but causing problems when I change to another month. Any ideas on how to get this to work? I am looking to just find a way to add a day to a specific date, but for it to automatically go to the next month if necessary ... and I am stumped! updateDay (100...
  4. NFLDUser

    Error Registering File

    When a user enters a form with basic controls (buttons, imagelist, frame...), the user gets this error: The error number is 339. "component '' or one of its dependencies not correctly registered. The file is missing or invalid" Frustrating that the component isn't specified. Any ideas?
  5. NFLDUser

    How can I join 2 tables?

    works...thanks!
  6. NFLDUser

    How can I join 2 tables?

    I have a table called Billing that holds all a stores transactions. I use the following query to figure out totals based on each payment method (Cash, Visa, Debit, etc.). SELECT Sum(IIF(isnull(paid),0,paid) + IIF(isnull(provided),0,provided)) AS totalpaid, method AS typepaid FROM Billing GROUP...
  7. NFLDUser

    A Combo Box for selecting time ... does this exist?

    I am allowing the users to select their start and finish times for their business for each day of the week. If I manually use a combo box and plug in the values with say a 5 minute interval, thats a BIG combo box. Are there any components that work similiar to a DTPicker? ... but for time?
  8. NFLDUser

    Determine totals based on another field.

    Thanks ... that worked like a charm. :)
  9. NFLDUser

    Determine totals based on another field.

    I have a table with a field called pat_num for our patient numbers. Another field is called cost. I want a way to figure out the pat_num with the highest total cost. I guess I want to find the patient that has spent the most money. Any ideas?
  10. NFLDUser

    How to get the number of users connected to an Access DB

    perfect, thanks.
  11. NFLDUser

    How to get the number of users connected to an Access DB

    We are using an ADODB.Connection to an access database. Is there a way that I can grab the number of connections or current sessions to that database? I have a compact/repair utility built into the software but I want to tell users what workstatations are still connected. Thanks.
  12. NFLDUser

    Error Trying to Remove running app

    ...= GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colProcessList = objWMIService.ExecQuery("SELECT * FROM Win32_Process WHERE Name = 'Eyesistant.exe'") For Each objProcess In colProcessList objProcess.Terminate It's dying on the...
  13. NFLDUser

    ORDER BY Question

    Worked...THANKS!
  14. NFLDUser

    ORDER BY Question

    I have a query with a few fields that I am creating. I want to order by on one of the fields that I create but I get an error asking for the order by as a parameter. SELECT IIF(Billing.invoice_num = -1,oInvoice & " (Payment)",Billing.invoice_num) AS newinvnum, Billing.method...
  15. NFLDUser

    Query returns null problem

    Thanks guys!!
  16. NFLDUser

    Query returns null problem

    I have the following in my query... CCur(Avg(paid)) + CCur(Avg(provided)) AS avgvalue Sometimes paid or provided is null so it kills my avgvalue. Is there a way to wrap it to make it a 0 when its null?
  17. NFLDUser

    Matching fields in databases

    Thanks!
  18. NFLDUser

    Matching fields in databases

    I have a table called PatientList with a field called prim_key representing each patient. I also have a table called Recalls with a field called pat_num. Is there a query that will tell me what patients in PatientList do NOT have a recall associated with them?
  19. NFLDUser

    Query to return total number of dates from this year?

    Perfect...THANKS
  20. NFLDUser

    Query to return total number of dates from this year?

    I have a table called PatientList that has a field called frst_visit that indicates when someone becomes a customer. How could I return the total number of customers that dates are from the current year, one year previous and 2 years ago. So I am looking to return 3 values.

Part and Inventory Search

Back
Top