Forum Widgets
Latest Discussions
Access Error on File Import through VBA
We are running a custom VBA routine in Microsoft Access that imports and parses text files into a database. Starting around September 9th, some machines began showing an error dialog during this process. The dialog mentions a failure in the VBA Regular Expression engine. The error does not occur consistently. On the same machine, the import may succeed several times and then fail (roughly 1 out of 4 attempts). The behavior appears to vary depending on the input file. The VBA code itself has been unchanged for years and continues to function correctly on older builds. We are wondering if this is related to a recent update in Access or the VBA runtime. Has anyone else encountered this behavior, and are there known workarounds or fixes? Going to leave version numbers out of this post because it keeps getting deleted and I'm not sure why. This is my 4th or 5th attempt to write this post and it keep getting auto-moderated.JlorbzSep 24, 2025Copper Contributor44Views0likes3CommentsAccess Still Struggles on Data Import
More of a comment than anything else I have been a frequent flyer of Access since version 2.0. We used it almost daily for several years. I have since retired, and was away from it for a couple years now. However, due to a recent Office 365 account I started using again. One of the problems we had over the years with Access was on large data imports. This appears to be the same problem today as it was 30 years ago. Excel does not have this problem. Some of the same issues with Access "Does not recognize header name" Checking to insure header name was not a keyword and all rules were enforced, still did not allow the data to be imported. Since I needed to quickly turn around the information I had to link to an Excel file and run the queries. Pondering if MS has really done any improvments or serious upgrades with Access. I know programs cost resources to update. The other 3 Office apps have far more users than Access. I think Access is going to wither away within the next couple years. Was a great run when everything worked right. I have used a lot of different databases over the years. However, Access was the runt who was very user friendly and an awesome reports generator.Daryl WestSep 18, 2025Copper Contributor98Views0likes2CommentsApplication.SaveAsText posible Bug
I'm discovering the powerful Application.SaveAsText and LoadFromText methods, never used before, and found that Application.SaveAsText acTable,... always produces an Error 2.487: The Object Type argument for the action or method is blank or invalid The method works flawlessly with any other ObjectType. I've tested this behavior in a bare new accdb, with a single table in it, in three different systems (win10 & win11), all yielding the same result. My Access is 365 2508 (32 Bits) May someone check if it is a bug?SolvedJF_RuizSep 15, 2025Brass Contributor128Views0likes3CommentsAdding sub form for a new year
I am new to access. I have a new job to work on the database. I am attaching a copy of the page where there is the membership record and below there are several subforms. I would like to add a new subform of "2025-2026 Dues". There are forms for the previous years and I can copy them, but I don't know how to get them at the bottom ofthe page I have shown below. Can someone help me?viclea8Sep 13, 2025Copper Contributor279Views1like13CommentsVBA
Hello everyone, I'm new here, so please be kind! This happens every time I create a new file, and Visual Basic Editor won't open in Access. When I click on 'Visual Basic', a pop-up box appears and I'm told that the database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all codes from modules, forms and reports. You should backup your database before attempting to delete the VBA project. Note: To create a backup copy, click Cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK. Well, I have no database to read in the first place because I haven't made one, so what does it mean, and how do I fix this, please?NumSep 04, 2025Copper Contributor127Views0likes4CommentsAdding sub form for a new year
I am new to access. I have a new job to work on the database. I am attaching a copy of the page where there is the membership record and below there are several subforms. I would like to add a new subform of "2025-2026 Dues". There are forms for the previous years and I can copy them, but I don't know how to get them at the bottom ofthe page I have shown below. Can someone help me?rehanademon3Sep 02, 2025Copper Contributor47Views0likes1CommentPictures are not displayed in report
Hello, I have a serious problem in Access 2016. Our database is running on multiple machines. Most access databases are running without any problems but some access databases do not display the product pictures in reports (jpg format). The strange thing is that the pictures are displayed correctly within the forms. The pictures are not embedded but shown as link. Any ideas how to fix this? Tomwater645Aug 29, 2025Copper Contributor2.2KViews0likes4CommentsIn form or report design view, cannot paste objects
Hello all. I have used MS Access for over 20 years as a user (not developer). I like to design forms and reports from scratch (not using wizards), and it is handy to copy and paste objects in design mode. This includes controls, labels, lines, buttons, etc. For example, in a tabular transaction-type report, I can copy already-formatted controls from the detail to the report or group footer and just edit each to be a sum. For the last several months, I can click Copy on the bar (or ctrl +c), but the paste icon does not light up and ctrl + v does not work. Sometimes if I wait long enough (like several minutes later), the paste function becomes enabled. It takes me substantially longer now to add new objects from the Report Design bar and reformat them to match the existing report or form. I don't know if this is an Access issue or a clipboard issue. I am able to copy and paste large volumes of data with no problem at all. I am thinking about re-installing my Office 365 (which includes Access). Has anyone else had this problem, and is there a solution? The version I have is Access for Microsoft 365 MSO (Version 2503, Build 16.0.18623 20076 64-bit)BeanCounter0792Aug 27, 2025Copper Contributor662Views2likes15Comments
Resources
Tags
- access1,676 Topics
- office 365373 Topics
- 2016201 Topics
- developer197 Topics
- Access Web Database103 Topics
- Access Web App57 Topics
- sharepoint53 Topics
- 201352 Topics
- 201042 Topics
- admin42 Topics