Search results for query: *

The users version of Excel does not have Common Dialog Box or anything I have on my development PC. issues at hand 1. not change the default "save-to" folder when they save other workbooks. 2. be able to save workbooks my VBA form creates into a specific "known" folder and then let the user...

I have data saved everynight like so There are 3 columns: date, category, money. Date1 Cat1 ExtCost1 Date2 Cat2 ExtCost2 2016-11-10 Base Material 36526.31 2016-11-11 Base Material 36522.12 2016-11-10 Encasing Parts 34523.33 2016-11-11 Encasing Parts 34345.32 I want to be able...

Company prints production tickets and then scans each Serial Number barcode into a software package. There are ~200 pages each day, so it takes time... I thought we could print them to a text file then I could grab out each Serial Number and save them to another file. however the word Serial...

This is a SQL Express install so there is no Agent listed, so I can't create a job. When I run the SQL script below either in the batch file or at sqlcmd prompt it just opens the .sql file in SSMS and does not run it. I want this to run unattended at night. What do I need to do to make this...

In the properties of "Edit columns" dialog in the "columnType" it allows the choosing of a ComboBox" and then I can choose an .xsd data source however... the "DisplayMember" and "ValueMember" properties are "NONE" and cannot be changed. So what's the magic potion for making this work?

this dose not work <iframe valign="center" src="images/woodscrew.jpg" name="content2" backcolor height="140" width="140"></iframe>

I tried adding a chr(34) but SQL does not like it. " Report1 = " chr(34) & Me.txtReport1.Text & chr(34) & ", " & _ 'here is my original SQL string SQLUpdateString = "Update Recognition Set CommonName = '" & Me.txtEmployeeName.Text & "', " & _ " EmployeeEPriseID = '" &...

background. I want to be able to hide or gray out a Select button for people that are Not employees. For employees the button should work and select them. I have a select button I added using GridView tasks, Edit columns, but did not know how to hide it or gray it or other wise. whihc aal works...

Both DataSource and DataSourceID are defined on 'GridView2'. Remove one definition. this grid was using a SQL datasource adn I removed it and am using a unbound sometimes it works fine then other times I get the above message. maybe someone can tell me what still left over to make this error...

I want to use a one liner to get the Managers name along with the employees name. the Managers ID is txtManagerEnterpriseID this T-SQL returns a NULL for Manager name right now. can someone help me figure this out? Select txtEnterpriseID,txtGivenname, txtSurname, txtCity...

do any of the newer versions allow this yet? I am using SSMS 2008R2 then the question is WHY not?

I am wondering if anyone has had this issue. I am creating complicated instruction manuals with hyperlink book marks image insert and so on and I will notice that the spell check quits working. I see typo’s that are not caught riddled throughout the document. This is also an issue in Outlook...

I have looked high and low even googled it and got nothing, what is going on with these upgrades. after how many version of this program since 1990 something. we don't have mailing addresses any more?

the column I am looking in is M I want to find both the letter"N" and blankc this code works to filter the items bbut changes the backgroud color of all the cells to yellow I tried to use this but it give object rrquired error ActiveSheet.Range("M1:M500").AutoFilter Field:=ColumnAwarded...

The issue is in a WEB page that one field take up the entire page and it makes the grid look ridculus and is unwieldy to work with. I have a grid view which shows all the records in a SQL table. It is using a SQLSDatasource So I have tried to put the Select statement to show...

The date in the SQL table is DateAwarded(date, null). I have and asp 4.0 page as follows. Can something be done in the Http: lines to make it a date and not a 5 digit number. I tried several ways converting the date to text and from text to date and nothing makes it an actual date when it gets...

This is a 3 program issue: first I have an ASP.NET app. which saves data to SQL and has an export screen to save to Excel. Is there anything I can do with this script to make the column be a date when exported using the .NET below. It shows as text looking like a date 5/12/13 or a 5 digit number...