Recent content by mfiedler

I was able to get the function running. I replaced the Do Until Loop logic, with a Do While Loop logic. A few other errors popped up and I worked through those, but the code is now working properly. Just wanted to update anyone who may have been looking at this. I also have included the...

I think I need to go back to programming basics 101....;) I discovered the overflow error is related to long integer types that overload after 32670, hence explaining the error. I also learned after looking at this more closely, that my tables had the data numeric types of Double, not Integer...

I wanted to provide a little more detail. The value of X when it stopped was 32509, but it is when it tried to add 261 to that value that it froze the function. The value of v at this comparison point is 625000. I have included a word file below that has some sample data from the T table...

Thanks for the advice Fear Naught on the help from VBA. A list does indeed pop-up. Wow this program is user-friendly (at least when you have a better idea what it is doing). As for the value of x in the break code, it listed 32509. Why do I get the feeling this is hitting some kind of...

Great point on the append rather than update Fear Naught. I am assuming I would just have to change the text from s.Update to s.Append? Thanks, Matt

With some offline advice, I managed to get past the 3021 run-time error, but now have run into a run-time 6 error (Overflow). It is on the line x = x + t![Bulk Qty] located in the second If-Then-Else structure. I stepped into the function using the F8 key and it runs through several times...

OK. I made a few changes to advance the record in the S table, but when I run the function, it gives me a run-time error 3021 and points to the statement s.MoveFirst as having no record. So I tried putting in some default values just to have data it could identify with, but it still had the...

Holy Brain Fart!!!! Please ignore my question of where to find the References section to activate the DAO functionality. Gee, it wouldn't be under "References" would it? LOL!!!!!!!! Oh well, at least it is Friday. Thanks again for your help Fear Naught. I will insert the next record...

Thanks for the help Fear Naught. I had my original code structured in a traditional format, it did not translate to the post when I pasted it. My apologies, it is much easier to read when it is setup correctly. Thanks for making it easier on the eyes. Although this is going to sound like an...

I have tried to search for an answer on this elsewhere, and it is likely easy to fix, but I am having no luv. I included the function I have written below. This function is to look at a record in table T, make some comparisons and if criteria is met, open and edit a record in table S with the...

Thanks for the advice Pat. I will look into having the weeks in rows, however, there are 300 products I am looking at, and I was not sure Access could handle 300 columns, as opposed to 52. At least I have some agreement in the fact that I need to move to VBA for this part. That is primarily...

Timer idea Thanks for the timer Selena. I have implemented it to cut down on the number of active users, which makes it easier to get remaining active users removed from the database when necessary. :) Matt

I am a newbie, so please forgive me for such an easy question, but I am stumped. I attached a text file that shows the data I am working with. What I need to do is take each product (labeled Prod) and do a weekly sum on the quantities and compare against a set number to see if the quantity is...

Is there a way in Access to logout users from a database in order to make updates without having to setup a FE/BE situation? My company is using Novell Client 4.90.0.0 SP1a. I have read some logs where you choose File --> Open (exclusive), but I do not have that option (using Access 2000)...