Search results

Yes totally! It just takes me some time to understand everything you wanted because I'm a French guy!

Well, I'm a beginner so sorry about that!! This bug has been fixed and I want to thank you However another one will probably appear soon (I have to fix some bug and continue a data begun by someone else) and I hope that you will help me :)

This is not the entire code!

It's a column from a table like CLDT ord MNBR..

And....... No. The error still the same... I despaired.

I don't know you're probably right. Iwill try it now

Yes, I'm getting the value M794840 in the MOROUT's table because it is in the column "from value" (ORDNO). But the value associated to M794840 is equal to 0 in the other value (PRVAL) column

I've already tried it but without results...

"Some value" and "other value" are two column in the table named MOROUT.

Yes it is! PRVAL is a column in a table and some of rows are equal to zero. But they probably have to be equal to zero. So how resolve these problem??

Thank you about that. After using Debug.Print, I have in the immediate sheet this code: SELECT AMFLIBP_MOHRTG.* FROM AMFLIBP_MOHRTG WHERE (((AMFLIBP_MOHRTG.ORDNO)='M776430') AND ((AMFLIBP_MOHRTG.CLDT)=0)) UNION ALL SELECT AMFLIBP_MOROUT.* FROM AMFLIBP_MOROUT WHERE...

Hi everybody, How and why use "debug.print"? Thanks a lot

I've tried that pr2-eugin adviced me and nothing changed. The term 'PRVAL' is often equal to zero in my table, so maybe it's the reason of my problem.

It doesn't work but thanks. Does it help you If I post a screen shot about the local table to see what's happened?

Hi everybody, I have a problem when I launch my program, this error appears: "Syntax error (missing operator) in query expression 'AMFLIBP_MOROUT.ORDNO="M794840" AND AMFLIBP_MOROUT.PRVAL=' What can I do? What's the problem? Thanks a lot

Effectively I defined delquery as a string and you're totally right. I've tried different things but I haven't thought about the quotation marks. It works Thank you

Hi everybody, I would like to replace the following code delquery = "DELETE PPAPlinks.*, PPAPlinks.ILINK, PPAPlinks.REVN, PPAPlinks.PARTN, PPAPlinks.CREQ, PPAPlinks.ORDN " delquery = delquery & "FROM PPAPlinks " By another code like this: delquery = DELETE * FROM PPAPLinks But a message...

I tried to code the different flags like that: If ([flagblup] = 1 And [redticket] = "Blueprints") Or ([flagconp] = 1 And [redticket] = "Control Plan") Then Me.redticket.BackColor = RGB(237, 28, 36) Else Me.redticket.BackColor = RGB(255, 255, 255) I have this error: “Microsoft...

What can I do??

Hi, I have a problem when I launch my program. A word, MothPack (which is already defined) is highlighted and I have this Message : "Argument are not optional" What does it mean?? Where could be the problem? Thanks a lot