Search results

You haven't even done the most basic of troubleshooting steps yet. Click "Debug" and find out which line it stops on, then start debugging using normal Immediate Window techniques, etc., google that if needed. There is no need to do all the other stuff when you have not even debugged your code...

a "Mazi"

This problem has nothing to do with Windows or versions. It's a design problem in your database. Place breakpoints in all Form event-related code (startup, load, current, etc) and step through them at runtime line by line until you figure out at what point you have coded something that does...

@zezo2021 You really should try to post questions that are able to be answered, rather than just 1/100th of a complete thought and then waiting until everyone wrestles you to the ground and pries the rest of it out of you - that's laziness in the programming world. What do you want to do...

Yes, agree whole heartedly. The best solution is some sort of service account concept, which my crude suggested solution was a nod to, and probably would be "the" perfect solution if the plain text password in the tables' connection strings could be solved for, or dang near close. I worked for...

In all fairness to the original poster of this thread, I think this is a bit of an oversimplification-in-the-interest-of-dismissing the legitimate concern. Security is a legitimate concern, and the answer to your question is: "YES", absolutely, security-against-user-malusage is completely, 100%...

I liked dbguy suggestion about ftp as it made me think of other things too. As just one (of many possible) random examples, check out Adrive.com They offer very cheap plans and FULL ftp capability - totally open (not just sftp) which would allow you to store files and then write vba code to...

Thanks again for jogging my brain. I did end up doing something like: case when exists (select 1 from labdetails LaterLab where LaterLab.id=mainLab.id and LaterLab.collectiondate between MainLab.collectiondate and dateadd(hour,48,mainLab.collectiondate) and...

Awesome! I just saw your post after I posted mine - thank you - that looks like it will work. Not sure why at first I thought this was so complicated but now it seems simpler huh - sometimes just asking the question is helpful. Thanks again

I just realized I can just make a correlated subquery like case when exists (select 1 from sametable t where t.id=maintable.id and date is within range and value is greater such and such) then y else n and then aggregate them on max y/n

I'm going to have a dataset in a temp table with columns: PatientID (varchar) LabValue (float) CollectionDateTime (datetime) A patient ID may repeat 1, 5, or 100 times in this table, with various collection dates and lab values. I need to end up with the following information: For each...

Oh I see an article now - datediff(Anything,Startdatetime,Stopdatetime)/Something.0 works great. I knew that two integers divided would return an integer, but I had tried and failed to cast one as a decimal because somehow simply wrapping the datediff in a cast as decimal...didn't work...

Datediff(hour,startdatetime,stopdatetime) returns INT. Datediff(hour,startdatetime,stopdatetime)/24 still returns INT. I want a decimal or two on there, so that I can calculate partial days (it all adds up when aggregating). What's the proper solution and understanding of same?

@CJ_London Left join slower than inner join? in sql server? I think the opposite

I can do this: Select * from Table1 Left join ( table2 inner join table3 on blah blah ) on table[2 or 3].column = table1.column It can be a handy way to left join to 2 tables that, themselves, almost-always/always need to be inner joined to each other. Does anyone know of any "gotchas" -...