Search results

Thanks, works great!:)

How do you have a date field return the previous month data? For example i have a date field and the criteris needs to be all days from the previous month. So if i was running this Jan 31, 2011, i need it to return me all records that have a date between Dec 1, 2010 and Dec 31, 2010. Next...

Its what the customer wanted :)

I needed to round to the nearest 1000 and found this link to be very helpful! http://allenbrowne.com/round.html This is some of what is included on the site: Round to $1000 The Round() function in Excel accepts negative numbers for the number of decimal places, e.g. Round(123456, -3) rounds...

I am using SQL Server 2005 Management Studio to create a maintenace plan for my database. When I get to the part where you set up the back up of the transaction logs and i select specific databases, it only gives me one of two choices; all users databases or model database. I have tried both...

I am moving a SQL database from SQL server 2000 to SQL server 2005, both on different computers. I am able to detach but when i try to attach the database on the computer that has SQL 2005 i get an error message saying the file is ready only. I copied the files to the folder where the system...

I have an Access database that is shared with other user that have different resolutions and when viewing some forms it does not look right. If you have multiple users with different screen resolutions, what are some ways of dealing with this? I notice with Northwind DB example, when you...

I cant seem to get this to work, i have three fields and a total field in a form that will not total if one of the three have a null value. field1+field2+field3 = field4, all are number data types, all have 0 default values. Problem: if user needs to change or move a value from say field1 to...

Thanks everyone, I agree with the License approach. I found this web site that sells a Software Licensing Agreement for a very reasonable price. I also had my lawyer look it over as well. here is the link http://www.techagreements.com/agreement-preview.aspx?num=564376

I will try to explain, I have an Employee table with names and an Education Degree table. They have a one to many relationship because an employee can have more then one degree. So for my report i want to list just two fields one that for employee name and another for Degrees. I need to merge...

I need to merge the two or more values in the Degree field, not merge Employee Name with Degree.

I have a report that I would like to have one field merge data into one record per employee when there is multiple values in that field. For example: Field: Employee Name - Jane Doe Field: Degree - Bachelors of Science - Bachelors of Art...

As a freelance consultant. I like the License idea and don't know how to go about it, can you explain how that works? For instance, does one charge different for license than ownership? Are there different types of licenses?

Thanks Shadow, I certainly got alot out of your comments. What about what gemma-the-husky said "get it clear who owns whatever you do". If i want to sell an existing database to more then one company how would i handle ownership? Thanks in advance for any advice

Does anyone have a sample Contract for selling a Database?

Thanks so much it worked great!

I would like to be able to double-click a value in one form and paste the value into a field of another form. What code would be needed to perform this?

I need to create a short cut menu in 2007 that will have the copy and paste command. I went to Access help and it showed how to create a shortcut menu using a macro but when i attempted to create this macro i could not find copy or paste in the ACTION column. I also looked in the RunCommand...

Lesson learned. They say the lessons learned the hard way are the ones you remember most often. Thanks again !!!!

Thanks SO MUCH everyone, i finally got it to work! I took both your advise and had to add more brackets in order for it to work Here is what worked =DLookUp("[Name]","[FMLA_Yearly List]","[FMLA_ID] = " & [Forms]![FMLA Log]![FMLA_ID]) Which is what i had in 2003 but with the criteria area...