Search results for query: *

Hey..Am good..thanks.. How abt u? The reason they are not bound is becaus the form has values from a lot of other tables and inserts values in different tables. So I just left these unbound so that I can get values and update the table. Does that sound correct?

Hi, I have a subform that has a table as record source. I'm including this subform on another form. Now when user enters values in the subform, it inserts those values in the table and this table has a autonumber field so every insert generates a new autonumber. In my form I have some more...

Thanks Hugh... I totally understand what you are saying but I have no formal training in VB and started working in it just 2-3 weeks back. I just had to get this report created and would then be done with VB coding. So I was trying to avoid getting books and understanding all basics. That being...

Thanks Jerry and Hugh however I'm lost. :( I'm just not able to get this thing right and I have to get this done before end of this week. Can either one of you please look at the code I posted initially and make changes to that to include the option of checking already open file? I'll be really...

Please help

Thanks Jerry but I'm still having issues. :( With the 2nd piece of code, it works fine and creates the report if there is no customerpricing file already open. HOwever if there is such a file open, then instead of giving a message about file being open and exit the function, I get a runtime...

If I use "For Each oWB in Xl.WorkBooks" instead of the line "For Each oWB In xl.Worksheets", it runs the code fine for the first time. However if I run the report again with the first file open, it doesn't give the message and stop the code like its supposed to but keeps trying to create the...

Hi Hughlerwill, What you said does make sense however I guess I'm not doing something correctly. I changed the code as below and am getting error "Method Worksheets of object '_Application' failed". Can you please suggest what I', doing wrong here: Public Function getrmpricing() Dim...

Thanks but its still not making any difference. The important thing is that the code works fine if I get rid of the code added to check if file is open. Its only after I added this code that it doesn't kill the excel instance even if user closes the file.

Hi, I have a code that creates an excel report from a template file and query output. System was freezing if user runs this reports again without closing the previously created file. So I included a code that checks if a file "customerpricing.xls" is already open on user's system and if it is...