Search results

I know this is strictly not a subject for here but the toolbox icon when clicked does not open the toolbox. It has worked, but has suddenly stopped. I've tried all sort of help including MS knowledge base, I reinstalled the application (2000) but nout worked. Anyone any idea?

I have control button on form that runs a filter. Code essentially like this:- Me.Filter = "[Credit Approv] = '" & [Combo62] & "'" Me.FilterOn = True Me.AllowEdits = True Me.AllowAdditions = True My problem is that with the filter on I am unable to change the value of [Credit...

I have a form with a few filter buttons which normally works fine. The problem is that when the filter condition finds no matches, the form just displays the background and nothing else! I would have expected the field to display no values. The code on the filter buttons is something like this...

My db uses a command buttom to send e-mail by Outlook. The following code selects the record to preview then e-mail. I'd like to be able to select multiple records as attachments on the one e-mail. I suppose I'd need additional field(s) on the form to select the records but I'm not sure how to...

I understand what u say about the optional argument but what this [CODE] /[CODE] tages stuff?

Sorted. Thanks

I'm using the following to e-mail a report from control button on form. The purpose of the it then else is to open Outlook with the e-mail address of the recipient if stremail contains a value and open it with the recipient blank if stremail is empty. All I get is the error message "Invaild use...

I have a number of db with the tool bars etc hidden and control buttons to navigate and perform othere functions. Some users are getting wise to the Ctrl + Shift on start up to gain the full functionality. How do u disable Ctrl + Shift?

Tried both of these (and other variations) and still no joy. I'll follow up the other threads. Ta

I've a problem in that I can send an e-mail (and .rtf attachment) only once each time I open Access (2000). I get "E-mail has been sent" message box when trying to send more than one. Code behind command button is:- Dim stDocName As String Dim stremail As String stDocName =...

Come on lads Come on out there. Surely there is an answer. If I'm pi**sing in the wind please let me know.

I need a to recognise in muliti user db when the last user is quitting. I would like to run some backup routines and possibly compact and repair on exit. I understand C&R on exit stops halfway through if there is another user accessing the db. Any ideas or threads to follow?? Ta

Compact on close Can any senior members comment on the compact on close where there are multiple users? Are there any links for this?

Multiple users What is the effect on the db when u run compact on close where there a multiple users? I would like to run this when the last users closes the db. Possible?

password protected form Boys oh boys oh boys! The lad said the the input box method was OK. Could someone post the code to change the password fonts to the background colour. We can all rest happy then. Ta

I'm having trouble printing a photo in a report. The photo is attached to form a icon in as a bound object. In the report, again as bound object, I've set the field property Size Mode to clip. On printing the report I can only get the icon. Any ideas or links please? Ta

I've got a problem with the following syntax. This code is a Click event in the form property. I'm trying to open a form that has the same name as the field [Style] but can not get the syntax right. The field [Style] can be one an number of options with a form of the same name. The criteria...

Sorry, not got fix. Tried to find this on forum but got dead end. This has not been an issue for my users but would like fix. If u solve this or anyone else has fix, left me know please.

Yea found a few. Ta

This code I have used a few times and works OK. It's in the On Click event procedure on the button that opens the form. I got it off here a few months ago. Hope it helps. ++++++++++++++++++++++++++++++++++++++++++++ Private Sub Command17_Click() On Error GoTo Err_Command17_Click Dim...