Recent content by Keetso

I certainly agree that it's not a huge issue by any means. However, I had set the "Default Open Mode" (Tools - Options - Advanced) to "Exclusive" about 6 months ago and all was fine. Only the first person to open it could modify records. Recently I was informed that all 3 can now open and...

Hi. Anyone have any ideas? Anyone? K

Thanks for your quick reply, moby. To clarify, A single, stand alone database is located in a folder on Employee "A"s network share called, for lack of better words, "AccessDB". Employee "A" has given full rights to the "AccessDB" folder to Employee "B" and "C". "B" and "C" has created...

Hello. I have a database that needs to be accessed at times by more than one person. In other words, Employee "A" opens the database. Since Employee "A" is the first person to open it, she/he would be able to add/delete/modify records as necessary. While Employee "A" has the database open...

Hi. I'm attempting to upgrade from Office 2K to Office2K3 and am getting the following error message: CR561401.CAB Not Found This CAB file does exist on both the CD and on my HDD (I copied the CD(s) to my hard drive). I've pointed to both locations when prompted and continue to get the same...

Another related question if I may. Using the DateSerial Function above, is there a way to modify it to return the total number of days in the "month" returned? For example, if the user types the value 10 (numeric) in the parameter [MonthNumber], the function...

You might want to check any underlying queries as well. K.

Hi. I was wondering if there's a way to take the decimal value of a month and covert it to the string value. For example 1 = January, 2 = February, etc

Hi all. Problem solved! I created a function as follows: Function FullMonthName(mnthnam) FullMonthName = monthname(mnthnam) End Funtion Then in the text box's "Default" field entered: =FullMonthName(datepart("m",date())) That's all there was to it. Thanks again, Lightning for all your...

Hi. Not sure if you've looked at this or if this is your exact problem but it might be worth taking a look. http://support.microsoft.com/default.aspx?scid=kb;EN-US;248967 K

Hi Lightning. Thanks again for all your help! You've been an amazing source of knowledge and help. I really appreciate it. I haven't been able to try out your last suggestion yet as I haven't been able to remotely connect to the client's computer. It's supposed to be fixed by this afternoon...

Lightning? Have I annoyed you to the point of abandonment? <kidding!> This problem is still driving me crazy and hope to get some additional input. Again - Many, many thanks in advance! K

I'm not sure this will solve the problem since this would return a numerical equivalent of the current month (i.e. a "6" instead of "May") and would generate an error because the field is a "text" field, correct? Thus, I had used the function "monthname" to take the "6" and convert it to "May"...

One addition. The problem seems to be in the Default Value " =monthname(datepart("m",Date())) ". I removed this and the error is gone but so is the current month showing as the default value. So now the questions are these: 1) Why does this not work in XP 2) How do I allow the current...

Hi Lightning. The references are identical on both machines (the one it works on and the one it doesn't) and there are no references marked missing. Any other ideas? Just for point of reference, the combo box having problems on the XP machine: Name: cboWhichRptMonth Control Source...