Search results

I'm quite confused by this.. I am testing if a sql recordset contains records.. normal stuff.. The WHERE statement is based on input parameters and will insert either 'LIKE' or 'NOT LIKE' condition on the 'Role' field... When copying the built SQL into a query and running, both return a...

I have a User Defined Type which stores an array.. I have 2 instances of this UDT, one storing matched data, the other storing exception data I was to parse these arrays to an Excel output routine. However, the parameter variable contains no data when accessing it.. Here is my code: UDT...

In my dataset which lists configurations, some records contain up to 6000 character configuration strings in a Memo field (named 'PermissionString'). The Memo string is hashed and saved to another field for joining to other tables. The configurations are displayed on a continuous form with all...

I work as a developer for a large corporate co.. We have moved to a Citrix environment, so the users run a standard build, everyone running Windows 7 64 bit.. The infrastructure team are looking to roll out either Office 2010 or 2013.. I'm yet to find out if this will be 32 or 64 bit.. I...

How would i go about doing this? I've done some basic work with arrays.. writing array data to form list objects.. I have no idea how to use an array as a data source for a report? Would i need to create a recordset and populate it with the array, then bind the report to it ? Anyone got...

I'm really confused with this.. I have two queries, both delete from the same table and both have joins... This one works: DELETE RequestCheck.* FROM( SELECT TOP 3 PayRequest.RequestID, PayRequest.GBPAmount, PayRequest.Currency, PayRequest.RequestDate FROM PayRequest WHERE...

Hi Guys I'm a bit confused by this.. My statement below is current returning 4 records. Two of the records have the same GBPAmount value. RequestID is the Primary Key SELECT TOP 3 RequestID, GBPAmount, Currency, RequestDate FROM PayRequest WHERE (((Currency)="CAD Canadian Dollar") AND...

I am building a new project which has some core tables.. The key tables are: Countries CountryID CountryName Businesses BusinessID BusinessName CountryID Clients ClientID ClientName BusinessID CountryID I want to enforce the rule that a Business can only have clients within the same...

I've always setup Front Ends and Back Ends so that a copy of the Front End is distributed to each Desktop. I've now joined a new company (been here 6 months now) and the way things are done here is that one copy of the FE sits on a share and users open it from that location. This file contains...

Does anyone know how I can create an MDE with all options disabled including shift key bypass. I want to remove all options in Tools>Startup except for the status bar. I have tried using this code but am not getting anywhere with it CurrentDb.Properties("AllowByPassKey") = 0

Hi Guys I'm trying to use DDL to add a DATE field as above with NOW() as the default value.. I am using the same syntax pretty much (Altering instead of Creating a table), but its not working.. The error I get is: err.number = 3293 err.description = Syntax error in ALTER TABLE statement...

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

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?

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

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

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

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

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