I want to delete duplicates.
I sorted my records by [co_num]
I go one by one with this code. If the next is equal to the last, it elminates the next. But I have over 100K + records. Access c...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20339825.html
Zones:
DatabasesDate Answered: 08/22/2002 Grade: A Views: 0
Have a form that I have city state and zip self populate as well as box id no. populating 3 different serial numbers in a string. Added error trap and now every time enter zip code get 3021 error "...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20408383.html
Zones:
MS AccessDate Answered: 12/02/2002 Grade: A Views: 0
Hello experts,
I have the following code;
For x = 1 To MSFlexGrid1.Cols - 1
Set rs2 = New ADODB.Recordset
strPlayID = "SELECT PlayerID FROM Players where PlayerName =...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21063718.html
Zones:
Visual BasicDate Answered: 07/20/2004 Grade: A Views: 0
My VB application run normally in Windows 2000 professional and server but cannot run in Windows XP.
There is a runtime error that always prompt out the error code 3021
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_21164695.html
Zones:
VB DBDate Answered: 01/10/2005 Grade: A Views: 0
im getting this error saying "either eof or bof is true, ro the current record has been deleted. requested operation requires a current record"
my code is as follows
Private Sub ComboBox1_Chan...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21355990.html
Zones:
Visual BasicDate Answered: 03/18/2005 Grade: A Views: 0
When the following code executes I get a Run-Time error "3021":
If the 'Control Number' on the current form does not exist on the "Main" table then I need the code to give a message and stop exe...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21448175.html
Zones:
MS AccessDate Answered: 06/06/2005 Grade: A Views: 0
I have created the fuction below......when I call this function from a Macro using RunCode I get the 3021 Error telling me no current record. The T-EmployeesGetEmailAddress has 2 fields Employees ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21627678.html
Zones:
MS AccessDate Answered: 11/11/2005 Grade: A Views: 0
I have the following code in which I trap an error number then want to pass it to a procedure - how do I do it?
Exit_:
lvErrNum = 0
Exit Sub
Err_:-----------------------------------...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21742407.html
Zones:
MS AccessDate Answered: 02/19/2006 Grade: A Views: 0
I have this simple code:
Dim rsNL As ADODB.Recordset
Dim dbc As DbConnection
Set rsNL = Nothing
Set dbc = New DbConnection
test = dbc.login(gsDBName, "", "")
If test = 0 The...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21945016.html
Zones:
Visual BasicDate Answered: 08/11/2006 Grade: B Views: 0
This is sort of a followup question to one that I posted about a month ago. I've written a function that populates an empty field in a table that is on the "many" side of a "one to many" relations...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10035024.html
Zones:
MS AccessDate Answered: 01/08/1998 Grade: A Views: 0