Search results for query: *

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.

...like the following: Dim db As Database Dim rstNextMemberNumber As Recordset Dim intNextNumber As Integer Dim strSQL as String strSQL = "SELECT * FROM <MemberTable> ORDER BY <MemberTable>.MembershipNo DESC;" Set db = CurrentDB Set rstNextMemberNumber = db.OpenRecordset(strSQL)...

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

...Alias "GetUserNameA" _ (ByVal lpBuffer As String, nSize As Long) As Long And make the call using Dim lpBuff As String * 25 Dim ret As Long Dim UserName As String ret = GetUserName(lpBuff, 25) UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)...

excellent, cheers to everyone for all your help on this matter. Regards, John

cheers, Returns: "Microsoft Windows 2000 [Version 5.00.2195]" So is there a way of finding the underlying version number? or is this it? BTW, the reason this is on a Windows 95/98 forum is because some clients are on Win98. cheers, John

'MS-DOS' is not recognized as an internal or external commant, operable program or batch file." Any suggestions?

Hello, I was wondering if any of you could help me with a problem I am having. It sounds like such a simple problem, but I have searched MS and here at TekTips to no avail. Is there a command in dos that will return details of the dos version that is currently installed? I am sure there must...

I have never really user images in a database before, but suggest you try to Compact (Tools&gt;Database Utilities&gt;Compact Database) after removing the images. Hope you find this helpful. cheers, John