Search results

I found a solution by using a free image converter software program. I convert the pictures to bitmap and then put them in the database. The images no longer import with a large white border, when I shrink the size of the photo.

I will move my code to the before update event. Was there a problem in the code?

The following code does not work. I am using Access 2007 Fe to SQL Server 2005 backend. What am I doing wrong? The message boxes don't work and it allows quantities to be entered greater than the quantiy on hand. Private Sub Qty_AfterUpdate() If Me.Qty >...

I have a SQL Server 2005 backend to an Access 2007 front end (ODBC). When I add an image, the border from the picture is inserted also. How do I remove the border from the picture? I usually compress the pictures to web small in Microsoft Picture Manager but I can't fiquire out how to remove the...

Company Policy, Thanks

Sorry it took so long to reply. I'm in and out all day. Yes that is what I need to do.

No, the Sql Authenication requires the password to change every 30 days. Everything was working fine until I had to change my password. There isn't a place to submit a new password when I login. I don't want to call the DBA every 30 days. I know that we will change to windows authenication in...

I have Access 2007 to SQL Server 2005 setup. I do not control security. I need to change a password through access to SQL Server 2005. I use SQL Server ODBC. The user name and password is all the comes up when opening DB. The error message says I need to change the password but there is no...