Recent content by JoeCool71

I'm working on a project where I have limited access to the warehouse and limited access to the WebFocus application. The warehouse we are working with is normalized in nature. Although I have input into the design. At the end I will only be able to interact with Master Files and Business...

So simple, but so effective. Thank you!

I currently have a subform displayed in a datasheet view. The only issue I'm having is I can't use the docmd.gotorecord or any of the list box controls to gain access to a field or a given record. There is a field I have on the subform wich is a combo box that is pointing to a field on the...

Are you doing this within the same form or from another location? Within the same form you should be able to refer to the field as Me.txtAccelID. Please let me know if this does not work. Jim

I'm not sure if this will help or not, but in working with Access over the past 5 years I have noticed some things that can not be explained. Your code above is one of them. You are creating a field in your SQL called Payments and then you are trying to pass this argument in the next field...

Prior to running your select into statements...I assume that you are running this in VBA then use the following prior to running. Docmd.Setwarnings False Your Statements Docmd.Setwarnings True

I don't know why this is vexing me, but I have run accross a request that requires me to add a Header and Trailer to my data. Everything that I'm accustomed to would errase and existing file if I were to export data to the same location. My client would like the header to be one line of data...

Well it finally works. Thank you for all of your help. Two minds are better then one.

How is your field set up on your SQL table? I would start there. When you receive a 1/1/1900 date field, your table is set up using a normal date format and is converting a none date into a date it can use (1/1/1900).

I installed VB sp5 and repackaged and reinstalled the application and I still ran into the same issue. I'm using an Access database as the back end and am using jet 3.5. Should I change the ADO to jet 4.0?

I ran it both ways and the application works correctly after loading VB6. I'm at a loss... I've done a ton of research on the net, but I don't know what to do next.

I'm not certain I understand? From my understanding the IDE is the development interface (visual tools).

During testing my desktop application is working fine. I packaged the application and ran the exe file and the application still works fine. I also tested on various computers within my department and the application tested successfuly. When I install the application in another area of my...