Search:

Mark, you are correct I should have done a better job of describing my situation. There several forms that are slow, but my original post was for the one form.

It wasn't one Dlookup is was 2 of them and only on one form. To test my assumption I made a copy of the form. I then ran it several times and averaged the time of the form with the Dlookup, then I...

First Thank you both Wendell & HansV for all of the valuable information you both have providing me with.

HansV, removing the DLOOPUP and going to recordset improved the speed of the lookup. I was...

Thought about using Access security. However I keep hearing that the workgroup needs to be kept with the mdb, if this is the case the user can bypass (over write) the workgroup and have admin access...

Thanks HansV, I'll give it a try and post back the results. <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

I have splitted up my time clock program into a FE BE and it works fine with one exception the forms are very slow and I'm going to have to blame the dlookup function. OI would like to know if there...

Thanks for responding Wendell, I checked to see if the user had installed the service packs and I found that they had all of them installed.

I checked the service packs and the user has installed them all.

Sorry for the lack of information, please see attached <post#=209710>post 209710</post#>. Thanks

Ok, I've post an issues in the Access forum and unfortunately we were not able to correct the problem, so now I'm going to try this forum, so here goes.
When Access 97 is installed on the XP machine...

Sorry Charlotte, but these are the facts, the user is using Windows XP Home Edition with MS Office 97 in their home and it isn't on a network. The installation was a standard one, I've even checked...

Just when I thought I had this problem fixed, the user goes out and re-boot his PC and it starts all over again. As it turns out un-instaling and re-install only keeks the program running correctly...

Well, I did a netmeeting with the person who is having the problem, and they didn't have Extensibility Library reference checked, there was only 3 items checked Visual Basic For Applications,...

Thanks for your responce Tom, but sorry no missing references have been found.

Hello Charlotte,
Thanks for your response, I double checked my references and there is no sign of anything missing, each check mark is referencing an actual item, the app is actualy a very simple...

Sorry for the delay in posting, been spending late hours at work. Ok, I've attached a copy of the application when you start up the app it will come to a main form choose Find Anniversary, before the...

I checked the references and none of them are showing as missing, I also deleted the test information re-added it and it still give me the same problem. Could this be a corrupt installation on the...

Ok, this is the function I'm using, its pretty streight foward.

Function NextAnni(dtmDate As Date) As Date
' Find the next anniversary of a date.
' dtmDate:
' A date...

Wow, I'm having a hard time trying to figure this out,
I have a function that lets the user know when the next anniversary date of a given date will be, this function works fine using Access 97...

Andrew, you did it again, this worked perfectly.
Thank you very much for your help.

W.R.

Andrew, you were right on the money. Your script worked as it should. But I do have a question what if I wanted to start pasting the information over into cells A13:B13. currently it strat in A1:B1,...

I've been bashing my head trying to get excel to copy from sheet 1 to sheet 2 and them automatically sum at the end of the last cell.
I'm trying to remove as much of the manual labor involed in...

Hello Everyone,
I need to know how can I go about creating new tables via code in a linked backend DB. My problem stems from the fact that I have created a FrontEnd and Backend program that is now...

First of all thank you Charlotte for your response.
The differences you

Ok, this problem is driving me nuts!! I created a union query in Access 97 and it works great, however when I create it in Access 2000 I get the following error message: Data type mismatch in...