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

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

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

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

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

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

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

I have been running a query for months now without any problems. Now all of a sudden it doesn't work. The query is an INSERT INTO and converts a string into a Double number CDbl(Mid([Table1].[Field1],6,12)) AS Amount The Field in the Table that it appends to is Double Number type. As I...

I have been running a query for months now without any problems. Now all of a sudden it doesn't work. The query is an INSERT INTO and converts a string into a Double number CDbl(Mid([Table1].[Field1],6,12)) AS Amount The Field in the Table that it appends to is Double Number type. As I...

I remember seeing once a simple method which could change the way the records in a form were sorted, but I can't find it again. The present alternatives I have are to assign different SQL to the Me.RecordSource property, but that can get messy when I use other SQL assignments. I've also looked...

I'm trying to write a quick app which will browse through a folder, find the word document files and apply a standard password to each file. I've exhausted my searches on Word VBA but can't get the password to stick. This is what I have so far: Dim iword As New Word.Application, idoc as...

Hi all, I've produced a simple reporting application based on date specific data. To improve daily querying speeds I've created two versions of each table (Daily, and Archived). There are 4 tables in total. The main report has code in the Report_Open event to determine whether it's record...

Essentially I'd like to be able to group a set of records on a continuous form in the same way that a Report Sorts and Groups them. Unfortunately I've not discovered any feature to do this in Access 97. eg. I have a load of records sorted by date, but I'd like to put a dividing line between...

I'm using this SQL as the Row Source for a combobox in a form to select a Product, dependant on a report date, for a query parameter. But I can't tell if it's doing what I want. SELECT DISTINCT PRODUCT, NAME FROM UNPAID_PRODS UNION SELECT DISTINCT PRODUCT, NAME FROM ARCHIVE_PRODS WHERE...

I've got a main form with 6 subforms, all based on a combobox value in the main form. They all work properly at first. The Tables I am using get pretty big, so I decided to use an archive table to remove older data and thus speed up the querying time. However, when I want to look at the older...

I have a form, which contains 5 subforms. The Parent-Child is based on a product code. Each subform also has a date criteria. The volumes of data can get pretty large so, to speed the querying up, I decided to split this into a current data (1 weeks worth of data) and an Archive (everything...