Search results for query: *

Is there a way to include an Acrobat pdf document into a MS-Word document and keep the pdf format when the Word document is being printed? Thanks a lot if anybody could help!

Hello! I created a user event on a datawindow using pbm_dwnkey. The idea is to test all characters the user enters in order to accelerate the edition. This works fine. But there is a litle problem: with some combination of actions, suddenly the argument named "keyflags" is set to 1...

you must replace &quot;d&quot; by &quot;dd&quot; or &quot;day&quot;, i.e: SELECT cctr_master, (case when starttime < shift_starttime then dateadd(dd,-1, startdate) else startdate end) from st where (case when starttime < shift_starttime then dateadd(dd,-1, startdate) else startdate...

Is the group number not written in each group separator? I sometimes use the following trick when I look for something in &quot;tons&quot; of data in a DW: select the DW in the library and &quot;export&quot;. You then get a text file in which you can analyse some stuf in a much more easy way...

hum.... And if so, if(toggle,&quot;On&quot;,&quot;Off&quot;) have fun!

perhaps is the column value &quot;toggle&quot; allready a boolean? Are you sure it is a numeric?

Thank you PowerObject & BetterLateThanNever! I turned arround both of your solutions. I started a bit like PowerObject's suggestion but tought that would make too much code. And also the script would be too dependent to the control names. Then I started like suggested by BetterLateThanNever. I...

... that's not complicated! BUT: How can I construct the checkbox's name at runtime? I have 640 checkboxes in a Window. They are called chck_1_1 / chck_1_2 / chck_1_3 .... chck_2_1 ... chck_32_20 I would like to read the state of all these checkboxes into a loop: For i=1 to 32 For j=1 to 20...

I can't belive it! That was the only problem! I transformed the function to a sub in one of my many tries. Thanks a lot Bart

Set Cbox = Me.Controls(&quot;my_control_box1&quot;) is an excellent idea. Thank you JohnYingling. I also tried Set Cbox = Me.my_control_box1 works also. When I call the function Public Sub load_values(ByRef cbox As ComboBox) like this load_values(Cbox) I get the error: &quot;Object...

Y is affected on execution time means that the value of Y changes when your program executes. The statement &quot;A = A & Y&quot; will put the value &quot;AY&quot; into the variable &quot;A&quot;, no matter if the content of Y changes after the statement... sorry for the syntax faults, I was a...

Yes, we are on the same frequency! I also tried your last suggestion and that gives exactly the same result. That what I try to do works with other 4GL environnements. But it seems that VBA interprets the my_combo_box1 reference to the actual active string value in state of to the object...

Y is affected on execution time! Try this: Do While Y <= 606 If Range(&quot;1:&quot; & Y) = 0 Then Range(A & &quot;:Q&quot; & Y).Select Range(&quot;Q&quot; & Y).Activate Selection.Delete Shift:=xlUp End If Range((&quot;1:&quot; & Y).Select Y = Y + 1 Loop...

Thank you segmentationfault. I tried that too, with no sucess, since 'my_control_box1' is a string for VBA (i.e, on execution time, the debugger does not show me an object for 'my_control_box1' but a string!) Our local time is 4.20PM. I would be so happy if I could go for the week-end after...

I thought that the following statements were trivial: Dim cbox As ComboBox cbox = my_control_box1 'my_control_box1 is a recognized ComboBox in a UserForm I want to pass the cbox variable to a function declared like this: Public Function load_values(Acbox As ComboBox) The problem: in...

Is the save path &quot;c\my directory\my file&quot; or &quot;c:\my directory\my file&quot;? That is very different (Tanks to our old DOS friend!) Try to start recording a new macro and do the save operation manualy. Then stop record the macro and read the code generated.

You should try this: Create a new RichText DataWindow. When creating this datawindow, in the SQL part: -select the table that contains the column varchar(2000) you want to display. -click that column -add an argument (eg &quot;argument_name&quot;) -in the where clause, add eg id=:argument_name...

Yes! Wonderfull! Cheerio: Your suggestion to work with a Worksheet object was the good one. That is of course much better than trying to work with the sheet's name. I did so because I started coding with recording macros and macros do not allways generate the best code! The Mac do not have an...

Thank you SB You are certainly right with &quot;the Mac treating focus differently&quot;. I tried out all your suggestions. Unfortunately, I still cannot find my ActiveSheet. My problem is: the VBA script inserts n new sheets (depending on a dialog box). Then, each sheet is treated...

Hello I'm new with VBA Excel. Could somebody explain how it comes that this statement: MyName = ActiveSheet.Name does what I expect with office 97 on W2k but does not work with Office2001 on Mac OS 9 It gives the following error: Run-time error '32809': &quot;Application-defined or...