Recent content by bbfromgb

The captions within the pdf are different to those of the .jpg; I assume this might be the issue

Hi Jason, Thank you for providing a 32bit-compatible version, works like expected.

Hi Jason, this version does not work within an Access 32bit environment due to LongLong parameter definitions. Regards Bernd

if Planning.Bestelbon is not of type "Text", try a type conversion for Me.txtSearch sql = "SELECT Bestelbon, Productnaam FROM (Planning INNER JOIN Tanks " & _<br><br> "ON Planning.Productcode = Tanks.Productcode) WHERE Planning.Bestelbon = " & clng(Me.txtSearch) & ""

put a breakpoint in your code after the sql instruction and inspect sql string in the direct window. copy the output in the SQL section of the Query designer and run as a query

when Planning.Bestelbon is of type "Text" then try sql = "SELECT Bestelbon, Productnaam FROM Planning INNER JOIN Tanks " & _ "ON Planning.Productcode = Tanks.Productcode WHERE Planning.Bestelbon = '" & Me.txtSearch & "'"

MS Help for Access states: If you use the CloseCurrentDatabase method to close the database that is open in the current instance of Microsoft Access, you can then open a different database without having to create another instance of Microsoft Access. MS Help states for creating the new...

have a look at Daniel Pinault's excellent paper on Subclassing Forms (w_w_w.devhut.net/microsoft-access-form-subclassing-101/) as an idea. He also provided a youtube video on that topic Greetings Bernd

have look at javaprogrammingforums.com

you may use this function provided by ChatGPT: Public Function ActiveAdapter() As String '--------------------------------------------------------------------------------------- ' Procedure : ActiveAdapter ' Author : ChatGPT modified: bbfromgb ' Date : 19.06.2025 ' Purpose : find...

For Access transactions checkout sonic8's recommendations on transactions on codekabinett.com ((sorry, cannont post the full link)

you may try:month(datevalue("31/01/2025"))

I ran into the truncation problem as well and the only simple but dirty solution for me was to force a 'Home' keystroke after displaying the File Dialogue: Set objFileDialog = Application.FileDialog(3) ' msoFileDialogFilePicker = 3 objFileDialog.AllowMultiSelect = False '...

I'm happy to join the community now, the earlier posts helped me pretty often to solve problems with access I ran into......:cool: