Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
0 answers
Error in Access when I am trying to open visual basics from event procedure
Hello, I have been struggling with this problem for over a week now. Whenever I want to edit my access file and write event procedure on certain control, it tries to open up visual basics but then just shuts down the whole program. I tried to figure out…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 33%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
How to view .SNP file
I have a number of files in .SNP format, which originally could be opened with the Microsoft Snapshot Viewer which was part of Microsoft Access. I cannot find a safe version of that program to download. How can I view these .SNP files now or convert them…
asked 2024-11-02T12:44:18.7533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 52%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Philip Cox
5
Reputation points
edited a comment 2024-11-02T16:39:36.0466667+00:00
Viorel
118K
Reputation points
4 answers
Starting applications from MsAccess VBA using shell, can take seconds !!
My MsAccess program is starting task using the VBA Shell version. Starting a program using shell() should take a couple of milliseconds, and sometimes it works that way, but frequently it takes seconds (3.5) !! Not workable at all! Some info: I am…
asked 2024-09-07T12:17:29.5433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 86%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL6%3C/text%3E%3C/svg%3E)
louis1-6497
0
Reputation points
edited the question 2024-11-02T08:55:30.6733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
simo-k
555
Reputation points
3 answers
One of the answers was accepted by the question author.
How do list results of a column in a table in one field separated by commas in MS Access
I would like to know how to get a column into a query field. Similar to how in Access if you use the multi-value field in MS Access. However, i do not wish to use the mutli-value. For example, if I had a table column1 with A C D F G (one…
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,174 questions
asked 2024-10-16T18:48:02.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
imodett
61
Reputation points
edited the question 2024-11-01T07:32:19.25+00:00
Emi Zhang-MSFT
25,546
Reputation points Microsoft Vendor
0 answers
How to get the *real* PID of a via VBA started asynchronous job !? (in order to monitor and/or stop that job)
I try to start and monitor asynchronous tasks from within MsAccess using VBA. (see question ^Starting applications from MsAccess VBA using shell, can take seconds !!^. The applications are started using ^PID = Shell("C:\WINDOWS\NOTEPAD.EXE",…
asked 2024-09-09T14:54:07.1266667+00:00
louis1-6497
0
Reputation points
edited the question 2024-10-31T16:15:36.4966667+00:00
simo-k
555
Reputation points
1 answer
VBA shell() does NOT return the exepected PID & ^Function CreateProcessA^ crashes Access
I am trying to start and control processes from and started by MsAccess. For that purpose I use the shell function. https://video2.skills-academy.com/en-us/office/vba/language/reference/user-interface-help/shell-function That function is supposed to return…
asked 2024-09-09T11:56:48.89+00:00
louis1-6497
0
Reputation points
edited the question 2024-10-30T15:13:21.28+00:00
simo-k
555
Reputation points
3 answers
One of the answers was accepted by the question author.
Active content in this file is blocked. Trust Center
I am trying to migrate several tables from Microsoft Access file located on channel into teams to Microsoft SharePoint online. When I try to do it using "DataBase tool" --> "SharePoint" and select the SharePoint site appears the…
Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
647 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,818 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,174 questions
asked 2023-07-24T11:26:34.7566667+00:00
Antonio Tudela
76
Reputation points
commented 2024-10-30T04:51:47.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 25%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Janatgul Mutawakil
0
Reputation points
0 answers
how to fix Correlation Id: cf8f29ef-766d-431a-9a43-617f414f2182 Timestamp: 2024-10-24T08:13:37.000Z DPTI: 10a2e99367304a3090864b886d59c26424c18ef4b5651b3aab6a3dd25df65b91 Error Tag: 7ita9 Error Code: 3399811147
Correlation Id: cf8f29ef-766d-431a-9a43-617f414f2182 Timestamp: 2024-10-24T08:13:37.000Z DPTI: 10a2e99367304a3090864b886d59c26424c18ef4b5651b3aab6a3dd25df65b91 Error Tag: 7ita9 Error Code: 3399811147
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,307 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
asked 2024-10-24T08:14:38.5733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 36%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
John
0
Reputation points
commented 2024-10-25T01:53:00.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 5%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Robin Sheng-MSFT
3,680
Reputation points Microsoft Vendor
0 answers
GoToRecord for tabbed form within Navigation Form
From the frmMainForm, I have 3 buttons; button one opens a tblTable1, button two opens frmForm2, and button three opens frmNavForm. My GoToRecord VBA works perfectly when just frmForm2 is opened, but it will not work when its under a tab in frmNavForm.…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 42%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
2 answers
How to get an Excel spreadsheet to display on an Access form
I have been using Access 2003 on a laptop but decided to move the application to another machine that has Microsoft 365. I have an Access form that displays an Excel spreadsheet - below is the image of it in Access 2003. In Access 2016 I can still…
asked 2023-06-19T08:03:44.0866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 73%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Colin B
0
Reputation points
commented 2024-10-23T20:44:00.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 11%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Adelina Trandafir
0
Reputation points
0 answers
Cannot cancel security change request
Hi All, Initially I had some issues accessing the mail id associated with my google account, so I tried to change the mail id associated with my Azure account. However , later the issue with mail id has been resolved and I can access the mail id. Now…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 99%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
How to suppress a dialog box, shown below
Office 365. Have a word doc that is merged to a query in access, using the command: MergeSingleWord "C:\Users\nevadamax\OneDrive\Documents\BudgetCorp\NewBudgetCorpDocs", True Where MergeSingleWord is a procedure: Public Function…
asked 2024-10-10T18:35:50.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 84%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Maxine Nietz
1
Reputation point
commented 2024-10-21T02:32:56.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
10,645
Reputation points Microsoft Vendor
0 answers
I am trying to fill up fields on a document in word from my access database and I keep getting errors. I have added an image that shows me an invalid merge field. Kindly assist, as this is quite urgent ans important. Any help is appreciated. Thanks!
I am trying to fill up fields on a document in word from my access database and I keep getting errors. I have added an image that shows me an invalid merge field. Kindly assist, as this is quite urgent ans important. Any help is appreciated. Thanks! I…
asked 2024-10-15T20:59:13.9266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 63%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jan Banker
0
Reputation points
commented 2024-10-16T06:48:03.83+00:00
Emi Zhang-MSFT
25,546
Reputation points Microsoft Vendor
0 answers
What can I do if there is no answear after submitting the verification form? How can I get back my account?
My hotmail account is blocked by Microsoft. I have submited the form for verification. It was promised that the result will arrive to my contact e-mail account in 24 hrs. It was 3 days ago, but no answer. What can I do if there is no answear after…
asked 2024-10-12T19:07:20.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 12%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TamTamTam1
0
Reputation points
asked 2024-10-12T19:07:20.1766667+00:00
TamTamTam1
0
Reputation points
0 answers
Column Designation error
I have a list box (ERPNewOrderList) on a form (AddNewOrders). The rowsource for the list box is a query: Column(0): SONo: [SalesOrderID] & "." & [SOLineNbr] where [SalesOrderID] datatype is ShortText and [SOLineNbr] datatype is Number…
asked 2024-10-11T21:13:09.46+00:00
Maxine Nietz
1
Reputation point
asked 2024-10-11T21:13:09.46+00:00
Maxine Nietz
1
Reputation point
0 answers
Error Message: Grant Access - Additional Permissions are needed to access the following file
The last update of Microsoft 365 has screwed up my computer and I cannot access the files that I have created with Word. Please help! I am using version 16:89.1 of Office.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 57.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
3 answers
How do I fix the OLE Object in Access Error 3118?
Cannot join on Memo or OLE Object <name>. (Error 3118)
asked 2024-10-03T17:53:14.9933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 21%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
April Kurtz
0
Reputation points
edited an answer 2024-10-05T15:32:38.2266667+00:00
Ken Sheridan
2,841
Reputation points
2 answers
One of the answers was accepted by the question author.
Access error "This database is in an unrecognized format"
When open a Access file, get the error "This database is in an unrecognized format". Can anybody help?
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,174 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 91%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E89%3C/text%3E%3C/svg%3E)
1 answer
graph.microsoft.com api to raise group access request that can though myaccess.microsoft.com approval process
I want to use myaccess.microsoft.com programmatically. but it do't have apis, it say that i can use graph.microsoft.com api . but when i am using graph.microsoft.com api , it give below error. i want to use graph.microsoft.com api to raise group access…
asked 2024-09-17T20:49:55.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 31%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Garothaya, Sanjay
0
Reputation points
commented 2024-10-01T09:37:48.44+00:00
CarlZhao-MSFT
42,451
Reputation points
4 answers
One of the answers was accepted by the question author.
How do I close orphan database connections?
The last step in my Access application (before DoCmd.Quit) is to close the connection to the backend database on the network drive, as follows: This has always worked until one of the workstations was upgraded to Windows 11. Now when that workstation…
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,174 questions
asked 2024-09-08T16:49:41.33+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DarrellDoesData
20
Reputation points
edited the question 2024-10-01T07:20:27.4666667+00:00
Emi Zhang-MSFT
25,546
Reputation points Microsoft Vendor