Recent content by cubdh23

What we are doing is we are using "Numbers Stickers" to identify certain assets, thousands of them. When a repair is done on the asset, this is logged and stored into the database. Now sometimes the asset cannot be repaired so it is replaced and a new "number" is placed at the same location...

Is there a cursor equivalent function for SQL queries? I want to be able to test each number in a column against something and perform actions on that number depending on the outcome of that test. But for this to happen, i need to one by one test each number in the column by scrolling down...

Ok nevermind. I have solved the problem. The problem was that i was using a Crosstab query to Group By my Cities. When using Crosstab, you are limited by what else you can do. I used a simple regular select query with group by and i got my percentiles.

Hi, I am trying to do this all day and i cant seem to make it work. I have used this IIf([qryCrossTab.Days]<1,"Day 1",IIf([qryCrossTab.Days]<2,"Day 2",IIf([qryCrossTab.Days]<5,"Day 5"))) In the field box where i use Column heading. My result produces a row such as this. Day 1 = 5 Day 2 =...

Great article by Banana. Thanks

IS is telling me that i need to set up a DSN-less connection. I have been connecting using DSN. I have surfed the net in search for DSN-less connection and it seems to be involved. Is this something simple to do? Or is it involved? Because if it is i will put this on hold, I have too many...

Yes I know I need IT buy-in. Your mention of our IT will bring up an entire new can of worms. I told them that i am done and i need help with the security part. They stall and stall and stall as they always do. It is so so frustrating working with our IT department. Whenever i request...

Yes I know I need IT buy-in. Your mention of our IT will bring up an entire new can of worms. I told them that i am done and i need help with the security part. They stall and stall and stall as they always do. It is so so frustrating working with our IT department. Whenever i request...

Thank you. Yes this is on a company network using windows. I am not an IT or IS person so sorry for my ignorance I will follow your advice. Thanks

I would not use Windows Authentication for this. I would have to install SQL Server on all the machines that will use this database and we do not want to do that. We just want to link the access to the server with the odbc connection.

Hi, I have an access front end and SQL Server Backend. I have created a form for users to enter username and password to get gain entry to the Access Front End. My problem is that the SQL Server Login then requires a UserName and Password. I want to be able to automatically fill in the SQL...