Recent content by StarvinMarvin

this one went away on it's own, oddly enough. I quit working on it for a while and when I came back and tested things again the extra , was gone, which makes sense because it's only supposed to be between values. Thanks Bob.

ok.... I failed to define the array as a variant, had it as Integer. Now I'm Joining the values with a ","..... any way to remove the last "," after the last variable?

I'm trying to filter out 0 from a numeric array using the following: MsgBoxDOGS = Filter(DOG, "0", False) Getting type mismatch error. I understand "Filter" compares strings but I'm reading at vba-corner that it converts numeric values to strings for comparison.... Happens no matter how I...

rather than try to refer to the form control value I just brought it into the code as a variable, and I'm comparing that value to the other 6 variables. I see what you did in the code now.... I can see I need much more practice in changing need to code:rolleyes: Thanks so much Brian.

Compiles but Error 438, object doesn't support property or method. Tried changing brackets... no go.... trying to think of another way to do this... somehow assigning and checking variables for 8,9,10 as well as the 90's?

trying to check if the value in GOInfo.DOG appears within the string "groups". If it's found anywhere in the string I'll get a value other than 0 which lets the sub continue, else exit sub. "groups" will always contain at least 3 numeric values that will appear in the string like this: 91,92,93...

Trying to do the following: DOG = InStr("groups", Forms!Enter!GOInfo.DOG) Getting "object doesn't support this property or method". GOInfo.DOG is bound to a numeric field and has contains a value. Tried Cstr(GOInfo.DOG) and get same error. Is this because the bound field is numeric?

The update that appears to have created this problem is KB976382 whic updated a visual basic dll file. This has caused a query on a linked ODBC Oracle table to stop functioning with the above listed error. If anyone else is using queries on linked Oracle tables please let me know if you're...

ok, this problem has to be the fault of the admins changing something on the server end or MS has pushed out an update in the last 24 hours that's screwing this up. On a working distributed app that worked fine yesterday, the main form now fails to load with: The expression is typed...

Welcome aboard Jorge... While I'm not the best person here to make recommendations about your problem, I thought I'd add my 2 cents before someone else solves this for you. I started the same way, trying to use built in features of Access to do everything I needed. I quickly found my needs...

I recently saved a 2007 database to 2003 for work in which everything worked OK in the 2003 version inside Access 2007. It appeared to work ok for a while until recently when I started having problems with 2 stored queries. Query 1 pulls employee data from a linked Oracle table and specifically...

well that works great! I gotta tell you guys I've never used a function in this way before.... took me a couple seconds to see how you were invoking it :o I promise to leave you guys alone while I put this into my form :) Thanks for all the help and the lessons. I better understand Mod now...

I was thinking you used 9 because there are 9 day off groups (minus the 3 I'll get from weekday). My intended use is to put this in ON_Update on an activex calendar, so when the operator selects a day on the calendar the function runs and comes up with all the applicable day groups for that...

looks like it's not going back to 91 after 99, goes up to 100,101,102.

ok, changed: x = z -2 y = z - 1 to x = z +2 y = z + 1 Gives me the right days.... still trying to figure this out...