Search results for query: *

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

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

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

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?

works...thanks!

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

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?

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

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?

perfect, thanks.

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.

I'm getting the following error: ActiveX component can't create object. Here's the code: strComputer = "." Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colProcessList = objWMIService.ExecQuery("SELECT * FROM...

Worked...THANKS!

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

Thanks guys!!

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?

Thanks!

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?

Perfect...THANKS

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.