Search results for query: add attachments

i have a main table with one of the 2 data type when i add these 2 fields into a form, one of these 2 acts very wierd for me. it adds "FileData" into a countrol source without me wanting it. when i manually go to change countrol sourse it already set *FileData to it. and chaning it...

Hi all, Just updated to Office 2019. Already regret doing so TBH. :( I have found out how to add commands to the QA toolbar in Excel, (same as in 2007), however a good few are not presented, so as to be able to add them? I have a Personal.xlsb with commands I can use anywhere. One is a macro...

Hello, I want to list Add-In Manager dialog box and know is some elements are activate. After, Activate and desactivate, here for VBA MZ-Tools . Thanks to help

Hi I am trying to check if an attachment exists on a recordset2 record and if it does remove the field contents and then add a new attachment to the same record so I Only have the one attachment entry on the record. My code is giving me two problems: 1. The If statement If .Fields("Logo").Type =...

Dears; good afternoon; i would like to seek your support. as i have created a form to track medication taken from storage. so i want when i scan the item name twice, the quantity changes from default 1 to 2. Form name: Data entry as the user will just scan the barcode to add the item. how...

Hi, It's about how to add/edit records in a subform. The first attachment contains the subform which is inside the main form (-> the second attachment). There are two tables, tblProjects and tbl ProjectPayments in one-to-many relationship (-> the third attachment). The projects will last about...

Autonumbering is not working at all. Just tried to add another record and I got the duplicate values error.

Here is an example from the web. They used unbound controls at the top of the form to add records. You could do something similar to show last entered record or add record.

This is weird. I tried to add a manual entry and it worked. Maybe I'm missing something in my code.

Is actually added

Is there any way to keep the standard navigation buttons, but hide the Add New Blank Record button. I know I set Navigation Buttons = No and hide all the buttons, but I would prefer not to do that - it also hides the No Filter and Search buttons, but I could work around that. I have...

add Reference in VBA: or manually add Reference: C:\Program Files\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL

you can try this: add code to the Load Event of the Main Form: Private Sub Form_Load() Me.TheMondaySubFormNameHere.Form.DatasheetBackColor = 13434879 End Sub

Hi Majp, If I add Private UsedValues As New dictionary after option explicit then error:

I normally keep the Immediate window open (as I use it all the time) & add the locals / watch windows as required. You can dock the various windows in your preferred location - see the Tools ...Options menu in the VBE

Dears; I have created a form and subform to track stocks movement. so in subform there is list box if items, once user double click on , it copy the data to new record in subform. but i want the below: 1- Field Number to be updated with serial Number starting from 1. 2- Record count show...

I have a custom ribbon for my apps with an "Admin" tab that's only available when a developer logs in. I'm trying to add the "Add-Ins" menu, but I can't find the idMso for Add-Ins. Does anyone know Add-Ins' idMso? (the following menu marked in red) Thanks.

Hi If you base the Main Form on a Select Query then you can add the criteria. See the attached FRiskPage