Search results

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.:(

I tried the following SQL statement: SELECT DISTINCTROW a, b, c, x, y, z FROM QRY_A but it gave me back some duplicate rows. Is that because my subquery QRY_A only returned a subset of the fields that were on the original tables? I was hoping I could use DISTINCTROW instead of DISTINCT...

Hi Everyone, this might seem like a trivial question, but I have a query called QRY_A which returns about 5000 rows with fields a, b, c, x, y and z. If I want to get just the unique rows from the results, would it be more efficient for me to use: SELECT DISTINCT a, b, c, x, y, z FROM QRY_A...

Thanks Penguino29. It will be a couple of days before I will get the chance to try out the code since I will be out of town, but I will definitely try it out when I get the chance and report back to you. ;) With regards to using PlusWorkdays + 1, I used to calculate my dates that way but I...

I am in the process of trying out many of your suggestions, and yes I would like to try the global array scenario if I understood it better. It would be great Penguino29 if you could post some sample code so I could figure out how to declare the array, where to put it, how to load it, and of...

Believe me I know that this is not a simple problem to solve. Anything to do with date calculations are almost always challenging. ;) I really appreciate everyone's time and suggestions. :)