Recent content by etsoft

On slight problem is i want to use the standard windows printer which i have set earlier in the code. At the beginning of this procedure i change the default printer to a pdf printer. With the exexution of your code it is reset to the original printer. Can that be changed ?? This is the...

Wow thanks , is working and thank you for the in depth explanation. I wonder if this would work with pdf files as well , although that is not a 'graphic' format.

Hi, is there a way to print jpg or other graphic files from vba code like you do with office files ? Thanks in advance Erwin

Hi, how can i print an external document from code ?? Thanks in advance.

Hi, i'm building a on screen keyboard with has to adjust fields on a subform. When pressing a key a letter is added in a certain field like : me!subform!field1= me!subform!field1 & "Q" How can i detect which field has the focus on the subform and the code is only editting this field ? I've...

populate this at a certain moment : me.dropdown.rowsourse = "your query transformed to sql code "

You need to do wto things : - define bookmarks in your MS-Word file where you want to place the data - code to put the data like : Set rcs = dbs.OpenRecordset("SELECT teh data you want here") Dim wd_app As Word.Application Dim path As String Dim theTemplate As String Dim fs As Object Dim...

Hi, sometimes i'm able to call a function in another open form ( f.i. to recalculate things ) from another form with Forms!something.redo ( redo is function in the other form ). In another case i'm not abe to do this. What is the best way to do this ? A simple requery or refresh is not working...

Hello, i want the user to be able to reposition the buttons on a form. So far i was able to do it with one button, the user presses the button and clicks on its new position. The position is written into a table which is being read when the forms opens. This works fine. Here is the code...

if your qeury is showing you the right number of records, take a look at the SQL code and copy it. In a form you can create a button which is having the following code dim rcs as recordset set rcs = CurrentDb.openrecordser("your copied SQL code , you need te change the " into ' . ") do...

Wayne, great . This code did the trick Many thanks ..

Hi, at the end of a report i need to send a form feed to the printer. The ticket printer will the cut the paper. How can i do this ?? Thanks in advance

Hi, i've made a report which contains a formfeed item but when this is beind send nothing happens on my ticket printer. The settings of the printer are set to a cut action when a form feed is been send. I do set it to visible with :me!pagefeed.visible = true in the detail settings . Does...

ok, i will try this first ( i allways try it first myself and then come with questions ) My standard toolbox does not include this one, ( 2000 version ), where can i find it ? thanks

Hi, is it possible to have a selection box in which you can select more records ? I want to do somthing with that ... Thanks in advance