VBA MSXML2.ServerXMLHTTP 401 Unauthorized error
I am using getTokenTemp Function to get Tocken Information based on ClientID, Secret and I am getting 401: Unauthorized error. Same URL/Client/Secret Information along with same header, if I put it in POSTMAN Client, I am getting Token Information successfully. What am I doing wrong here ? I am using MS Access VBA
Access Duplicate Table with properties like Lookup Field
Hi I have a table called “RA” and some fields are Lookup Field (hope it’s called that in english) so when I click on the cells in this column dropdown opens and I can select multiple things from another table.
I would like to duplicate the table “RA” 1-1 with properties, so if the table RA 2nd column is Lookup Field, the duplicate should also be Lookup Field.
I am quite new to access VBA and I have found a code on the internet. The table is duplicated but the properties Lookup Field etc. are not copied. I would appreciate some help.
Access Duplicate Table with properties like combination field
Hi I have a table called “RA” and some fields are combination fields (hope it’s called that in english) so when I click on the cells in this column dropdown opens and I can select multiple things from another table.
I would like to duplicate the table “RA” 1-1 with properties, so if the table RA 2nd column is combination field, the duplicate should also be combination field.
I am quite new to access VBA and I have found a code on the internet. The table is duplicated but the properties combination fields etc. are not copied. I would appreciate some help.
Ms Access db vab function not recognizing value of passed parameter
I have an accdb that was working fine for years and we somehow messed something up. We have a form. It has a button. It calls a function of vba code. The code dispays messages, run queries that create a table and finally CALL ANOTHER function that open an excel file from a shared drive location, refreshes the pivots and saves the file to another share location.
Search as you type text box in Microsoft Access
Access Form has on navigation buttons little search field, but it is small. I want to make text box with same functionality to search entire form and highlight what has found from VBA. Anyone has code for that? I love search field in navigation buttons, because is not searching one field from form or table, but everywhere. I want the same but from bigger text box with larger font.
Exporting MS Access Report to RTF using VBA WITHOUT DoCmd
Cannot figure out how to export report in MS Access to RTF file using VBA. I do not want to use DoCmd. I understand it should be using Scripting File System Object, but I don’t have enough knowledge in Access to figure out how to do it. Any input will be appreciated!
Error after UNION two tables in MS Access
After the UNION operation on two tables, instead of clickable attachments in the column appears the text “#error”. Tables are from different sources (both from .accbd file).
Dynamic update of combobox via AfterUpdate and Me.Requery
I’m currently tinkering with an Access app for practice and fun, but I’ve hit a snag and could use some help (I’ve attached the form with the issue to this post for reference)
Can anyone help me fix my VBA code: I am not sure what I am doing wrong but it doesnt seem to work
I cant seem to get this VBA code to work correctly and I get a variety of errors. I am trying to create a match score where different user preferences are given different weights and then an overall score is calculated
MS Access Undo change to field with VBA
I have a database mainly used for lookup and only occasionally edited. In order to avoid any unintended changes, I’m working on Popping a Prompt to confirm edits.