Search results

You need to re-write them all one-by-one.

This is pretty cool. I am sure I can find ways to integrate this into my work. :D

Wayne, I didn't know that about forms. Is that recovered with a decompile?

Do you have to create them at run time? Why not just have them on the form already with the Visible property set to No and then make them Visible as you need them? I have never created controls at run time so I can't directly answer your question. I always do what I suggested above and then...

If you know how to use Fill and understand Absolute vs Relative Referencing, this should take you about 5 minutes to do the whole year. You have to have actual dates in the heading to give Conditional Formatting something to compare to.

What do you get if you try my values? 4 5 5 8 8 5 The original poster would like 5 returned.

Try Ye Old Array formula: Column A 4 5 5 8 8 5 5 =MAX(IF(A1:A6 <> MAX(A1:A6),A1:A6,"")) After pasting this in, be sure to do the Ctrl-Shift-Enter to get the Array Formula. It should then look like: {=MAX(IF(A1:A6 <> MAX(A1:A6),A1:A6,""))} Otherwise you will get the #VALUE

This has been covered many times, so if you don't understand my answer, do some searches. Have the criteria point to the control on the form: =forms!formname!textboxname

Hmmm ... sounds like a job for DTS or SSIS, depending on whether you want to push/pull the data from/to SS2000 to/from SS2005 (DTS) or SSIS to do the reverse.

Declare @tr Int Set @tr = 4 Select Replicate('0',4-LEN(@tr)) + CONVERT(VARCHAR,@tr)

I am interpreting your question in a couple ways. Perhaps you can clarify. What are the results you are expecting? How is the test file recognized by Access? 1) When you say char stream, I see this as a file with or without linefeeds or carriage returns. Something that would come in off of...

Do this in your report. Have an unbound control that you update with an incremented counter. Increment that counter in the DetailFormat event: Option Compare Database Option Explicit Dim i As Long Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If FormatCount = 1 Then i...

Well, since you're in the SQL Server Forum, I will give you the SQL Server answer. This should be run totally on SQL Server, not with VBA. Since you are using a SP, I can assume that the tables you are processing are also SQL Server tables, and your tTableNames table is also a SQL Table...

It is a valid format. Continue to read the article you posted. These default settings can be different and altered. Not all dates may be entered in that format. Think of some web based science fiction game set in a different time period or perhaps where the character can time travel. SQL...

It would depend on the regional settings. The way I have it will work on any system regardless of the settings.

You can also try this in your SELECT statement: SELECT CUH.CULevel, CUH.AREA, SUM(Iif(TYPES.Asset = "T30",1,0)) As T30Counts, SUM(Iif(TYPES.Asset = "DESKTOP",1,0)) As DesktopCounts

SELECT COUNT(*) FROM MyTable WHERE MyMonth <> MONTH(Date())

Did my suggestion in your previous post not work? Should have ... I do it all the time. BTW, you cannot Delete data in Views. They are just what they say they are, views into your (usually) tables.

Do you have the References added that I mentioned earlier?

Ah, tell me your role in your company. If your are not the DBA or a Network Admin, then I would leave it alone or go through those channels as these are the logs for any and all ODBC connections, not just SQL ODBC calls. These are reviewed and someone might get upset if they are in another...