Recent content by Shallo9

Sorting List Box in MS Access VBA Appears good but I was looking for sorting a List Box which is populated not from a query but Value List (To make it even worst this Value List is populated from a web page [Out of Scope] lets stick to Value List) Below are the two UDF's I've coded which uses...

Hello All, I've got a Split Database (Front End & Back End). So far it was all good until recent when a department placed in a different city (200 Miles apart) wants to use my application. The Application has gone very slow for them when they access the back end. Could some one help me in...

Can you not use a Make table Query to accomplish this task and trigger this query every month (or as and when needed).

Okay I'll make it more clear. Every time a user starts my Access Application from either Start Menu/Desktop Icon, A folder (For Ex: C:\Documents and Settings\USERID\Application Data\Database)is created within the users %Application Data%. Now this folder "Database" cannot be deleted until the...

Hello All, I've written a small VBScript to delete a folder from %Application Data% which is created by my MS Access Application every time the user logs in, so that they don't get a Profile Storage exceeded error. All is well so far. However, I want this VBScript to run automatically, the...

I think you've completely missed my point. From my query above I get All the records which satisfies my criteria. However the next step is, I need Only 1 record per Activity and where there are more than one records for a given activity I'd sort them by Contact ID and pick the record with the...

Yes they are lookup values. Basically every Activity has Many ContactID. I've sorted the result of the query so that I can keep the first contact and delete the rest.

Please find attached

SELECT tblActivityContact.ActivityID, tblActivityContact.activityContactID, tblActivityContact.contactTypeID, tblActivityContact.contactReasonTypeID FROM tblActivityContact WHERE (((tblActivityContact.contactTypeID) In (1,4,5)) AND ((tblActivityContact.contactReasonTypeID) In (19,25,26,27)))...

Already tried with no success. I've got a PK & a FK in this query result and want to remove the duplicate records based on the FK.

Hello All, I have a query which returns a vast number of records. Now I want to delete any duplicate record (Leaving the first instance). I can manually copy this resultant data to excel and delete the duplicates easily by using the Remove Duplicates Option. I want this functionality to be...

MS Access 2007 & 2010

Hello All, I am trying to migrate most of my database backends to SQL Server. I need help from experts on how to proceed. Is there a tutorial for a starter and what version shall I install to start with? Having said this, I am searching over net for this. If anybody can send me few links to...

Thank you ever so much for the help. Out of curiosity I am wondering if there is any other way of accomplishing this with much simpler method. Basically my query is I want to select a particular row from a table and append it to the same table. However, with a brand new primary key which...

Syntax error in INSERT INTO statement. (Error 3134) Insert into tbl_A( CustomerID, PolicyID, quoteTypeID, blnSmoker, OccupationClassID, strOccupationTitle, curAnnualEarnings, AgentID, RateID, dblDiscount, dblLoadingAmount, blnTopUp, dtmEffDate, dtmCommencementDate, lstPaymentFrequency...