Recent content by RemyS

Hello In Excel I linked External data to a query in an .accdb back-end However whenever I open the Excel workbook first, I can then only open the access db as Read-only. Is there any way to change this behavior so that the Excel workbook does not "steal" the exclusivity? NOTE: I somehow used...

Hi Robert, You code was just the answer I was looking for, well almost... I tweaked it a bit to replace a character rather than delete it (replacing it with an empty string would do the same) Thanks. Remy Public Function ReplaceEmbedded(CharsToRemove As String, CharsToReplace As String...

Thanks, but somehow I don't think a DSN-less connection will work with an Excel97 Pivottable (they're not all that easy to re-connect in code). I did manage to get a workaround though: I removed the ODBC connection (created in the code above) I then refreshed the pivottables in Excel...

[bugeyed]Believe me, I've tried! I'm working with a SQL Server 7 backend and an Access 97 frontend ... and an Excel 97 frontend too. I was able to register the DSN without UID and PWD, and Access worked fine, but it seems Excel needs the UID & PWD to connect. This is what I've got that works...

You mentioned that you were trying to produce a Report. In design view: First apply a Grouping to the report based on your record type: Goto View > Sorting and Grouping Then Add you record type field to the list, and select Yes for the Group Footer (or header if you want the count at the top...

I am importing a Fixed Field .txt file into a SQL table. One of the fields is 12 characters long begining with 2 alpha characters; 'AB1234567890' However sometimes this can be 9 characters long of only numeric, preceded by blank spaces; ' 123456789' This field is transfered to a field...

I initially wrote the parameters as you suggested, but I believe the Error message is prompting for the Stored Procedure parameter, which must be declared with the '@'. For some reason the second Set Param# is not being appended. Remy Hundreds of ways to do things with PC's, and learning...

I am trying to run a stored Procedure from an ActiveX task in a SQL Server 7.0 DTS Package. The script seams to compile correctly when I test in VB, but when I run it the following error occures: ActiveX encountered a Run Time Error during the execution of the Script. Procedure 'my_sp' expects...

cwbviper, I'd be interested in knowing what the actual problem was and how you remedied it? I've been having the same problem with a split DB over a large network. I believe, in my case, the delay and eventual hang is due to the traffic overload over the network, but I'd be interested to know...

That would make life easier, but the username for the SQL Database is a "dummy" single username which anyone can loggin as, and is therefore different to my NT username, which is what the Windows Authentication uses. Hundreds of ways to do things with VB, and learning new ways every day.

Hi All, I'm new to working with SQL server, and have been having a bit of trouble creating my Pass through query in Access 97. I've set up the database as an ODBC System DSN and have successfully been able to open the tables. However when I create a normal SELECT query to the table I have to...

I'm building an app for someone who wants to use Excel as the front end, but the volume of data they are using would be much better handled by an Access database. I have set one up as an ODBC Data source, and used Excel's External Data feature to import the data. However... They'd like to be...

I'm trying to capture a part of a text field depending on where the first alpha character appears in it. i.e. Ref = "5923587MAN2", Ref = "98062 006125879A02" So I want the 7 numeric characters which appear before the first letter. I've been trying things along these...

Hi Machiko It looks like you're trying this in VBScript. I'm sorry I don't yet know enough about that to help, but I would recommend you start a new thread in this forum, and in the ASP forum. Good luck Hundreds of ways to do things with VB, and learning new ways every day.

I just wanted to know if it is possible to format text within a message box (i.e. Bold, colour, size) I have seen Access Messages with Bold text before, which prompted my curiosity. Otherwise I see the only alternative is another form, in which case; Where can I find the graphics for...