Recent content by sseto23

Oops. I meant thanks Dave. I didn't see your profile information until I had hit post reply and noticed that Gemma was your dog. :o

Hi gemma, Thanks for replying. I have my Access interface options set up with: Default open mode = Shared Default record locking = No locks Open databases using record-level locking is checked off I tried setting the permissions on both the FE and BE so that everyone has full control...

Here a bit more information: When myself and another user try accessing the same database, via our own copies on our individual PCs we can open the frontend but once she accesses the backend database tables (ie. loads some data to one of the application forms), I am locked out of the backend...

Hi Everyone, I haven't been back here for a while now, but you guys were so helpful to me before I thought I'd try asking for help on another question I have. :D I have an Access database that is split, and each of the 6 users have a copy of the frontend database on their hard drive. The...

Ahhh, yes I never thought of that. I used your suggestion of just updating the row and it worked perfectly. :D I know the users will be adding to or changing the criteria again, so I'm not done yet :( but this is great!

Hi Folks.... this might be something that is pretty basic, but I'm confused so I thought I would ask for your help. I have a query called qry_A and it selects 6 installment dates (Instal1, Instal2, Instal3, Instal4, Instal5, Instal6) from an installment table. I want qry_A to call a custom VBA...

Just took a look at the article, and I was a bit surprised. I would have thought that examples B and C would have both ran the function only once and would have guessed that the outputs would have been the same too. I wouldn't have thought that the function would have been run once to create...

LOL! Most definitely. :D Thanks again everyone!

Sorry if I'm being dense here, but I'm not really sure what you mean by: "Also, if the function is returning a different value everytime it's run it will cause the query to run more than once, in most cases twice" Can you perhaps give me an example? Thanks :o

Yes! Things did speed up tremendously! The user reported that when she initially ran her testing it took over 15 minutes, but now it's down to under 1 minute :) Thanks for all your help!!!! I couldn't have done it without you! I really think this forum is great! ;)

The function that I was talking about is that infamous PlusWorkDays issue that we've been having so much fun with: :rolleyes: http://www.access-programmers.co.uk/forums/showthread.php?t=216855

Thanks Pengiono29....yes I'm back from vacation but I can't say that it's nice to be back since I went from sunny and 24 degrees Celsius back to rainy and 12 degrees Celsius (brrrrrrrr). Okay, this is where I'm at now.... My setup for the application's reports is that we use a frame (frame1)...

Okay, I'm looking at the sample code that Penguino29 provided, and I think I'm missing something :confused: Where/how do I call the subroutine initVar() to initially create and load the array with the holidays from the holiday table? I assume I would need to do this once up front somewhere...

I went with using DISTINCT because I couldn't figure out any other way to get rows with unique values, but I restructured my queries in the following manner: Original scenario: qry_A - selected records from a join of multiple tables and performed a VBA function for each record qry_B - selected...

Unfortunately changing the property to unique values instead of unique records will change the query from a SELECT DISTINCTROW to a SELECT DISTINCT which is not what I wanted to do because the SELECT DISTINCTROW seems to run so much faster than the SELECT DISTINCT.:(