Recent content by jnixon

Thank you!! That's exactly what I wanted!

I'm having the same problem as described above. I have 4 combo boxes, and I need to filter a query out using any number of those boxes. However, I'm no good at SQL and I can't seem to get a query to work that would say "If the combo box is not null, filter by combo box, else display all". Right...

Booo. Okay then, I suspected as much. Anybody have any ideas on how I can make the module compact/repair the database and then continue running the batch? Thanks.

Hello everyone! I hope you're all having a good week. Mine is going great! I built this great database that runs batches of properties, pumps out a bunch of calculations and returns a value. I'm running a batch of 1,000 properties, and everything was going really smoothly until I reached about...

Great minds think alike, RG. :cool: I realized that before lunch, and it actually helped me find the null value returned that was causing my data type mismatch error. Thank you so much for your help!

RG, you always seem to be there when I need ya. Thanks. That worked, sorta. After the "No records to process" message box, it said "Data type mismatch in criteria expression", and then stops and doesn't continue on to the second part of the process. Another thing is that I don't want a message...

Hello all, I found this module for coming up with a median value somehow through this forum, although I can't find the thread, and someone might have actually sent me a db file with the module in it. Anyway, I need to add something in here that will prevent a run-time error when there's no...

Hm, I think it's the cleanup that I'm doing on the memo field that is causing it to truncate - see http://www.access-programmers.co.uk/...184#post464184 . I tried querying right from the table, and exporting the field raw, and it exported the entire memo field. But, when I apply anything that...

Anyone have any ideas? Thanks.

Hello! I have a problem resulting from some previous issues I had with a memo field, and you can see the original problem here: http://www.access-programmers.co.uk/forums/showthread.php?p=464184#post464184 I'm starting a new thread because I have a somewhat unrelated problem with the same...

Thanks for all your help, RG! I will start a new thread.

Yeah, I've actually tried comma-delimited and tab-delimited. Both of them truncate the field, and it doesn't seem to matter if there's a " text qualifier either.

OH! Okay, yeah there we go. That did it! It looks like it did take everything out that I needed, and displays the whole memo field. Thanks!! I don't mean to be too much of a pain.... but, I'm trying to export this to a delimited text file, and the memo field gets truncated. Any clues?

RG, I did what you suggested. I created a module named basStrings, and copy/pasted the code you posted into the module. However, when I try to find the function in the query builder dropdowns, I can see the basStrings module, but neither of the functions display as usable arguments. I tried...

Well, no I don't think so...I'm not doing any of the things described in that thread. It's not a Union and it's not a Select Distinct, it's just a Select query pulling the data from a few different tables on the SQL server. I think the problem may be that there are more Ascii characters that I...