Recent content by leo57

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

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

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