Search results for query: *

When ever I format Cells.Select Cells.EntireColumn.AutoFit using a Macro in Excel 2003, Excel crashes when I save the file. The only error message is Micrsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. Has anyone else run into this and...

When ever I format using a Macro in Excel 2003, Excel crashes when I save the file. Has anyone else run into this and no of a work around. I am glad I don't know it all because then I would be bored. -Obie

I am doing some work with my database on a web page using VB. I want o grab just the value of one column from a row I have the key for. In access and VBA I would use the dlookup function. How do I do this in SQL server. I am glad I don't know it all because then I would be bored. -Obie

I am using Crystal 11 I have a table with Means and Stddev. I want a chart that Plots each mean and then adds bars up and down for the StdDev. so each point would lool like _ | * | - Any thoughts? I am glad I don't know it all because then I would be bored. -Obie

I am building a large project on a SQL Server backend, and am not sure what the best tools for front end development are. Although a developer with experience in a multitude of languages myself, I am in position to hire people to help with what ever skills I need so my personal knowledge is not...

I have a field where I have checked can grow above another field in the data section. How do I ensure that if the top field does grow the other field moves down? I am glad I don't know it all because then I would be bored. http://goallineblitz.com/game/signup.pl?ref=9436220 -Obie

I have an excel spread sheet that is changed weekly. I need to get this data into SQL or Crystal to generate a report. I am new to SQL and am actually using SQL Server Management Studio Express. When I lived in the tiny world of Access I could simply create a link to the Excel Spread sheet...

I am brand new to SQL server and am getting the following error textMsg 4104, Level 16, State 1, Line 1 The multi-part identifier "dbo.XDS_Shift.userid" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "XDS_Location.userID" could not be bound. Msg 4104, Level...

Every time I give a project I ahve worked on to an end user they are attacked by warnings about how the databse may harm ther computer. I have created a signature but this doesn't seem to help. Does anyone know where they hid the setting so I can stop these warnings.

The column count in my crosstab can grow and shrink. I want to makes sure that it remains centerd verticaly on the page. How can i do this?

I have a bar graph that is showing the same data as a cross tab. I want to format the rows in the cross tab to be the same as the colors in the bar graph. How can I make this happen?

I have created a combo box I wish to limit to list. If the user adds a value that is not in the list I am using NotInList Property to give the user the choice of adding the item or leaving the field blank. Private Sub SupplyID_NotInList(NewData As String, Response As Integer) On...

I am calling a boolean function. When it returns False I want it to be treated as an error by my code. boolvariable = Builtinboolean function if boolvariable is False then ActionOne ActionTwo ActionThree Treat As Error End if I can move the actions to my error trapping...

I have been reading many posts on the value of splitting my DBs. Once I do this do I give each user a copy of the front end or do all users access the same front end on the network drive? If they do get there own copy what is the prefered way of distributing it? Thank You for all your help...

I need to get the name of the file that has been most recentely saved into a folder. Twice a day a file is added to a folder. It always have the same naming convention and all the files in the folder have the same convention. NameDate_Date_Time I am trying to automate a process that...

I have a right justified numer colmun next to a left justified text columun that is mostly numbers in a subfrom. How can I format the columns differently so that I can give the users a visual break. As of now I have created a null colmun called gap in the query the form is based on. I want...

I have a combo box in a form. Before I change it I need to adjust records in various tables based on the value. Then I need to use the new value to update the sub forms. The only way I have found to use the existing value is the On Get Focus property. This cause the user to have to wait for...