Search results

Change the Control Source of a TextBox in a report. Like the one shown in this image: Screen capture My aim is to exclude from this control results that are compabtile with the string above depicted so I've written: =[FormaPago] <> "Transferencias SVS-Mutuas" But it does not work. So my...

Hi! But Can I put that parameter query in a subform? Or within a button to change the SQL of the subform?

Hello! I have a form (A) that contains a subform (B). Now, the B shows registers from a query that is defined with an SQL. I would like to make this SQL change on order to contrain the dates of the registers shown. In other words: Now the subform (B) shows registers from dates fixed in its SQL...

Thaks guys, you gave the clue to solve this. Function OpenCommDlg(ByVal DirBusqueda As String), far from being a default VBA Function, is a Function added to the project by another programmer. Soo...I only had to change the default path created there to achieve my aim.

Hi! I'm trying to open the file browser from VBA with this code: Dim S As String S = OpenCommDlg("Magazine.txt") And It's ok but it opens the window of the "C:\A\B" Path And I want it to open "C:" path No way to change it giving that path to the function... Any idea?

Hello, I'm trying to obtain two codes from this string: "HL PNX-70[15200]" But with this code, I obtain two times the same output: "HL PNX-70". So, the code is not properly done. How to obtain the output '15200' from the above mentioned String? Private Sub Comando221_Click() MsgBox...

We are coding a B2B connection from our VBA Access application to a WebService. Everything seems to run properly at the beginning but an extremely confusing message pops up in the midst of this process. Please, see attached screenshot: The code we're using is: oHTTP.Open "POST"...

Hi guys, thanks for your answers. But the project has been shut down, so...Till next time. Even thou, your last points have been very helpful!

filtro equals to a certain date, for instance: 02/01/19. Len is the name of a Table. If I debug print this SQL statement...nothing is depicted.

I'm trying to find out why this is wrong, while in the queries generator it works properly. SELECT Count(Audi.Id) AS CuentaDeId FROM Audi WHERE (((Len." & filtro & ") Between #" & Format(Me!fechamin, "mm/dd/yyyy") & "# And #" & Format(Me!fechamax, "mm/dd/yyyy") & "#)) With some dates slightly...

Brilliant! It worked properly. You are a genius MajP

From CodProduct, just edited now.

Hello everybody, I have a table in Access that shows products and its associated codes. Each product should have a code, but sometimes users make a mistake and give the same code to two different products. I call this the "duplication mistake" To that extent, everything is normal. The...

Finally, I've decided to create new forms, each one with its own SQL-generated tables. So, I can call data easily, despite the creation of more forms...

Yes. I've just edited the message to correct it. Still...the problem remains. How to properly do this filtering?

Thumbs up! : )

Thanks! It has been THE SOLUTION. Now my report works fine thanks to your clues and help. Tumbs up!

Thanks! It has been a pair of good solutions!

Hello, I have a form in Access where I can select some products. When I click a button, a new form is opened and I can see all my products of a brand. As you can see in this screen capture: Then, when the button "See" is clicked, a new form is opened and the table inside it is set up. It's...

I have several records that include some text between square brackets --> aaaaaa[aaaaa]. I need to erase that extra content, square brackets included. The String in the example would turn out to be: aaaaaa I'm trying this code: Dim sqr as Integer Dim origin as String Dim result as String...