Search results for query: *

Thank you all for your assistance. I was not understanding that although I created the text file from a 1-dimensional array it would require a 2-dimensional array to retrieve that same data. That was all it took. Your help is greatly appreciated. Excellerant

Thank you all. Unfortuantly my internet was down again yesterday so I could not try this. sethmcdoogle, I am not sure why you suggest a 2-dimensional array though. I am bringing a list of six Currency names. The intention was to bring in the list of names from a text file, assign them to an...

Below is the code I have been using. The puts command does display the right information. When I try to copy that information into my array it occupies into all parts of the array not just the current index position. As the while loop continues it then writes over most of the data in each. Not...

p27br, Unfortunatly no. At least not using the CarryOver(me) code. I have setup the other code that was recommended on new forms using the "CarryForward" tag on each field. That has worked on everything I have added it too so far, with the exception of Access not liking one piece of the error...

Thankyou peini and Dougp, this is exactly the question I was looking for. I thought I tried Dougs method without success earlier but now it seems to be working. Here is the code I used. It sure is nice that ApplyFilter will prompt the user for me. DoCmd.ApplyFilter , "[date number] = [What...

All, I have been in contact with the originator of the code, Allen Browne [allen@allenbrowne.com]. He offers the following information, although I have yet to resolve the issue on my end. "There was a problem with Access 97 not closing that traced to two different bugs in Access: 1. If code...

p27br, Thanks for the information, I just emailed the original creator for his input. If he has an answer I will post it here as well. Excellerant

MichaelRed, Below is the only other code this form uses. I did not see any other objects being opened. Thanks for helping, Excellerant Private Sub Form_Current() If Results = "facechip" Then DefectsFrame = 1 DefectNumber = 1 "2-13 ommitted here" ElseIf Results = "Too...

p27br, Do you know where this code came from originally? Someone else installed this here and they are no longer with us. If we knew were it came from maybe we can track it to someone who has already found the solution. Excellerant

CajunCenturion, I don't think I answered all your questions. At the time this code was added, I was not involved in using this form. I am not sure if anything else was added at the same time or not. There is some other code within the form, but if I remove the call CarryOver(me) from the...

MichaelRed, Not sure what other objects you are referring too, rst is set to nothing and we added set ctl to nothing. These did not help. Excellerant

CajunCenturion, I added the code as you supplied but I am getting a Compile error: Method or data member not found. I am running Access 2000 and I see the code you are using in the help file. Not sure why I am getting the compile error. Something I just remembered, if this makes a difference...

CajunCenturion, What I posted is the entire module. The CarryOver procedure is a module by itself called basCarryOver. The procedure is called from the BeforeInsert event procedure of each form that uses it. If I understand it right, this is a public sub. Not sure what you mean by "standard...

MichaelRed, I have run the module through step-by-step and it never did go to the case else error but the "resume_ExitCarryOver" does close the rst. The form does actually close. I can also close the file but Access itself stays open. As far as I can tell there are no objects left open. I hope...

CajunCenturion, Thanks for the reply. I rarely get the msgbox that results from the Case Else error handler. When I do, it does not work right but that usually only occurs in a new table with no records. Could this be causing a problem even if the error is not present? I also tried it without...

The previous owner of a database here added the "carryover" function to a form I now use on a daily basis. I have also added it to other forms with success except for one problem. Once the form is used, Access will not fully close. The individual file closes but not the program. I have to use...