Recent content by john2thompson

Don't think there is an event that would meet your needs, but might be wrong. Still performing a simple .bof and .eof or DLookup statement on the command button click wouldn't provide too many difficulties. Regards, John

If you want no error message to be displayed when the input mask is invalid, then you can use the Form_Error event to catch when an invalid input is made. Private Sub Form_Error(DataErr As Integer, Response As Integer) If Screen.ActiveControl.Name = "YourTextControl" Then...

Excellent advice Gransbpa. For those that dont know how to do this, in Excel or Word, click Tools menu. Then AutoCorrect. On the default tab, scroll down the list, click the entry you would like to prevent from Auto Correcting and click the Remove buton. Regards, John.

In reply to 1) When you have imported your spreadsheet with the current membership numbers, you can use code to increment any new entries to follow on straight from the last membership number in that field. You can create a select query recordset that is sorted descending (so the largest...

You might want to try: frmAjoutBandesVideos.RecordSource = rsBD I dont think you can directly bind the recordset to the form, instead the record source preperty allows you to do this. Regards, John

Shady, Funnily enough, a colleague of mine had a problem similar to this today. It is quite possible that if you are running Novell Netware servers it is caused by this. Try here: http://dbforums.com/arch/106/2003/10/877674 and here: http://p2p.wrox.com/topic.asp?TOPIC_ID=5120 for more...

Below if ths full text of an article on MSDN that should be able to help you. Hope this helps. Regards, John ACC: Jet Database Engine 3.x Error Messages Due to Corruption Applies To This article was previously published under Q182867 Novice: Requires knowledge of the user interface on...

OnTheFly, I think with this post, 9star is implying that he would prefer advice on how to find out how he can discover the person that changed the read only status (rather than how to change it back) - any suggestions? Regards, John

hmm, not 100% sure, as I dont really deal with this thing, but will try to give you my 2p anyway. Theres a folder on C: which I presume will be the same across many users PC's (and most likelt O/S's too) called: C:\Program Files\Common Files\Microsoft Shared\Microsoft Access Runtime If you...

Theres nothing in Access that would store something ofthis nature, so I think you are out of luck there. I would suggest possibly posting this message on another TekTips forum to do with Networking, who might be able to offer you some advice whether it is possible to follow some sort of audit...

I think I understand what you mean. Essentially, you want to be able to change the colour of the text on the calender for a specific day? I'm not sure this is possible. I only have Calender Control 8.0 here, but the closest property I could find (DayFontColor) only allows the colour of all...

Hello, Is it possible that the users are opening the database 'exclusively', i.e. so they can be the only user using the database at this particular tim - this is done by File > Open Database then clicking the Exclusive check box before clicking open? Regards, John

Hello, I was wondering if you could help me with a problem I am having regarding the System Tray. I have successfully added an icon to the system tray. The icon has a tool tip so that when the mouse hovers over is, a value used in the program is displayed. The problem I have is this: is it...

I don't really have much experience with using files in this way in VBA, but could it be because ou are using the wildcard character (*). If there is more that one file that starts with SRAD then it could cause a problem? Alternatively, it could be looking for a file literally called SRAD*.CSV...

Good point about the environ call MinnKota. However, show some caution when using it as it is dependant on the O/S. I think the environ("username") worked OK for me in Win95/98 however I got stung in Win 2000 and had to use environ("nwusername"). Failing that of course you could use an API...