Advertisement

1 - 10 of 50 containing alltags:("3021") (0.001 seconds)
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...
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 "...
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 =...
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
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...
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...
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 ...
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_:-----------------------------------...
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...
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...
Zones: MS AccessDate Answered: 01/08/1998 Grade: A Views: 0