Search results for query: *

Hi all, Interested in gauging members thoughts on Access VBA and Functions? Best practice to be stored in Modules or behind Forms? They will work when placed behind the latter, but cant help thinking it's bad practice.

I think the post below is probably better suited to this forum: Any of the good members of the Tek-Tips community, have any knowledge or opinions, on the best source control app, to harbour Classic ASP files? Also, discussing deployment strategies, what are peoples thoughts on re-deploying...

Any of the good members of the Tek-Tips community, have any knowledge or opinions, on the best source control app, to harbour Classic ASP files? Also, discussing deployment strategies, what are peoples thoughts on re-deploying the whole app (all files), when an update is made to just one file?

Hi, I have a .Net app, written in VS2008 that connects to a SQL 2005 back end, on Win 7. Everything works fine on XP. However, on Win 7, unless the user is in an Admin AD Group, the connection fails with the error message: The server was not found or was not accessible. Verify that the...

Hi, I have a query with 3 tables in it. It contains numerous fields, mainly from Table1, with a sprinkling from Table2 and Table3. The query returns 5 records. The records are all the same apart from the Date field, which contains different values for each of the records. The Date field is...

Hi, I have a datatable dt. Within this datatable are numerous fields including 'Name' and 'ID'. Neither fields are unique. I want to bind this datatable to my dropdownlist ddlExample, only displaying unique 'Name' values. I want the 'ID' field to be the value of the drop down list. Can...

Hi all, We've upsized a load of XP databases to 2010 recently, and have found that they are far from stable eg. data corruption, Form corruption. However, once we remove the reference: Microsoft Office 14.0 Access database engine object library and replace it with the older file: Microsoft...

We've been having a debate, which I'm wondering if anyone else has any views on. The crux of the argument is this: Whether ot not the implementation of pseudo stack trace code (similar to that used in dot.net) into the VBA modules of library code, thus providing greater visibility as to what...

I have an XP Access app that I've just upsized into 2010. The toolbars and right-click menus, are causing me grief. I've used XML so as to remove the 'Home' tab. I've also set it so that it retains and renames the 'Add-Ins' tab. I've also disabled access to the 'Access Options' area from the...

Hi, The code below works fine: USE [database] GO DECLARE @Environment AS VARCHAR(40) DECLARE @Error AS VARCHAR (40) DECLARE @FileName AS VARCHAR(300) DECLARE @SQLSTRING AS VARCHAR (max) SET @Error = 'ERROR : Server instance not recognised' SET @Environment = CASE @@SERVERNAME WHEN...

I have a SQL View that joins two tables on 4 fields. Three of the 4 fields, in both tables, are populated. The fourth isnt. They contain NULL values instead. I only want to return records that DONT exist in both tables. The problem is that the view doesn't recognise the NULL values as...

Hi, I have a View that links 2 tables on Field A in table 1 and field B in table 2. They are the same datatype. I want to return records where they DONT equal each other. This works fine when comparing actual data, however if NULL exists in one field, then this record isnt returned as an...

Does anyone know why my view is completely ignoring my ORDER clause? To make it more confusing, when I have it open in DESIGN view and execute it, it works fine. When I open it, without first viewing it in design view, the results are unordered. Crazy!! The SQL is below: SELECT TOP...

Hi Hank, Did you ever get any joy with this? I have an identical issue. thread702-1486450

I posted this thread in another forum but not getting much feedback. Maybe this is a better home.... thread705-1580063 TIA.

Not sure if this is the right forum but I'll give it a try: I have an unbound subform, the ADODB recordset of which, is set to a stored proc on SQL Server. It works fine ordinarily; if however i just leave it sitting open on my screen for a short time, I get a host of "Data provider could not...

Hi, Is it possible to wrap text in an unbound textbox? I'm using AXP. Also, I cant see the Multiline property that has been mentioned in previous posts in here. Cheers.

I'm trying to implement some simple error handling into my (simple) proc and have been advised to use the @@TRANCOUNT method. My code is as below: ALTER PROCEDURE [dbo].[spTestSystem1] @ErrorCode int OUTPUT AS BEGIN TRAN BEGIN TRY -- SET NOCOUNT ON added to prevent extra result sets...

I have an unbound form which contains an unbound subform, set to datasheet view. I click a button on the main form and it updates a record in the subform, depending on the position of the cursor. I want that update to be reflected immediately to the user. Currently it isnt. I have to freeze...

I wonder if someone might be able to clarify a difference of opinion we have: I have 3 sub procedures which use a recordset of the same name. For efficiency sakes, I believe it's better to declare this variable at module level. My colleague believes it should be declared 3 seperate times...