Recent content by Osiris

Hello, Try this Replace strDBFile = "C:\NewDB.mdb" with strDBFile = "C:\" & Me.MyFormField & ".mdb" :) -Osiris

Never mind. I figured out what my problem was. :o I'm kinda stupid. :o Basically it was importing all the records too fast, It would have made the "Time" field have the same value for certain records, which in my testing was the only primary key that would have been different between the...

I'm not quite sure what you are saying? I am only trying to Import the rows once. I have ditched trying to import them with the query because it gives me the key violation error. So now I am only trying to import them via the code loop. Once I run the code loop it will import one row, then come...

True, and I actually never thought of it that way..:o If that is the case though, then why does it import all rows correctly if I step through the code? -Osiris

:( Yeah I have, still same result. It will import one row, then error out with "ODBC -- call failed" I thank you both for trying to help me out with this :), even though I have yet to be successful. :( -Osiris

Thank you for your help :) Ok, let me do a little more explaining. 1. Option Explicit is actually set, I just didn't post the top portion of my code, where it defines certain variables, and contains the Option Explicit and Option Compare Database. 2. I have modified the loop to now check on...

Thanks for the response :) Good idea, unfortunatly it didn't make any difference... :( I removed the "With" statements and added the designators back in, ran the code, and it still errors with "ODBC -- call failed" after it imports the first row.. So I stepped through the code, and again it...

Hello all, I am having a small problem with a little program I am writing for work. Basically it is suppose to take the information in one table and write it to another. Here is the code that I have for this.. Public Function Import() Set cnn = CurrentProject.Connection...

Worked Perfectly. THANK YOU! :D heh should have known it would be something rather easy. :o Thank you Very Very much. Osiris :D

The only problem is that strText1 is not the field on the form. strText1 is a string variable that is holding the name of the field on the form(txtFac1) that I am trying to currently write to. I need it that way so I can call this function from several different fields and store the actual field...

Hello all, I'm having a problem with a piece of VB code in a program that I am trying to create for work. Basically I am trying to write a function that will write information out of a table to various fields on a form. I plan to call this function from the On_Change event handler of each...