Search results

Patchy, Try: SELECT [Employee #], ConcatRelated("[Courses]", "[Courses tbl]", "[Employee #] =" & [Employee #]), ConcatRelated("[Start Date]", "[Courses tbl]", "[Employee #] =" & [Employee #]), ConcatRelated("[Completion Date]", "[Courses tbl]", "[Employee #]...

vq, You can create a function that will return the FIRST Sunday that is earlier than "this date in the last month". Rough attempt: Create Function fnGetStartDate(@SourceDate as DateTime) Returns DateTime As Begin Declare @TheYear As Int Declare @TheMonth As Int Declare @TheDay As Int...

jom, What jumps out at me ... Public Function DateAddW(ByVal TheDate, ByVal Interval) As Date Wayne

graham, I've dealt with the non-breaking space in SQL Server; it is an ASCII 160. I think your "hyphen" is an ASCII 151. To see its position in SQL Server: Select YourField, CharIndex(Char(151), YourField) From YourTable Where CharIndex(Char(151), YourField) > 0 To see its position in...

gbil, Try: lngNextNum = Nz(DMax("[nMembNum]", "tblMembers"), 0) + 1 DMax can return a Null, which can't be assigned to lngNextNum. Wayne

Sands, Here's a link to an old thread here; its as good a place to start as any: http://www.access-programmers.co.uk/forums/showthread.php?t=51083&highlight=recursive hth, Wayne

Cutty, You don't show the SQL for filling the recordset. My guess would be that there is no "Order By" clause. Try explicitly sorting by name. Wayne

r, Change the reference for idNowego to: Forms!NameOfFormYouKnowIsOpen!idNowego Wayne

Try removing the semi-colon at the end of the Print statement. It might be waiting for a carriage-return to read the sequence. Just a thought, Wayne

Thanks Paul, Too much on the Server side for me. Wayne

J, The "And" is causing you trouble: >=#Sun Jan 01 2012# And <Date()+30 Change to: Between CDate("1/1/2012") And Date() + 30 Or Between CDate("1/1/2012") And DateAdd("d", Date(), 30) Wayne

Rx, Does this help? http://www.connectionstrings.com/sql-server-2012#sql-server-native-client-11-0-odbc-driver Wayne

Latex, On the surface: Open "LP:" For Output As #1 Print #1, Chr(27) & Chr(112) & Chr(32) & Chr(25); Close #1 Drop the ";" at the end if you don't want a carriage-return. This assumes your printer is connected to "LP:". Wayne

j, You're never assigning a value to the function. It just looks like its doing nothing. ab1 = "Some value you calculate" Wayne

serus, SELECT * Into [EmployeesCopy] FROM Employees WHERE [ID] Mod 3 = 0; Wayne

m, You probably don't want the combo's OnChange event. It should probably be the Before Or After Update event. hth, Wayne

m, When you set up the new DSN did you make sure to check the "Default Database" on the third panel? It sounds like the user's are defaulting to the old database location in the absence of a specification. Try reconfiguring the DSN. Wayne

Shamas, Try: SELECT 'Tab-->' & Chr(9) & '<--Tab' But, remember that Access doesn't do a very good job of "displaying" special characters. Access will put them in there, but not display them ... some tools won't even put the special characters in the output. Try pasting the query output into...

Dick, As crazy as it seems: Me.txtDateComp.Text Is only valid in the OnChange event. Use the .Value or nothing. hth, Wayne

Michael, How about: Coalesce([p].[stocktypeid], 1) <> 1 Coalesce([jim].[stktyp], '0') <> 'O' Wayne