Search results for query: *

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

Lightning. You deserve a star for patiently explaining this to me. Is there a way to "update" the object reference libraries or import the object libraries from my Win 98 machine so things will run smoothly again or do I just need to re-link (for lack of better words)the offending text boxes /...

Hi. Thanks for the reply. I'll look to see if it is a missing reference? Is this a known issue with Access 2000 running on Win XP? I have to assume so since I can copy this database onto a Win98 box and it runs perfectly. K

Hi. I recently developed an Access 2000 database for a client. She recently upgraded her computer from Windows 98SE to Windows XP. The program ran perfectly on her Win 98 OS but is now getting a #Name error in a combo box. This combo box uses a "month" table to allow the user to "enter" a...

Hi. Was just wondering if it's possible to have Outlook (2K2) folders displayed non alphabetically? For example, Under "Inbox" folder, I have 3 sub folders: Aardvark, Tiger, and Zebra. Is it possible to have them listed in the tree as: Inbox -Tiger -Zebra -Aardvark This question...

Thanks to all for the education. I appreciate it. Hopefully you all won't mind if I should have further questions once I disseminate what you've already told me. Thanks again. K