Search results for query: *

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

So essentially I should learn ASP first, and how to use it with my SQL server and Web Server, and then migrate my data storage to XML format. That's obviously the bit I would have learned had I read further about XML. It's going to take a while before I understand exactly the advantages of XML...

Hi All, I'm new to development for web apps and was wondering if some of you could help me clear up some confusion I have. I'm a bit hazy on what the differences are between XML and ASP??? I've read up a bit about XML and understand it as a data storage format, but I haven't gotten as far as...

Hi All, I'm new to development for web apps and was wondering if some of you could help me clear up some confusion I have. I'm a bit hazy on what the differences are between XML and ASP??? I've read up a bit about XML and understand it as a data storage format, but I haven't gotten as far as...

Indeed my data is preceeded with spaces;' 45,000.00' though these spaces were never an issue before. I have tried inserting a Trim() function to remove any spaces so that the expression would look like: Sum(CDbl(Trim(Mid([IMPORT_TABLE].[Field1],6,12)))) but this still returned the Data...

I have an INSERT INTO Query which is based on a string only import table; SELECT Sum(CDbl(Mid([IMPORT_TABLE].[Field1],6,12))) AS Amount Without the Totals I am able to verify that the string is being successfully converted into a Double type Number, but when I try to add the Totals and select...