Search results

Hi I have created a program with Access Vba. When I launch it on my computer it works but when I tried to launch it in another one a I have error: "Execution of this application has stopped due a tun-time error. The application ccan't continue and will be shut down" I only can click on OK and...

Hi there, I have a database and I would like to link a PDF to the main interface of the database with a Help button. Could you tell me how I can code that?? Thank you!

Hi there, I have little texttbox in the report named Mainreport. I have some requirements like "control plan"... What I want is when a requirement is missing the little textbox is colored in red. I try this code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) 'GetRGB...

Hi there, I have a list box and I would like to highlight 2 expressions in green in the report where these 2 expressions appear. Could you help me please?? Thanks a lot!

Hi there, I have a report which retrieve some links of documents in the textbox linksassociated. I would like to have a message box which tell me when the linksassociated has no value " No value for your link". I tried this: If IsEmpty(linksassociated) Then MsgBox "No link has been found...

Hi there, I have a report named Link_report which retrieve links to find some documents. I would like to add a Msgbox to say: " No link has been found for this document" when the case link is empty. Could you tell me how? Thank you

Hi there, I have a table named PPAPslinks which retrieve links about some documents located on my network. I also have a report named link to retrieve the links. The problem is that I have the links on my table named PPAPlinks but I can't retrieve them on my report link. Could you help me...

Hi there, I have on the main form a list box containing a list of requirement. I can select each requirement by clicking on them one by one. However I would like to select all of them with using click and shift. What is the property which control that? Could help me? Thanks a lot!

Hi there, I would like to separate my list box in two categories. Indeed it is composed by 2 types of criteria but arranged in the same List box (I can't create another List box, it's forbidden). Do you know how can I proceed? I've thought to insert a dash but it has to appear all the time...

Hi there, I have a problem with my program. Indeed, when I launch it, the error is "Data mismatch is this criteria". You can see the following code: Sub MotherPacketOP(MNbr As String, LATDT As String, CLDT As String, PRVAL As String, ASTDT As String) Dim strSQL1 As String Dim rst As...

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

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

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

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

Hi, I have this following problem: I want to pogram a textbox. In the expression builder of the properties sheet's control source I've programmed this following code: =IIf([word1] Or [word2]=1,1,0) It works. But I have to add 37 other "words" and I can not. I tried: =IIf([word1]...

Hi, I have a problem when I use the RGB's function. Indeed I used it in the three following parts "On format", "on paint", "on print". However the form's sheet flashes when I launch the program and I don't know why. The Code is : Private Sub Detail_Format(Cancel As Integer, FormatCount...

Hi, I'm a french student so pardon my english! In a report VBA sheet I used flag like that : 'set flag textbox as value of table and catch null value by Nz flagconp = Nz(DLookup("[CONP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0) flagblup = Nz(DLookup("[BLUP]", "Temp_Bom"...

Hi everybody, I'm a begginer and I need your help... The following search operation have to search some operation in the database, but there is a bug and I don't know why... Could somebody help me?? Thanks a lot.

Hi, I'm a french student so pardon my english! In a report VBA sheet I used flag like that : 'set flag textbox as value of table and catch null value by Nz flagconp = Nz(DLookup("[CONP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0) flagblup = Nz(DLookup("[BLUP]", "Temp_Bom"...