Search results

What does the Long Binary Data holds, image, pdf, what?

add to Attachment your COM library. add also a command file (Register.cmd): @ECHO OFF reg Query "HKLM\Hardware\Description\System\CentralProcessor\0" | find /i "x86" > NUL && set OS=32BIT || set OS=64BIT "%SystemRoot%\Microsoft.NET\Framework\v4.0.30319\regasm.exe" /unregister...

you need these steps. 1. copy the MySockectConnector.dll to an Attachment field 2. on opening the db, check if the Library is already registered if already registered, exit the sub/function. 3. if not registered, copy it from Attachment content to any folder (or temp folder) 4. using an Elevated...

you can Save all Reference to a Table (including the GUID). when you copy and Open the new db, there will be a startup code. to AddReference by GUID. ' Export all reference information to a table Public Sub ExportReferencesToTable() Dim db As DAO.Database Dim rs As DAO.Recordset...

i change the combo to also show the Stock_Name when it dropdown.

create a query from investment table and remove unnecessary fields in brokerage table.

as suggested, put this code in subform ItemDetail: Public Sub AddItem(ID As Long, strITPath As String) Dim rst As DAO.Recordset Dim strCriteria As String Dim lngDocNo As Integer strCriteria = "flocID = " & ID Set rst = Me.RecordsetClone...

maybe change it to like this: Public Sub AddItem(ID As Long, strITPath As String) Dim rst As DAO.Recordset Dim strCriteria As String Dim lngDocNo As Integer strCriteria = "flocID = " & ID Set rst =...

this will handle your Parameter, change the code to this one: '============================================= ' Export Table or Query to CSV using raw file I/O '============================================= Public Sub ExportToCSVRaw(ByVal SourceName As String, Optional ByVal OutputPath As...

can you try manual export using VBA: '============================================= ' Export Table or Query to CSV using raw file I/O '============================================= Public Sub ExportToCSVRaw(ByVal SourceName As String, Optional ByVal OutputPath As String = "") ' SourceName...

concur, you need to go to the Bookmark (Lastmodified record). ... ... rs.Update rs,BookMark = rs.LastModified InserisciRecordPrincipale = rs("ID_FERICEVUTE")

maybe you can find what you need to accomplished on the sample database. Open MainForm form.

With Request .Open "POST", stUrl, False .setRequestHeader "Content-Type", "application/json" .setTimeouts 5000, 5000, 5000, 5000 ' connect, send, receive, resolve .Send requestBody If .Status = 200 Then Response = .ResponseText...

maybe use VBA, to clearly see what you are doing: ' duplicate record Private Sub cmdDuplicate_Click() Dim bolPrevState As Boolean If Me.NewRecord Then ' exit if on new record Exit Sub End If ' save prevous state of allowEdits bolPrevState = Me.AllowEdits...

you can use DateSerial(), you can also use CDate() function: CDate([Forms]![BankTransactions]![ComboYear] & "-1-1")

i agree that the blur is not pleasant to the eyes. but you may try to increase the blur radius, say 20 instead of 5, and you will see it is more pleasant.

create sub reports..

in case there is no transaction yet on the table, you can also use as Default value: Nz(DMax("TransDate","TblTrans"),Date())

i think it is overkill. you can use ado/dao recordset object.

It is sometimes desirable to darken the background when a Msgbox appears so as to catch the attention to the presented message or warning. This is not new, but just wanted to share if it can be of use to you. The code can be used on older Ms Access. Open frmDemo on the attached.