Search results for query: *

I want the users of my database be able to add a printer by clicking a button on a form. does anyone know how to do this ?

I have a form which has three tab controls on it. I have a button on the form which needs to run some vb code depending on the tab which is currently active. Does anyone know how to do this ?

How can i set the default button in a message box with a Yes and No button. It always defaults to Yes but i want it to default to No. I used this code: Dim msg, Style, Title, Response msg = "Are you sure you want to exit without saving the changes ?" Style = vbYesNo +...

i am trying to count the amount of records between 1-1-2003 and 31-12-2003 using the dcount command: inc_jan = DCount(&quot;ID&quot;, &quot;module_IM&quot;, &quot;[Call_date] > #1-1-2003# AND < #31-1-2003#&quot;) i get the error message &quot;Missing operator in query...

I have created a button on a form which does a filter by selection. i have used this code: DoCmd.RunCommand acCmdFilterBySelection Does anyone know how to undo the filter by selection with VBA code ?

Hello, I have created a script which creates printer connections. I also want these printer to print duplex by default. Does anyone know how to configure this using VBA ? My current script so far: 'create printer connections Set WSHNetwork = CreateObject(&quot;WScript.Network&quot;)...

I have created a startup script in the /etc/rc2.d directory to start Samba during boot. The file contains the right command to start Samba. It works when i enter the same command at the command line, however when i manually run the startup script or automatically at boot it doesn't work. The...

i have a textbox in which dates are entered. on the afterupdate event i would like to check if the date entered is on a weekend. how can i do this ?

I have created a button which prints a report like this: Dim stDocName As String stDocName = &quot;Incident report&quot; DoCmd.OpenReport stDocName, acNormal I would however like to see the printer select screen (CTRL + P screen so to say) instead of a printout to the default printer. How can...

I have an textbox which is used to enter peoples first names. I want to change the first character to upper case and all other characters to lower case using vba on the after update event. How can i do this ?

I have created a form which contains a datasheet subform with multiple columns. On the form are two buttons which should sort ascending or descending based on the column selected in the datasheet. Does anyone know how to do this ? Thanks allready, Rene

I have created a form with 372 textboxes which can each contain 1 letter. I want to count in how many of these textboxes the letter (for instance) V is entered and show the result in another textbox on the form. Can this be done ?

I have created code to send an email automatically when a button is clicked on a form. I have to set the &quot;edit message &quot; option to true to be able to set the from address. I do however want this set automatically, so i can fully automatically send the e-mail with the right from...

I have created a button which checks the spelling: Private Sub button_spelling_Click() SendKeys &quot;{F7}&quot; end sub this works but it starts checking all records in the table instead of only the required current record. Does anyone know how to limit the spell checking to the...

On a form i have created a list box and a memo field. The list box contain peoples names. If i double click on a name, the name is added to the memo field. I do however want to check if the name is allready in the memo field and warn the user if it is allready added. Someone know how to achieve...

I have created a button which inputs the date in a memo field. Once this is done i want to put the focus on the memo field again and i would like the cursor to be placed behind the just inserted date. this is what i have so far: Screen.PreviousControl = description & vbCrLf & vbCrLf & Date &...

I want to create a button which inputs the date into the current active field (with the focus on it). Therefore i need to read the current active field name. How can i do this ?

I want to limit the bandwidth each user has when accessing the internet through MS ISA server (for example, i would like to give each user a maximum bandwidth of 64 Kbps). does anyone know if this is possible and if so can you explain how to do this please. many Thanks !

Hello all, I am looking for ways to limit the bandwidth each user can use on a Routing and Remote Access VPN connection. I want each user to have a maximum of 64 Kbps connection. any help is greatly appreciated.

I have created a form which contains a save button to save the current record. is it possible to check if the record has not been saved yet using VB code ?