Search results for query: *

I decided to give up on trying to upgrade this project. They have no desire to use anything but Access for any database project. It does not look like they intend to use anything but Access for the next 10 years. I will give up trying to learn the .NET platform. Thanks for your responses.

Someone brought up a good point to me today. She said, "Sometimes you have to take two steps back to go four steps forward". Meaning that if you are embracing a new technology, you might have to take a lesser paying job at first to get your feet wet.

Yes, it is true that nowadays no one really cares if you have been an Access programmer. It's good for making an interviewer chuckle however. If I had to do it all over again, I would not have set myself back by getting too deep into the Access world. That was a major career mistake. The...

If Microsoft canned Access I think that would be a great thing.

I have read conflicting reports on this product. Can I still use Access as a front end to SQL Server Express as I did with MSDE? Or do I have to use .NET in some shape or form? Thanks

Thanks for your response. I found a code snippet online that made use of a static class called Visits that interfaced with a database. I want to maintain a hit counter for the application as a whole, not for individual pages. I would think at session_start would be a good place to increase...

I want to create a hit counter for my web site. I have some ideas on how to implement this but I'm looking for feedback from more experienced people. 1- I will have to store this hit counter in either a database or some other file, perhaps an xml file. Which is better? I tried opening a...

All these are good suggestions, but again in order to be a DBA they want you to have a minimum of 5 years experience as a DBA. What I am in the process of doing is creating a web site using discountasp.net. Everything will be done in C#/ASP.NET/SQL Server. I am going to create a sample...

I already know VB6...been there and done that. As far as SQL Server is concerned, I know how to do the intermediate level stuff, creating stored procedures, etc. I don't see the use in learning anymore about VB6. It is no longer used for new development. It's more for maintaining legacy...

Thanks for the response. The thought of taking a pay cut doesn't appeal to me. I've worked hard to get where I am at and going back to being a junior programmer seems like starting from ground zero again. There has to be a better way. Well I brought up this idea to the manager at work, to...

I have spent a number of years being a very good Access developer, but I am realizing this is doing nothing for future career aspirations for working on larger database projects (SQL Server) or other development environments like .NET, etc. The consensus in the computer world is that people who...

Thanks Guru...

Has anyone here used this and can you use it to create a small to medium sized application? Also is this free?

If you want to do this programmatically, this is one way to accomplish it. In this case I have hard-coded an actual Word document on the hard drive, but in your case, you can use the file explorer. Private Sub cmdAdd_Document_Click() With Me.Document .Enabled = True...

This link here is very good. They have tutorials, entire sample applications, etc. I'm thinking you want to guide your training towards the Crystal Reports.NET, which is integrated into Visual Studio. http://www.businessobjects.com/products/dev_zone/

I have created a random number generator. What I am trying to accomplish is to add a specific number of random numbers (from a sorted list of numbers 1-187) to a list box. I want to then sort the numbers in numerical order in the list box. Once a number is selected I don't want to pick that...

But your answer helped me to get to the solution I was looking for. Thanks a million.

I did it like this and it works: PARAMETERS [@Task_Order_Number] Text ( 255 ), [@BeginDate] DateTime, [@EndDate] DateTime; TRANSFORM NZ(Sum(c.Hours),0) AS SumHours SELECT b.TaskOrderID FROM TaskOrder_tbl AS b INNER JOIN ((QA_Rep_tbl AS d INNER JOIN Task_tbl AS a ON d.UserID=a.UserID) INNER...

The cross tab you suggested isn't working for me. I am thinking it is because it doesn't have a group by clause?

What I'm trying to do is display a row of column totals at the bottom of a crosstab query. I can easily get the row total. What I'm trying to show is the number of hours worked on a project per each employee. EmployeeA EmployeeB XYZ 15 17.0 XZX 20...