Search results

Hello, I have made a strSQL that returns a textfield. My question is: * how can I place te result of this query in a msgbox? * if the result of this SQL is zero records how can I cancel this msgbox? Thanks in advance, Sven.

Hi, I agree, the code can be boiled but the thing is why can't access find the query? (I can run the query in the query screen) ... Has it something to do with the fact that I am working with an adp project? If not, what can be the reason? Best regards, Sven.

Hello, I have made a simple query (test) and put in the open report event the code: me.recordsource = "test" Also then I get an error can't find the recordsource test ... What can be the problem?

Hello, i did the copy paste, the name is correct ... this is the code: Private Sub Report_Open(Cancel As Integer) DoCmd.Echo False DoCmd.Maximize Select Case [Forms]![FrmRapportering]![cbomachine] Case "PM1" Select Case...

Hello, I have the code on the open report event. The fault that I get is that the query doesn't exist ...

Hello, How can you change the recordsource of a report by vba refering to a query? The folowing isn't working: me.recordsource = "My query" ... Can somebody help me with the correct vba code. Thanks in advance, Sven.

Hello, I don't know really that this is possible or not but my question is: table jumbo table jumbomeasurement 1 1 11mm 2 1 8m 3 1 14l 4 2 6mm 5...

Hello, I'm working with FE access and BE SQL server ... and I have made a query like: SELECT TOP 100 PERCENT dbo.TblMoederrollen.Moederrolnummer, dbo.TblMoederrollen.Datum, dbo.TblPapiersoorten.Papiersoort ... etc. When I change the 100 percent into 5 percent I only het 1 recordline...

Hello, good news ... very good news the second thought did the trick: In the VBA editor: Tools> Options > General Tab > Error Handling ... verify the selection is appropriate (typically Break on Unhandled Errors) I would never solved this problem alone ... thank you very much!! Best...

Hello, on the report no data event I have the following code: Dim Lresponse As Integer Cancel = True Lresponse = MsgBox("Met de opgegeven parameters is er geen data gevonden!" & _ vbCrLf & "Het rapport wordt hiermee afgesloten.", vbOKOnly Or vbExclamation, "Rapport") this msgbox is displayed...

Hello, I hav a working report with a recordsource like: Dim strSQL As String strSQL = " SELECT " strSQL = strSQL & " TblMachine.Machinenaam, TblMoederrollen.Datum, TblMoederrollen.Moederrolnummer, TblPapiersoorten.Papiersoort, TblPapiersoorten.Gramgewicht," strSQL = strSQL &...

Hello, I still get the error 2501 and if I put a msgbox after the line If Err.Number = 2501 Then msgbox "2501" then the msgbox is not appearing So, I get an error 2501 but the errorhandler is not catching this error ??

Hello, for the first time I am working with an BE SQL server and now I have the following problem. I want to cancel the command cmd.openreport when there is no data. Normaly i use on the report --> cancel = true And behind the button the following code: Private Sub cmdPrint_Click()...

Hello, after changing an mdb to an adp project the calculator that we are using in access is not working anymore. The reason for this error is the fact that this calculator uses dao reference. The code where is goes wrong is: Private Function checkproperty(strPropName As String) As Variant...

found it cdbl ...

Hello, I want to check a value if it is between limits like: If (CInt(Me.txtcontroleint) >= CInt(Me.txtminimum)) And (CInt(Me.txtcontroleint) <= CInt(Me.txtmaximum)) Then Now it is so when I use the Cint function with the value 99,99 it becomes 100 and I don't want that to happen. Is there...

Hello, is there a possibility to protect an ADP frontend from opening with the shift key? I have found something to protect an mdb but this isn't working with a adp project. Thanks in advance, Sven.

Hello, about the field, it is an independent field and I am using access 2002 SP3. When I am using "," it works fine ... when I am using a "." it goes wrong ...

Hello, i have done some testing and when you put immediately a dot in the number it goes wrong. (See example). What is the reason that this goes wrong? Best regards, Sven.

Hello, indeed, you are right ... it works fine on a testcase but not in my application it isn't. Very strange??? I am working with an adp project and I want to fill a table. Before I run the SQL I want to make sure that the layout of the number is correct. I mean use a dot and not more than...