Search results

Clepto, Also, maybe from a FORMs code you could open the module collection and Retrieve the text and put in a table or text file. Wayne

Clapton, On IPAD so briefly ... Make a copy of your DB. Create a new Blank DB. One by one import modules into the blank DB. When it errors, import THAT module into another DB, then you can look at that Module. It should NOT have the SAME name as any of the routines ... And there Should be no...

It doesn't make sense that the SQL server user defines the performance ... Unless they're using the Resource Governor and giving The systems folks a Larger piece of the pie. Wayne

Rx, Oops ... After rereading I see that you saw that option. In ORACLE there is not choice. You must recreate the table(s). Is SSMS, I tend to let the software do it. It will drop/refresh all of the constraints etc. Much easier for me to let it do all the work. Wayne

Rx, In Management Studio, look for: Tools > Options > Table and Database Designers Uncheck the option "Prevent saving changes that require table re-creation" Management studio will do all of this "behind the scenes". Agree with the above points about learning, but it does save some time to...

a, Hope this helps: https://msdn.microsoft.com/en-us/library/ms678200(v=vs.85).aspx Wayne

Joe, There is a Command timeout; that's not your problem. The Connection timeout is a property of YOUR ODBC connection and also is set By the Server. You may have to ask your DBA for a longer setting. Wayne

I think you want the Charindex and SubString functions. Wayne

Novice1, Rs.edit Rs!remarks = "..." Rs.update Wayne

Billy, You need a space before the FROM. Wayne

Connectionstrings.com

Atrium, The query APClientTasksToProcessQry probably doesn't have a column named ClientID. Wayne

Madman, Ranman is right. When you link the table there's a very inconspicuous opportunity to check the "Remember password". Delete the link and try again. Wayne

Colin hijacked his own thread ???

Rev, You can link to the Oracle table User_Col_Comments. Then read this table with a DAO record set. For some of the columns you can TRY using the link to Allen Browne's software And updating the Tabledef for the appropriate linked table. You can't design linked tables, BUT you might be able...

Rev, The linked table won't have your comments. Link to the table User_Col_Comments. It'll have the comments. Hath, Wayne

Hascons, Glad to hear it works well. You have to be very wary of using recordsets. btw, I think you should look very carefully about your usage of the FIRST and LAST functions. I don't think that they do what you are expecting. In my mind, you need a subsequent query to get the opening and...

Hascons, This is a rough idea. The first query breaks your data into partitions AND gets the Opening/Closing date (for your next query). Select Stock, Your Stock ID BarDate, Just the Date part of BarDate Partition(MinutesSinceMidnight, You calculate this value with...

Hascons, This is from an IPhone so I'll be brief. Have a look at the Partition function. If you Partition your day then you Can Group by and get the Min/Max prices for each partition. you can also Min/max the time of each partition so that your NEXT query can get the Tougher Opening/Closing...

TyFer, Here's a link: http://www.fmsinc.com/microsoftaccess/forms/synchronize/linkedsubforms.asp Remember to disable the fields you don't want entered. Wayne