Search results

Thanks ByteMyzer, very informative. I've moved to using small single query functions in my new code, it's the old code I'm worried about. I'm fairly positive that when you exit a procedure all local variables (including the recordset) are set to nothing, correct? Banana, how would I go about...

My apologies for resurrecting a long dead thread, but did you ever find an answer Bob?

I had the same problem on a particular class I was working with. It would actually freeze when I compiled it and come to find out it was a conversion problem. I don't remember what the two variables were, I think one was an object and other a long and because I missed the property on the object...

What is the current file version for this ocx? I'm currently using 6.00.8804 but the only version I can find online is 6.00.3 or 6.00.5. I want to make sure that I'm using the most up-to-date since this link seems to be the same problem I'm having. Thanks!

Nah, I need to tell CR to repeat the same data X number of times based on a parameter.

First off, I'm more of an Excel guy, but I've spent some time recently working on forms in Access. From what I can tell in order to test the value, the text box has to have focus which means the text box has to be enabled. My first tip is to not open the form with everything disabled but...

I'm new to CR, other than changing the selection expert to find different data and am attempting to create a shipping plackard to go on skids. My problem is that I don't know how to repeat the data for X number of pages. Begin background info: Essentially, the prompt states the number of skids...

This is just a sample which show's what you requested. Sub DeleteFile() Dim strInput As String strInput = InputBox("Full path and file name:", "File Name Test", "blah") If strInput = "" Then End If Not Dir(strInput) = "" Then Kill strInput End If End Sub Note...

Actually, I think .AbsolutePosition would work perfectly for me. I was hoping to have a single line, but two lines'll do. I am still unfamiliar with it, but from what it does, I think it'll work perfectly for me! Thanks for your help!

No, the code I provided was for .Net 2.0 where I removed the variable names (except for R for row and C for column/field) and put in the variable type. My whole goal is to avoid the move next statement whichever way is possible. I like the datatable functionality in .Net because I can say "In...

With a slight modification to the module from the "Shell and Wait example" AppsPro.com I believe this will work perfectly for you. It keeps track of the processes running and knows when it has been completed. The line that has to change is : If Not bShellAndWait("Calc.exe", vbNormalFocus)...

Well I'm just entering into the .Net world but I wanna try my best to help ya: First off, use filestream as well as streamwriter; gotta make sure the file exists first. Also, don't define sw (Stream_Writer in my examples) so early, define it after the FileName as been determined and the...

Hey there guys, I've created an installer program in .Net 2.0 before finding out that the units to be installed wont have .Net on them yet, so I'm having to re-work it all in VB6. Well my question is about datasets and/or recordsets. In .Net I could get the value from a column/row by Dim cr...

No one has any ideas? Oh well, I've scrapped that project anyway. If someone does find a solution, let me know though! :-)

Hey guys, I've run into a problem I can't seem to find a solution for. I've got a packing list that I don't want the user to save over or print without saving to another location; both of which I've interrupted using the BeforeSave and the BeforePrint. Both of these feed into the same module...

So, I've come across a way to fix the problem. When it starts doing that, if I clear all breakpoints and save, then restart my computer it'll run fine for awhile. Must be some windows cache thing or something of that sort that gets bogged down. Hope this helps someone.

Well, I know how much people don't like to have a second thread made about something that's exactly the same... Wouldn't consider it a hijack more like a piggy back :D

I've having a similar issue, the code worked find in the past, but about a week ago, it started getting angry with me. It seems to be happening after almost all of my SQL queries which are restricted to a single module. Below is some code. The queries are completing correctly and updating the...

Awesome. I was actually looking for something like this!

Do you want the date field checked before the qty field? Or vice versa?