Search results for query: *

Ok I found this >>> http://access.mvps.org/access/api/api0001.htm which does the same thing however it does not save anything Sorry the one you have is not very user friendly either... I prefer the one in the attached image so how do I make it save something...

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...

Dooh, sorry I see I put the i1 [i1.DateAdded] in the wrong place it should be i1.[DateAdded]. my bad SELECT --[RMI_ID] CAST(i1.[DateAdded] as Date) As Date1, i1.[Category] as Cat1, i1.[Extended Cost] as ExtCost1, CAST(i2.[DateAdded] as Date) as Date2, i2.[Category] as Cat2...

Thanks, luckily the serial numbers all end in "00" so I looked for 02000 and then 00 to find what I needed.

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...

..."Ser") SerialNumber = Trim(Mid(Linedata, FindSerialNumberStart, 16)) w.WriteLine("*" & SerialNumber & "*") w.WriteLine(SerialNumber) End If End if...

I got one step closer I was not picking the correct item for the datasource. However I still get an error. I thin it has to do with the column being nvarchar(2) and the data I am trying to look up is 255. I changed that in SQL but I need to refresh the datasource or delete it and start over???

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>

Well jbenson001 , I ended up doing this. but it took a lot, alotta extra code, adding code manully sort for one and so on.

I figured it out. I made the default Select button in the grid a Template field. This then gave it a name which could be found using the "findControl" method, And this is how the GridView3_RowCommand makes it invisible. and since it was a default Select button it had the code to make it selectable.

I ended up doing this. Dim Location As String = Replace(Me.txtLocation.Text, "'", "''")

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 = '" &...

addendum to above I can name give a TemplateField an ID but not a CommandField ? <asp:CommandField ButtonType="Button" ShowCancelButton="False" ShowSelectButton="True" ID="BtnSelect2"/> <!-- Error: ID is not a valid field for CommandField -->...

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...

Ok I fixed it I added this VB code [highlight #FCE94F]If GridView2.DataSourceID <> "" Then GridView2.DataSourceID = "" End If[/highlight] GridView2.DataSource = PopulateGridwithSQL(SQLString) GridView2.DataBind() then I had to change the SQL to fill the Grid so it did not...

Also it is only in the dev environment, whats on the server now runs fine. I went back and forth many times while it was running on the server and it does not error, just Errors on my Win 7 dev box? So I am concerned if I upload it, it will break the site :(

Addendum: I noticed it happens when I come from another page to this page. I the other page used a GridView2 as well and changed it to Gridview8 but this did not work either. I changed the page in error to Gridview8 but get a Object not reference when coming back and forth. If I added this it...

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...