Search results for query: *

I did restore the last know working file and as soon as we did Norton Scanned the file and it corrupted again. Since I am not part of there Server Management team I can only point them in a suggested direction. I have asked them to remove *.mdb and *.mdw from their Norton Scanning schema. So...

Had a problem with corrupt mdw file. This apparently happened after Norton Anti-Virus was installed at server level. Un beknowns to anyone.... I do remember reading a q article about this issue has anyone else and if so do you remember the q# Thanks Eileen There is light at the end of the...

Did you ever have one of those days? Thanks the answer I had was right all along. Eileen There is light at the end of the tunnel!

Thanks but it still is not correct .. if I calculate the number of minutes between each date and divide by 60 I should be left with the hours and a fractional hour? Here's What I have 10/05/2005 11:25:00 am 10/05/2005 06:00:00 pm However, y = 6.5833333333 based on the above fields my total...

I've Searched the forum and found a few threads and tried a few of the suggestions but can't seem to get them to work. This is what I need to do.. I have two fields startdate and enddate both of which are set to a general date including time HH:MM:SS AM or PM for instance StartDate...

No thought of that too and checked the back end table to ensure that all records have a dol and they do. Thanks Eileen

I need to list three date fields in on box on a report. DOL - Date of Loss DOR - Date of Report DOC - Date of Closure It should look like this 1/1/1990 1/1/1990 12/31/1990 This is what I have for formatting. Trim(cstr([dol])&chr(13)&chr(10)&cstr([dor])&chr(13)&chr(10)&cstr([doc])) What is...

The header report contains basic information about the vendor the sub-report contains the data portion of the report (Payments made) which does not print and/or not visible. yet if i run the reports seperately they run fine. I did set the sub-report to grow and shrink but still no go this...

I have a report that based on a date criteria will pull information. The subreport is where the detail is. Now if there is alot of information to be displayed in the detail section then the report displays nothing but runs to over 100 pages. If there are only a few items in the detail section...

finally got it to work I removed the /User switch and everything seems to be fine now. Thanks to everyone that responded.

Thanks for the pointer I did not realize the auto feature on tables was available in 2000 as I developed in 2003 and then downgraded. The three suggestions seemed make a drastic improvement in the performance of the system. Eileen [bigcheeks]

I have a secured databased and an unsecured database, if the user opens the secured database I see an drastic lag in opening existing records. If I use the unsecured version there is no lag. Could there be a reference that should be loaded that isnt'? of is this a by-product of security...

the current user returns #Name? yet when I physically join the workgroup and log in it will return the user that I logged in as

Ok Finally got user level security to work properly. Heres my plight. I created a shortcut which includes the full path to acces in quotes, the full path to the mdb file in quotes, /wrkgrp and then the workgroup file name in quotes. I know for fact it's not joining the workgroup for the...

Thanks for the tip you are absolutely correct, I was going about it wrong. I misunderstood what the client requirement was based on a document received. After conversation we found that an edate and xdate for comparing the date of loss too was not necessary, and the objective is now working...

i is where it fails

Ok this is the code that I have Function LegClmNo() On Error GoTo LegClmnoErr Dim i As Long Dim j As Date Dim k As Date j = DLookup("[edate]", "BtblProgramClaimNumbers", "[programcode] = forms![BfrmClaimSummary]![prg] and forms![BfrmClaimSummary]![dateofloss] >= [edate]") k =...

Myabe a better explaination would be.. I need to maximize the prgclmno from table 2 by program if there was never a claim enterd under that program I need to set the legacy claim number to equal the AlphaCode + Seed. If there was I need to increment to the next number.

sorry sometimes my head is so wrapped up in what it needs to do I can't explain it right. Table 1 is nothing more then a reference I need to update the LegacyClaimNo with an Alpha Code from Table one where the date of loss falls between the edate and xdate of the alpha code. The reason is...

Well with the privacy act there should be no reason why the door can not remain locked.. unless it is for fire saftey. why not use card access if the person has card acces they can come in if not they can't. Further more the protection of personal information should be held to the utmost...