Recent content by rene1000

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 ?

Thank you very much Danvlas !

it are 3 tabs or tab controls

unfortunately it doesn't seem to work buj123. any other ideas ?

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 ?

It's so easy if you know it ! Thanks again Roy

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

thanks Roy ! your first solution works great however the second one doesn't. I have now used the >= and <= solution to include 1-1-2003 and 31-1-2003

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

Thanks, it works !

you can use the following code to achieve this: 'first undo changes and close DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, ,acMenuVer70 DoCmd.Close

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 ?

okay,well thanks for the help anyway.

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

You have to remove the following three lines of code: **closes outlook objOutlook.Quit Set objEmail = Nothing this will solve your problem