Search results

This thread should point you in the right direction for adding multiple attachments: http://www.access-programmers.co.uk/forums/showthread.php?t=206121

Can anyone tell me if transaction success or fail can cascade up if using the same connection. Below I have some sample code. Sub1 creates an ADO connnection, executes some SQL against it and the parses the connection to Sub2. If there is an error in sub2 when executing the SQL, will both...

Okay.. So i've managed to get my head around this now. You need to use the ADO Extension library Firstly, add a reference to 'Microsoft ADO Ext. 2.x for DDL and Security' The following code will output all of the information of an index. Dim strTableName as string Dim objCat As...

Hi Guys Does anyone have an idea how to determine if a field within a table is a primary key or part of a compound key using ADO?

Just want an all emcompassing function that will handle data entry, so anything a user inputs. I'm actually using this in excel and I want to improve the validation.

Thanks guys Although I don't need it at the moment, I may have a look at adapting this to dealing with leading and trailing '+-' and '£$€' symbols.

Is there an alternative function to IsNumeric as its not reliable. Code below demonstrates this: For i = 65 To 90 Debug.Print Chr(i) & " " & IsNumeric("1" & Chr(i) & "3") Next

Ooops, School boy error there.. Okay, now I have some meaningful information.. It appears to be trying to connect to another db on the server and not the one I am specifying in the connection string. -2147467259 [Microsoft][SQL Native Client][SQL Server] The server principal "User" is not...

Sorry, I mean that the procedure will not execute when called by my VBA code above.. FYI, I have tested the procedure within SQL Management Studio and it works fine.

I am having problems executing stored procedures on SQL Server 2005 Express.. This approach has always worked for me in the past.. On the server i have done the following: 1. Created user 'TimesUser' on the server. 2. Created the role 'DB_Executor' on the database using the following code...

Hi Following on from my previous issue, I now have a new problem.. I have written an export routine to dump data from and access database to CSV. The app then automatically creates an excel file and pivot table thats connected to the output.. This now all works and is documented in this...

Hi I'm migrating a backend to SQL Server and a piece of my code is no longer working. The table structure is exactly the same, but it now fails when inserting a a new record to a recordset using .addnew Here is the code: Public Function GenerateBlankDates(ClientType As String, ClientID As...

Thanks for looking in to this noboffinme I have similar code to yours within my Access app.. I am trying to avoid creating an ODBC connection for each export.. I've now managed to get this working with help from a guy on the other forum.. Here is the solution...

Hi noboffinme I can't import the table source in to Excel as the number of records will typically exceed 65k and we are still using Excel 2003.. Once I come up with a solution I'll post on here..

Hi I have built an MS Access front end which can export filtered data to CSV's from a database. The users then want to pivot this data using Excel.. We are still using Office 2003 here, and typical export will be more than 65k rows.. I now want to automate the next step of creating a new...

Thanks a lot for the responses guys.. I am in the process of normalizing the database atm.. However, I wonder if normalizing and then linking from the main table on to the lookup would be slower? This is a reporting database, with no data entry required.. Currently the 5M db is around 900Mb...

I've recently joined a new company and this is my first time working with what I would call Big Data.. We are running Access 2003. I have been tasked trying to speed up the reporting on a monthly extract that comes from our data warehouse team.. Currently, we append flat file data to our MS...

Genius !! Thanks for that..

I have developed a form for an ad-hoc piece of work.. I am capturing around 150 fields for a record, So I am forced to use a tab control for certain parts.. My tab control sits quite a way down the form, so the user needs to scroll down to view them.. The issue is, when clicking from one tab...

I've now posted this on dbformums.. http://www.dbforums.com/microsoft-access/1681082-writing-sql-server-using-existing-dao-code.html#post6556802 Please respond there if possible..